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 topic:

• 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 set to Y and the Retail outlet flag is set to N

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

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

Note: A warehouse’s inventory is not included in the report if the Retail outlet flag is blank. Typically, this flag will always be populated, since the flag has been a required entry in warehouse maintenance since version 3.5 of CWDirect.

Valuation Starting and Ending Values

The system uses the Item Transaction Control file 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.

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

INR1497 ENTER Inventory Valuation Report 9/05/03 10:35:04 Sarah`s Joke Shop Enter the inventory date range to include on the report. Date Range: From To F3=Exit F9=Submit F12=Cancel

Completing this screen:

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

2. Press F9. The system submits the INV_VAL job, which generates the Inventory Valuation Report.