On Hand by Warehouse Report

How to print: Complete the On Hand by Warehouse List Prompt Screen with the By warehouse/by warehouse vendor field set to Whse or with a Vendor specified.

For more information: See the sample report in PDF format.

Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information. Please note that a subgrouping by warehouse might have the warehouse headings repeat within the subgrouping; this occurs in cases where the subgrouping flows to a second page in the PDF version of the report. See Reports Available in Spreadsheet Format for more information.


Warehouse: Number and description.


SKU code, if any.

Description: Item description, even if this is a SKU.

On Hand Quantity: Total on-hand quantity for the item/SKU; does not include any purchase orders that are docked or received into suspense.

Based on your entry in the Print cost field at the On Hand by Warehouse List Prompt Screen, one of the following:

Cost: The standard, average, or FIFO cost on the report, based on the Costing Method (A25) system control value. If the appropriate cost is not specified in the SKU table, the report uses the cost from the Item table. If you use FIFO costing, the unit cost of each item/SKU is not listed, only the extended cost, calculated as the totals of FIFO layers (see Using FIFO Cost Layer Inquiry (WFCF)).

Retail Price: The most current price for the item/SKU, based on the latest Effective date that is not in the future. Also, the Current Offer (A33) must still be active, based on the End (End date) for the offer. If the item has SKUs, a price is listed only if there is a SKU Price record; if the item does not have SKUs, the price from the Item Price record is listed. The price does not include any discounts, price breaks, promotions, or other factors that affect selling price.

Vendor List: the vendor/item price for the item’s primary vendor. No vendor/item price is listed if the item has no primary vendor, or if there is no vendor/item for the primary vendor.

• blank: There is no cost or price information.

Extension: The extended cost, retail price, or vendor list price for the item/SKU. Set to 0.0000 if you did not select an option in the Print cost field.


On Hand Quantity: The total on-hand quantity in the warehouse.

Extension: The total extended cost, retail price, or vendor list price in the warehouse for all the items/SKUs.


• The report does not perform currency conversion when the vendor’s currency is different from your own; in this situation, the unit and extended vendor/item prices may be incorrect.

• The vendor/item price is zero for kit items.

WH07_13r OMSCS 19.0 December 2019 OHC