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 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 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.
• Cost: The standard, average, or FIFO cost on the report, based on the 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 ).
• Retail Price: The most current price for the item/SKU, based on the latest that is not in the future. Also, the must still be active, based on the 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.
• 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.