Use this report to view the current quantities and values of inventory items available in stock. The Inventory On Hand Report provides a snapshot of inventory availability, helping users verify stock levels, support purchasing decisions, prepare for inventory counts, monitor inventory value, and ensure materials are available for operational needs. This report is commonly used for inventory management, planning, and replenishment activities.
Based on the report, the manager may decide to reorder brass fittings before stock levels become too low.
1. Open Connect Materials Management > Reports > Inventory On Hand Report.
2. Select the report dates.
The report calculates the inventory quantity that's available on the selected date.
3. Set up the report options.
Include inactive inventory
Select the checkbox to include inactive inventory. Inactive inventory is any inventory item with an activation date that occurs after the report date or a termination date that occurs before the report date.
Include inventory with a zero quantity on hand
Select the checkbox to include inventory with a zero quantity on hand. Zero quantity on hand happens when there isn't any quantity available at any location.
Print location detail
Select the checkbox to print where the inventory items are located.
4. Set up the selection criteria, report order, and columns. (Optional)
5. Click Print (CTRL+P).
To include the default inventory location on the report, click the Columns tab. From the Tasks list, click Modify Columns for This Report Line. Move [Report].Default Location to the Selected Columns list, and then click OK.
The [Report].Default Location column is added to the report columns. Now, just click the report.
To include the default inventory location on the report, click the Columns tab. From the Tasks list, click Modify Columns for This Report Line. Move [Report].Default Location to the Selected Columns list, and then click OK.
The [Report].Default Location column is added to the report columns. Now, just click the report.