Printing the Inventory Valuation Report (PIVR)

Purpose: Use the Inventory Valuation Report to review a summary of warehouse activity for a range of dates, including:

• activity broken out according to types of transactions (transaction codes) and transaction reasons (transaction reason codes)

• totals for allocatable, non-allocatable, and retail warehouses

In this chapter:

• Types of Warehouses for Inventory Valuation

• Valuation Starting and Ending Values

• Inventory Valuation Report Screen

• Inventory Valuation Report

Types of Warehouses for Inventory Valuation

For the purposes of the Inventory Valuation Report, warehouses are identified as follows:

• allocatable: a warehouse’s inventory is included in these totals if the Allocatable flag is selected and the Retail outlet flag is unselected

• non-allocatable: a warehouse’s inventory is included in these totals if the Allocatable flag is unselected and the Retail outlet flag is unselected

• store: a warehouse’s inventory is included in these totals if the Retail outlet flag is selected, regardless of the setting of the Allocatable flag

Valuation Starting and Ending Values

The system uses the Item Transaction Control table to determine the Valuation starting units and dollars and Valuation ending units and dollars. Before you run your first Inventory Valuation Report, you should initialize your inventory balance to ensure accurate reporting.

To initialize inventory: Enter IITC in the Fast path field at the top of any menu. The Initialize Item Transaction Control screen displays the following warning:

This function will delete all Item Transaction Control records for the selected company displayed above and build a starting balance based on the current on hand totals for all warehouses. No inventory transactions should be taking place while this process is running.

Select Submit to initialize inventory.

The first time you run the Inventory Valuation report after initializing inventory, the report will display a Valuation starting units and dollars of 0 and a Valuation ending units and dollars of the current on hand totals for each warehouse type.

After the first run of the report after initializing inventory, valuation balances for dates earlier than the date you initialized inventory will be 0. Valuation balances for the date on which you initialize inventory or later will reflect accurate inventory totals.

Inventory Valuation Report Screen

Use this screen to generate the Inventory Valuation Report.

How to display this screen: Enter PIVR in the fast path field at the top of any menu, or select Print Inventory Valuation Report from a menu.

Completing this screen:

1. Enter both the From and To dates. The system validates that the From date is not later than the To date.

2. Select Submit. The system submits the INV_VAL job, which generates the Inventory Valuation Report.