Print an Inventory Valuation by Location Report

Use the Inventory Valuation by Location Report (IVLR) program to print a report of the current value of inventory in each warehouse location based on standard, actual, or average cost. See Background for a list of what prints on the report.

  1. Set your options:

    1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.

    2. Click the Sort tab to set sort order.

    3. Click the Selection tab to select specific records.

    4. Click the Program tab to set these program specific options:

Field Name

Type / Max Length

Action / Description

Include zero cost items?

Optional

Select to list all items, including those with zero cost, or leave blank to list only items that have a cost greater than 0.

Include zero quantity items?

Optional

Select to list all items, including those with zero quantity, or leave blank to list only items with a quantity greater than 0.

If you select both Include zero cost items? and Include zero quantity items?, all items print.

If you select neither, only items that have both a cost and a quantity print.

Print only negative qtys?

Optional

Select to list only items that have a negative on-hand or floor-stock quantity or leave blank to list all items regardless of quantity.

Print Std, Act, or Avg cost

Optional

Select the cost that you want to use to calculate inventory value:

Select

For

STD

Standard unit cost

ACT

Actual unit cost

AVG

Average unit cost

Extended value calculation

Optional

Determines whether or not floor stock quantities are included in the extended value calculation on the report:

Select

For

Y or blank

Include floor stock in addition to on hand

N

Do not include floor stock

O

Include floor stock only; do not include on hand

    1. Click the Program2 tab to set these program specific options:

Field Name

Type / Max Length

Action / Description

Exclude item status

Optional

Select to omit up to ten item statuses (based on the inventory branch record). Item statuses are defined in Item Status Codes (TISM).

  1. Choose the appropriate options:

To

Do This

Review the report on the screen before printing

Click View. See Background for a list of what displays.

Print the report

Click Print. See Background for a list of what prints.

Note
The report prints immediately if the option Allow device override? in the Date-Output Device Maintenance (ZE) program is not selected.

If this option is selected, the program prompts Output device. Accept the default device that displays, which is specified in the Date-Output Device Maintenance program, or enter the name of a different device.

Save these options for future use

Click Save

Exit the program

Click Exit.