Skip to main content
Solved

Stock status report as of end of the month

  • 5 November 2020
  • 2 replies
  • 255 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?

Best answer by vkumar

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
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • Answer
  • November 6, 2020

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,


  • Author
  • Freshman I
  • 1 reply
  • November 6, 2020

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings