Sage 100

v2015 standard - When you run ""recalculate Item history"" from the Inventory, Utilities menu, what table does the rebuild program use to recalculate the quantity sold? User has several items in January 2017 that have an incorrect quantity sold. For example, one item shows 56 sold but when I run the Inventory Detail transaction report for January there are 37 sold.

period summary history

IM_ItemWhseHistoryByPeriod is the table that gets recalculated. What table do the numbers come from that populated IM_ItemWhseHistoryByPeriods? Example attached. The qty sold in 1/2017 shows 53. The detail transactions calculate to 34. I change the 53 in DFDM to 0, then run recalculate Item history and the 53 returns. Where does the ""53"" come from?

I believe the IM rebuild utilities use the IM_ItemTransactionHistory / IM_LotSerialTransactionHistory tables to recalculate the values.

Thanks for the responses. I created a crystal report for both IM_ItemTransactionHistory and IM_LotSerialTransactionHistory. I couldn't get the sales to tie out. I finally called Sage. There are two files used to calculate the item history when running the Recalculate Item History utility in Inventory Management: IM_ItemTransactionHistory.m4t and IM_ItemTransactionRecalc.m4t. There are several records with a transaction date of 2014 in IM_ItemTransactionRecalc.m4t that were posted to period one of 2017. Sage sent me the attached KB article. Now comes the battle to find out how much damage was done.