Sage 100

In the quest to figure out why tiers get out of balance on IM_ItemCost - one of my end users sent the following: 1. IM_ItemCost table query of: Item Code Lot Serial No Quantity Committed 2. SO_SalesOrderTierDistribution table query of: Item Code Lot Serial No Quantity Ordered 3. If Sum formula of quantity by lot from the SO_SalesOrderTierDistribution table query to the IM_ItemCost table query. 4. Once I have my totals for each I get a difference column to find my variances. 5. Anything other than ZERO is off. 6. Go into Data file maintenance - ItemCost table and make my changes according to what should be in SO_SalesOrderTierDistribution in yellow below. I am pretty sure we tried all the balancing and rebuild sort utilities and for some reason the utilities did not automatically recompute the IM_ItemCost from the value in SO_SalesOrderTierDistribution.

What does the SO transaction type from IM Transaction history total out to be? That would be a better comparison to me.

I'm not sure - from what the user had been doing it sounds as if these are the only two files he uses to reconcile. I think the main issue is that IM_ItemCost doesn't have the Quantity Committed recomputed by a sort file rebuild or any of the hidden inventory utilities.

Along that line then, the cost in Sales Order invoice is not written until the journal is run and updated. Also, I've seen situations where the compare of the item cost file to the stock and warehouse files will show a cost difference due to decimal places.