Create a Comparative Inventory Report for On Hand and Value

Currently, an Inventory Aging Report is still filed as Enhancement# 44650. If a user wants to create a comparative Inventory Report by period with both On Hand and Value, they can use customized Saved Report below.  

Note that the maximum number of periods that a Report can accommodate is only up to three periods.  The scenario below is to show On Hand and Value for the last 3 months. This sample Report uses dates instead of periods. Verify by going to Home > Set Preferences > Analytics > Reporting that Report By Period is either set to Financials Only or Never.

1. Navigate to Reports > Inventory/Items > Inventory Valuation > Customize Summary
2. On the Edit Columns:
   - On Quantity On Hand folder select On Hand Value. Set Alternate Date Range = Relative to Report Date then Alternate Date Range = Same Day Last Month and Column Label = Value (Last Month)
   
   - On Quantity on Hand folder select Quantity on Hand. Set Alternate Date Range = Relative to Report Date then Alternate Date Range = Same Day Last Month and Column Label = On Hand (Last Month)
   
   - On Quantity On Hand folder select On Hand Value. Set Alternate Date Range = Relative to Report Date then Alternate Date Range = Same Day Month Before Last and Column Label = Value (2 Months Ago)
   
   - On Quantity on Hand folder select Quantity on Hand. Set Alternate Date Range = Relative to Report Date then Alternate Date Range = Same Day Month Before Last and Column Label = On Hand (2 Months Ago)
3. Click Preview or Save.

Note that user can still further customize this Saved Report. One consideration is changing the period. If a user wants this per year, i.e. for the last three years, then user can set Alternate Date Range = Same Day Last Year and Same Day Year Before Last.