Note: Current version is 4.4, going to Sage 2015 live this weekend.
This is regarding items with all IM_ItemCost records having zero quantity (meaning, Negative cost tiers, if any, have been applied), yet one of the records has and extended value cost. Of all these items, extended cost values range from .01 to large amounts. This has occurred on hundreds of records, many, but not all are OVERDIST receipt records.
The result is that zero quantity on hand records are carrying value in the IM_ItemCost and IM_ItemWarehouse files.
I am considering using VI to change these zero quantity records to zero extended cost.
Questions:
1) What solution do you suggest to get these extended cost values to zero?
2) Any suggestions to avoid this in the future?