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.

Contents:

•         Warehouse: Number and description.

•         Item

•         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.

Totals:

•         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.

Note:

•         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.

On Hand by Vendor 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 vendor and with no 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®. Please note that a subgrouping by vendor and warehouse might have the vendor and 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.

Contents:

•         warehouse number and description

•         vendor number, based on the primary vendor identified for the item, regardless of whether this vendor or a different vendor actually sold you the inventory. This report starts a new page for each warehouse/vendor combination.

•         item code

•         SKU code, if any

•         vendor/item code

•         vendor/item description

•         the total quantity of the item/SKU returned from the customer to the warehouse month-to-date

•         the total quantity of the item/SKU shipped from the warehouse month-to-date

•         the total quantity of the item/SKU adjusted (using an inventory transaction code of A) in the warehouse month-to-date

•         the total quantity of the item/SKU received on purchase orders month-to-date (this quantity is updated when you place the stock, rather than when you dock a purchase order or place inventory in suspense)

•         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: This report does not currently support printing the retail 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.

•         The extended cost or vendor list price for the item/SKU

•         Totals for the vendor and warehouse:

•         quantity returned month-to-date

•         quantity shipped month-to-date

•         quantity adjusted month-to-date

•         quantity received month-to-date

•         quantity on-hand

•         total of all unit costs or vendor/item prices

•         total of all extended costs or vendor/item prices

Note:

•         This report does not currently support printing the retail price.

•         The vendor is 0 for kit items.

•         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.

 

________________________________