By using this website, you agree to our Terms of Use (click here)
I have a discrepancy between the numbers from Trial Balance and inventory valuation. Is there a report like the AP or AR module that I could see the difference?
Not that I know of unfortunately. The Discrepancy by Account (AP409010) and Discrepancy by Account (AR409010) screens are nice. It would be great if Acumatica extended them into the Inventory module.
I don't have a report already made, but for reconciliation situations like this, I like creating a report that pulls from the General Ledger and Inventory, then groups by Date. When you compare the two side-by-side, at least it allows you to see on which day the discrepancy occurred which means less transactions to sift through.
Another idea to catch discrepancies faster is to drop them on a Stuff That Should Never Happen Dashboard (click here).