Hello, I am looking for a report that can tie to the balance sheet as of the end of the month. In Sage 100 it was called Stock Status report as of end of the month. How else you can tie Inventory GL amount on the balance sheet to the Inventory module? What are Acumatica’s users are using?
Inventory valuation report shows data on the day you are running the report, its impossible to run back. what should we do?
Best answer by vkumar
You can run Historical Inventory Valuation (IN617000) report for reconciliation purpose and to get month end (or any prior date) Inventory number and value.
Refer to this documentation link which explains the reconciliation process of Cost of inventory with GL balance.
Hope this helps,