Use the Inventory Value Report to view the quantity that is currently available for the selected inventory items.

Use this report to review the financial value of inventory currently in stock. The Inventory Value Report displays inventory quantities, costs, and total values, helping users support financial reporting, reconcile inventory and accounting records, monitor inventory investment, prepare for audits, and make informed inventory management decisions. This report is commonly used for inventory valuation, financial analysis, and asset management activities.

Master report definitions: 

• Inventory value report by inventory number [Caselle Master]

• Inventory value report by location [Caselle Master]

This report was updated with a new look and feel in the 2024.11 release. The selection criteria includes the Last Issue Date field. 

Printing an inventory value report by inventory number

1. Open Connect Materials Management > Reports > Inventory Value Report. 

2. Select Inventory Value Report by Inventory Number [Caselle Master] as the report definition. 

3. Select the report end date. 

4. Select the report options. 

5. Click Print  (CTRL+P). 

Printing an inventory value report by location

1. Open Connect Materials Management > Reports > Inventory Value Report. 

2. Select Inventory Value Report by Location [Caselle Master] as the report definition. 

3. Select the report end date. 

4. Select the report options. 

5. Click Print  (CTRL+P). 

Include inactive inventory

Inactive inventory refers to items that have not been used, sold, or moved for a prolonged period. In Connect Materials Management, inactive inventory refers to items with an activation date after the current date or a termination before the current date.

 

What do you want to do?

• I want to include active inventory items. Do not select the checkbox. 

• I want to include active and inactive inventory items. Select the checkbox.  

Include inventory with a zero quantity or a zero balance

Inventory items with a zero quantity refers to items without a positive or negative number of a specific item or substance. Inventory items with a zero balance refers to items without a positive or negative amount. 

What do you want to do?

• I want to include inventory items that have a zero (0) recorded as the inventory item quantity and balance. Select the Include Inventory With a Zero Quantity or a Zero Balance checkbox. 

• I want to include only inventory items that do not have a zero quantity or zero balance. Do not select the checkbox. 

Summarize by location

Use the Print Location Detail option to print the inventory turnover ratio for each location where the inventory item is stored.

What do you want to do?

• I want to print the physical position for each inventory item. For example, the inventory item's row number. Do not select the Summarize by Location checkbox.

• I want to summarize the location detail when the inventory item exists in more than one location. Use this option to show the total quantity available at all of the locations. The report will print Multiple as the location to show the inventory item can be found in more than one location. Select the Summarize by Location checkbox.