How do I print inventory on hand report? (2024.11)
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.
Example
An inventory manager prints an Inventory On Hand Report and sees:
- Item Quantity On Hand
- Water Meters 125
- PVC Pipe (10 ft) 350
- Brass Fittings 82
Based on the report, the manager may decide to reorder brass fittings before stock levels become too low.
Printing Inventory On Hand Report
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).
Can I save a report as an Excel, PDF, RTF, or TXT file?
How do I print my report preview?
Adding the default inventory location
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.
Adding the default inventory location
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.
Related Articles
How do I print inventory on hand report? (2024.11)
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 Turnover Report
The Inventory Turnover Report will calculate the turnover ratio for an inventory item. The ratio measures the number of times the inventory item is sold or used during a given period. A low turnover rate may mean that the inventory item is ...Inventory Turnover Report
The Inventory Turnover Report will calculate the turnover ratio for an inventory item. The ratio measures the number of times the inventory item is sold or used during a given period. A low turnover rate may mean that the inventory item is ...Physical Inventory Worksheet
Use this report to support physical inventory counting activities. The Physical Inventory Worksheet provides a list of inventory items and space to record actual quantities on hand. This worksheet helps users verify inventory accuracy, identify ...Physical Inventory Worksheet
Use this report to support physical inventory counting activities. The Physical Inventory Worksheet provides a list of inventory items and space to record actual quantities on hand. This worksheet helps users verify inventory accuracy, identify ...