Add Date Range Inventory Valuation report (IN615500)

Hi ​@tharinduweerasooriya90 

You can modify the IN615500 report by joining the INItemCostHistByPeriod table to retrieve inventory data by period. The INItemCostHistByPeriod table will then become the main table. Please refer to the screenshots below.

Best Regards,

NNT

Hi ​@nhatnghetinh ,

You might take a look at the Historical Inventory Valuation Report (IN617000) which is configured OOB to provide the inventory valuation as of a specific date.

Hope this helps!

Laura 

Hi ​@tharinduweerasooriya90 

In the standard Inventory Valuation report (IN615500), valuation is calculated as of a specific financial period or date using the inventory costing engine. It is not designed to be filtered directly by fields such as INCostStatus.ReceiptDate.

The correct way to get inventory valuation as of a specific date is to use the Financial Period or As Of Date parameter provided in the standard report. Acumatica reconstructs inventory balances based on transaction history (INTran) and cost layers up to the selected date or period.

If you need valuation for a date range, inventory valuation should be treated as a snapshot report. You would typically compare the ending inventory value as of the end date with the value as of the start date, rather than filtering cost layers by receipt date.

So filtering by INCostStatus.ReceiptDate is not recommended. It is best to rely on the standard report parameters or base any customization on transaction history rather than directly filtering INCostStatus.