Inventory value with zero quantity using FIFO

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?

  • 0

    This normally happens when you sell products you do not have in stock. Say you sell at item that is not in stock at a price of $100 the next day you receive in the item but at a price at $110. You have two tiers, one positive and one negative and the result shows correctly as zero (0) on hand but you now have a value of $10. This is why it is best not to invoice where there is no product. You are going to have to do a negative tier adjustment to get rid of all these. DO NOT use VI to try to change things. You will just blow everything up worse.