The Posted Inventory Tran BIE shows all inventory transactions since the beginning of time. We have never purged data. The Inventory History BIE shows ending inventory dollar values for every item-warehouse combination for every period.
In comparing these two BI reports I expect that they would tie out, but they don't.
For example, if I filter the Posted Invt Tran report to show every transaction prior to 9/1/15, and I SUM the TranAmt column, I would expect that value would match the value I see in the Inventory History report if I filter the Inventory History report to show only values for August 2015, and I then SUM the Value column in that report.
Has anyone seen a situation where these two reports don't tie out as you would expect? If so, did you ever get to the bottom of it?
Using v7.60.6. Problem is seen in companies using Standard Cost as well as one using Avg Cost.
Thanks.