Sage 100

Customer just upgraded to v2018 Premium and is seeing zero quantity lines in their Valuation report (when they choose to not show zero quantity lines), which we've encountered with upgrades before. The difference here is that these are for Standard Cost items (when we normally see this with cost tiers). The IM_ItemWarehouse ""TotalWarehouseValue"" field is non-zero for the zero quantity items showing on the report, and looking at transaction history the calculated $ value is indeed non-zero. So far I see a few patterns (in 1600+ items) with bad costs: IX (balances carried forward during an item history purge), Standard Cost Adjustments, returns and transfers. (In the image ""BadAmount"" is the TotalWarehouseValue for the item). We've had to run the IM Recalculate utility for this customer, and I'm wondering if such issues with TotalWarehouseValue are ""known""...?

Looks like the Recalculate IM utility uses the wrong column for determining TotalWarehouseValue with Standard valuation. Adding another column to my query shows the data is there... just not used. (Reporting it to Sage).

I wonder, is this v2018 only or all version of the Recalculate IM utility?

It seemed fine when I tested with ABC on my local v2017 Standard.