Report creation: On-hand inventory per month

On-hand inventory values of items per month basis can be reviewed by customizing the Inventory valuation standard report.

Open the Inventory valuation report by

Report> Inventory/ Items> Inventory valuation

1. Click Edit Columns Tab.
2. Add the column Quantity On Hand: Quantity On Hand and set an Alternate Date range.
3. To add another column for another month, repeat step 3.
4. Uncheck the Add % of Total Column if the customer does not want to see this column.
5. In case the customer wants to have the inventory values as well, you can add the column Quantity On Hand: On Hand Value and set the Alternate Date Range.
6. Click Save or Preview.