Items-on-Hand Valuation Report - Field Descriptions

Use the table below for reference when completing the fields on this screen.

Field/Button

Description

Warehouse

To include all items in all warehouses on the report, press Enter. To include only items in a single warehouse, enter the code of that warehouse.

Category

Enter a category code, or press Enter to include ALL category codes.

Item code

Enter an item code, or press Enter to include ALL item codes.

Location

Enter the location code, or press Enter to include ALL location codes.

As of date

Enter the valuation date of the report. The system computes the inventory value as of the date specified by determining the current on-hand value for each item and then adjusting the value based on any transactions in the Inventory History File with dates later than the "as of date" indicated for the report.

Important: If you purge the Inventory History or make adjustments outside the software in a post-only screen, this function may not provide a valid result.

Report type

Select one of the report type options:

  • Summary

  • Detail

  • Standard cost

Quantity selection

Select on one of the quantity selection options to include on the report.

  • Positive/negative

  • Negative only

  • Zero only

  • All items

Status

Select whether to print Active, Discontinued, and/or Not used items.

Note: Items are designated as "discontinued" in the Inventory Item Maintenance screen. The Discontinued checkbox only affects Order Processing orders and invoices, and if an operator attempts to use a discontinued item, a warning message will display in the Order Processing > Invoice Entry, Order Entry, and Quote Entry screens (Work Order, Purchase Order, and Inventory Control job requisitions are not impacted).