Question

Simple Month End Inventory Valuation

  • 22 July 2021
  • 3 replies
  • 53 views

I have currently been using the historical inventory valuation for reporting month inventory values. This report needs to tie to the the balance in my inventory account. To accomplish this, I am having to the use a start period that is the beginning of time to the current period. The report size gets larger and larger every month due to an additional months data being added.

 

Are there any reports that can be run that do not include each months transaction details? Ideally, I would only need 4 columns:

Inventory ID, Description, Quantity on Hand & Value for any given historical period.

 

Any input would be appreciated!


3 replies

Userlevel 2
Badge

Hi, we usually use Inventory Valuation report to reconcile inventory value against GL for the current month. And use Historical Inventory Valuation to see the inventory value in previous period. If you want to only see the value on certain month you could simply choose the same month in Start Period and To Period or modify the report to only show one Period parameter to avoid printing the report from the beginning of time.

 

 

Thanks for the response.

I am normally using this report after our month end close, which last 10 business day. If I run the report for the previous month only (start period and end period are the same), the report does NOT tie to my general ledger balance.

However, when I run a beginning of time start date to the ending period, the report ties to my GL. 

I may not have a fundamental understanding of what this report shows. Shouldn’t both of these reports tie regardless of the starting period?

 

 

 

Userlevel 2
Badge

If the end period is set the same they both should return the same ending balance of inventory. Note that the historical inventory valuation also groups the report based on account and subaccount so it might be due to the figure you see on the second screen shot is ending balance for of the inventory account. 

Otherwise, I would try to replace the report with original report from a new fresh Acumatica site without any modification made to it and see the result (maybe the reportyou are using has been modified from the original). If this still shows different figure, I would open a new support case.

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