Solved

Stock status report as of end of the month

  • 5 November 2020
  • 2 replies
  • 80 views

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?

icon

Best answer by vkumar 6 November 2020, 03:55

Hi @elena52 

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. 

https://help-2020r2.acumatica.com/(W(10))/Help?ScreenId=ShowWiki&pageid=6e75c202-2d22-4750-a543-26a03c493245

Hope this helps,

Regards,

View original

2 replies

Userlevel 5
Badge +5

Hi @elena52 

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. 

https://help-2020r2.acumatica.com/(W(10))/Help?ScreenId=ShowWiki&pageid=6e75c202-2d22-4750-a543-26a03c493245

Hope this helps,

Regards,

Its a comlex one and confusing from the start. This will work for my auditors. Thank you so much!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved