I need to create a custom report that includes the IM_ItemCost table. The first thing I need to confirm is that my results when querying the raw data of IM_ItemCost matches the standard inventory valuation report in Sage. I'm totaling the ExtendedCost field in the table but am coming up with a small difference when comparing it to the total of the Inventory Valuation Report.
I thought it might be to due to the ItemCost table having zero qtys with a value of couple cents for multiple items, but I've found that's not the case. Just wondering if anyone has come acrross this before? THanks in advance for any help!