By using this website, you agree to our Terms of Use (click here)
We are comparing these two reports as I mentioned and noticed that they do not match with the Inventory Account. Is it possible that they could be calculating a different way for each other? It always seems that the Historical Inventory Balance is always about $120,000.00 less than the other. We have compared multiple reports multiple times and keep coming up with the same result. We have compared inventory items within the two reports and they seem to match, but something is still off. I have checked how the report is designed in the report designer and cannot come up with any solutions. Does anyone else seem to have this problem, idea, or are we completely missing something?
I should have mentioned for an example that for every period we check and compare that the Historical Inventory Valuation Report is always the same amount lessor in the same range (i.e. $100,000.00) than the Account Details report.
So your General Ledger module balance doesn't equal your Inventory module balance?
I would go financial period by financial period until you find the first one where it occurred. It could have been a manual journal entry made to the Inventory GL Account. That would throw the General Ledger and Inventory modules out-of-balance.