How_do_I_print_inventory_on_hand_report_2024.11_

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.

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). 

 

 

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 ...