1. Reports Guide
  2. Warehousing

11 Warehousing

Docked but Past Due Purchase Order Report

How to print: Complete the Docked But Past Due Screen.

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

Contents:

  • dock date range

  • purchase order number

  • vendor number

  • vendor name

  • due date

  • docked date

Finished Good/Component On Hand Report

How to print: Complete the Finished Good/Component On Hand Screen.

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

Contents:

  • Warehouse

  • Item

  • SKU

  • Item description

  • Kit quantity (the quantity of the component item needed to make up the finished good)

  • On hand quantity

  • Reserved quantity

  • Back order quantity

  • On order quantity

Finished Good Explosion Report

How to print: Complete the Finished Goods Explosion Screen.

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

Contents:

  • Warehouse code and description

  • Finished good item

  • Finished good SKU

  • Finished good on hand quantity

  • Finished good reserved quantity

  • Finished good backorder quantity

  • Component item

  • Component SKU

  • Component on hand quantity

  • Component kit quantity (quantity needed to make up the finished good)

  • Component requested quantity

Inventory Control Report

How to print: Complete the Inventory Control Report Screen

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

Contents:

  • Start date and end date represented on the report

  • Warehouse code and description

  • Total number of units in the warehouse and total dollar value of inventory at the start date

  • Total number of units in the warehouse and total dollar of value of inventory at the end date

  • Net change in units and dollars over the reporting period

  • Total units and dollars represented by each time of transaction. Transaction types include:

    • adjustments

    • customer returns

    • express bills

    • issues (shipment)

    • make up kits for finished good

    • actual (reset actual on-hand quantity)

    • purchase order receipts

    • transfers

    • returns to vendor

    • other inventory transaction types you have defined; see Work with Inventory Transaction Codes (WITC)

  • total units and dollar value of all transactions

  • total units and dollar value out of balance

Inventory Receipt Exception Report

How to print: Complete the Print Inventory Receipt Exception Report Screen. This report sorts by vendor, then by purchase order number with vendor, and page breaks by purchase order number.

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

Contents:

  • Vendor number and description (this is the parent vendor number related to the vendor number on the purchase order header)

  • Purchase order number from the item transaction history

  • Purchase order entry date

  • Purchase order due date

  • Item number from the item transaction history

  • SKU code from the item transaction history

  • Item description

  • Purchase order quantity from the purchase order detail line

  • Purchase order receipt quantity

  • Inventory transaction reason code from the item transaction history (only inventory transaction reasons 96, 97, 98, and 99 print on this report)

  • Item transaction history date (the date the item transaction history was created)

  • Cost from the item transaction history

Inventory Transaction History Report

How to print: Use the Print Inventory Transaction History Screen.

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.

Contents:

  • Warehouse

  • Item/SKU

  • Transaction date

  • Transaction time

  • Location. Two separate transactions print for transfer transactions, one showing the 'transfer from' location and one showing the 'transfer to' location. The location field is blank for issues of non-inventory or drop ship items, or for * transactions.

  • Transaction code

  • Transaction quantity

  • Old on-hand quantity

  • New on-hand quantity

  • Cost. This is the unit cost if you use standard or average costing, and it is the extended cost of the transaction if you use FIFO costing. If the person generating the report does not have authority under the Display Cost in Inventory (A38) secured feature, the Cost is not included on the report.

  • Inventory transaction reason code

  • User ID

  • V

  • Net total. The net total for the transaction quantity column. The net total is useful if you selected a specific transaction code at the Print Inventory Transaction History Screen.

See Display Inventory Transaction History (DITH) for complete field descriptions.

Inventory Valuation Report

Purpose: Use the Inventory Valuation report to review a summary of warehouse activity for a range of dates, including:

  • activity broken out according to types of transactions (transaction codes) and transaction reasons (transaction reason codes)

  • totals for allocatable, non-allocatable, and retail warehouses; see Types of Warehouses for Inventory Valuation.

How to print: Select Submit at the Inventory Valuation Report Screen.

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

Contents:

  • Date range: The date range defined for the report (the From and To dates selected at the Inventory Valuation Report Screen).

    Types of Warehouses for Inventory Valuation
  • Valuation starting units: The number of inventory units up to, but not including, the From date entered at the Inventory Valuation Report Screen.

    Note:

    The system does not include the number of units associated with a * transaction code.

    • Allocatable: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Allocatable” and whose Date is before the From date.

    • Store: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Store” and whose Date is before the From date.

    • Non-allocatable: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Non-allocatable” and whose Date is before the From date.

  • Valuation starting dollars: The dollar value of the inventory units up to, but not including, the From date entered at the Inventory Valuation Report Screen.

    • Allocatable: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Allocatable” and whose Date is before the From date.

    • Store: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Store” and whose Date is before the From date.

    • Non-allocatable: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Non-allocatable” and whose Date is before the From date.

  • Valuation ending units: The number of inventory units up to, and including, the To date entered at the Inventory Valuation Report Screen.

    Note:

    The system does not include the number of units associated with a * transaction code.

    • Allocatable: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Allocatable” and whose Date falls on or before the To date.

    • Store: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Store” and whose Date falls on or before the To date.

    • Non-allocatable: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Non-allocatable” and whose Date falls on or before the To date.

  • Valuation ending dollars: The dollar value of the inventory units up to, and including, the To date entered at the Inventory Valuation Report Screen.

    • Allocatable: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Allocatable” and whose Date falls on or before the To date.

    • Store: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Store” and whose Date falls on or before the To date.

    • Non-allocatable: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Non-allocatable” and whose Date falls on or before the To date.

  • Valuation change units: The difference between the valuation starting units and the valuation ending units.

    • Allocatable: The system uses this calculation: Allocatable valuation starting units - Allocatable valuation ending units = Allocatable valuation change units.

    • Store: The system uses this calculation: Store valuation starting units - Store valuation ending units = Store valuation change units.

    • Non-allocatable: The system uses this calculation: Non-allocatable valuation starting units - Non-allocatable valuation ending units = Non-allocatable valuation change units.

  • Valuation change dollars: The difference between the valuation starting dollars and the valuation ending dollars.

    • Allocatable: The system uses this calculation: Allocatable valuation starting dollars - Allocatable valuation ending dollars = Allocatable valuation change dollars.

    • Store: The system uses this calculation: Store valuation starting dollars - Store valuation ending dollars = Store valuation change dollars.

    • Non-allocatable: The system uses this calculation: Non-allocatable valuation starting dollars - Non-allocatable valuation ending dollars = Non-allocatable valuation change dollars.

  • Transaction change units: The number of units for all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen.

    • Allocatable: The value from the Total allocatable units field on this report.

    • Store: The value from the Total store units field on this report.

    • Non-allocatable: The value from the Total non-allocatable units field on this report.

  • Transaction change dollars: The dollar value for all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen.

    • Allocatable: The value from the Total allocatable dollars field on this report.

    • Store: The value from the Total store dollars field on this report.

    • Non-allocatable: The value from the Total non-allocatable dollars field on this report.

  • Variance change units: The difference between the transaction change units and the valuation change units. A value in this field indicates a discrepancy between the inventory units in the Item Transaction Control table and the inventory units in the Item Transaction History table.

    • Allocatable: The system uses this calculation: Allocatable transaction change units - Allocatable valuation change units = Allocatable variance change units.

    • Store: The system uses this calculation: Store transaction change units - Store valuation change units = Store variance change units.

    • Non-allocatable: The system uses this calculation: Non-allocatable transaction change units - Non-allocatable valuation change units = Non-allocatable variance change units.

  • Variance change dollars: The difference between the transaction change dollars and valuation change dollars. A value in this field indicates a discrepancy between the inventory dollars in the Item Transaction Control table and the inventory dollars in the Item Transaction History table.

    • Allocatable: The system uses this calculation: Allocatable transaction change dollars - Allocatable valuation change dollars = Allocatable variance change dollars.

    • Store: The system uses this calculation: Store transaction change dollars - Store valuation change dollars = Store variance change dollars.

    • Non-allocatable: The system uses this calculation: Non-allocatable transaction change dollars - Non-allocatable valuation change dollars = Non-allocatable variance change dollars.

  • Totals: The totals for each of the above categories across all types of warehouses (Allocatable, Store, and Non-allocatable).

    • Valuation starting units: The total valuation starting units, across all warehouse types. The system uses this calculation: Allocatable valuation starting units + Store valuation starting units + Non-allocatable valuation starting units = Total valuation starting units.

    • Valuation starting dollars: The total valuation starting dollars, across all warehouse types. The system uses this calculation: Allocatable valuation starting dollars + Store valuation starting dollars + Non-allocatable valuation starting dollars = Total valuation starting dollars.

    • Valuation ending units: The total valuation ending units, across all warehouse types. The system uses this calculation: Allocatable valuation ending units + Store valuation ending units + Non-allocatable valuation ending units = Total valuation ending units.

    • Valuation ending dollars: The total valuation ending dollars, across all warehouse types. The system uses this calculation: Allocatable valuation ending dollars + Store valuation ending dollars + Non-allocatable valuation ending dollars = Total valuation ending dollars.

    • Valuation change units: The total valuation change units, across all warehouse types. The system uses this calculation: Allocatable valuation change units + Store valuation change units + Non-allocatable valuation change units = Total valuation change units.

    • Valuation change dollars: The total valuation change dollars, across all warehouse types. The system uses this calculation: Allocatable valuation change dollars + Store valuation change dollars + Non-allocatable valuation change dollars = Total valuation change dollars.

    • Transaction change units: The total transaction change units, across all warehouse types. The system uses this calculation: Allocatable transaction change units + Store transaction change units + Non-allocatable transaction change units = Total transaction change units.

    • Transaction change dollars: The total transaction change dollars, across all warehouse types. The system uses this calculation: Allocatable transaction change dollars + Store transaction change dollars + Non-allocatable transaction change dollars = Total transaction change dollars.

    • Variance change units: The total variance change units, across all warehouse types. The system uses this calculation: Allocatable variance change units + Store variance change units + Non-allocatable variance change units = Total variance change units.

    • Variance change dollars: The total variance change dollars, across all warehouse types. The system uses this calculation: Allocatable variance change dollars + Store variance change dollars + Non-allocatable variance change dollars = Total variance change dollars.

  • Starting balance (value): The starting balances for each type of warehouse (Allocatable, Store, and Non-allocatable).

    • Allocatable units: The value from the Allocatable valuation starting units field on this report.

    • Allocatable dollars: The value from the Allocatable valuation starting dollars field on this report.

    • Store units: The value from the Store valuation starting units field on this report.

    • Store dollars: The value from the Store valuation starting dollars field on this report.

    • Non-allocatable units: The value from the Non-allocatable valuation starting units field on this report.

    • Non-allocatable dollars: The value from the Non-allocatable valuation starting dollars field on this report.

    • Total units: The Valuation starting units across all warehouse types (Allocatable, Store, and Non-allocatable). The system uses this calculation: Starting balance allocatable units + Starting balance store units + Starting balance non-allocatable units = Starting balance total units.

    • Total dollars: The Valuation starting dollars across all warehouse types (Allocatable, Store, and Non-allocatable). The system uses this calculation: Starting balance allocatable dollars + Starting balance store dollars + Starting balance non-allocatable dollars = Starting balance total dollars.

For all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen, the system provides unit and dollar totals. If an inventory transaction did not have any activity during the date range specified, the unit and dollar totals are 0.

  • Transaction code: A code that represents an inventory transaction, such as A = inventory adjustment. All transaction codes in the Item Transaction Code table are included on this report; the system sorts the transaction codes in alphabetical sequence.

    Note:

    The system does not create a * transaction history record when you update the standard or average cost of an item.
  • Description: A description of the transaction code.

    Note:

    If a transaction reason code has been used, separate totals are provided for each reason code; in this case, the description of the reason code is listed instead of the description of the transaction code; the reason code itself is also listed. Also, in this situation, the transaction code itself is listed first, with the totals for transactions that took place without a reason code, followed by a separate line for each different reason code used with the transaction. For example, you have processed transfer (T) transactions with:

    • no reason code

    • reason code 1 (REPLENISH PRIMARY)

    • reason code 2 (OVERSTOCK TO BULK)

    The report includes the following three lines for transfer totals:

    • T Transfer

    • T REPLENISH PRIMARY    (1)

    • T OVERSTOCK TO BULK   (2)

For each inventory transaction code/reason:

    • Allocatable units: The number of units in “Allocatable” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for the specified Transaction code and Transaction reason whose Warehouse type is “Allocatable” and whose Date falls on or within the date range defined.

    • Allocatable dollars: The dollar value for the number of units in “Allocatable” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table with the specified Transaction code and Transaction reason whose Warehouse type is “Allocatable” and whose Date falls on or within the date range defined: Cost x Qty = Allocatable dollars.

    •  Store units: The number of units in “Store” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for the specified Transaction code and Transaction reason whose Warehouse is store and whose Date falls on or within the date range defined.

    • Store dollars: The dollar value for the number of units in “Store” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table with the specified Transaction code and Transaction reason whose Warehouse type is “Store” and whose Date falls on or within the date range defined: Cost x Qty = Store dollars.

    • Non-allocatable units: The number of units in “Non-allocatable” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for the specified Transaction code and Transaction reason whose Warehouse is non-allocatable and whose Date falls on or within the date range defined.

    • Non-allocatable dollars: The dollar value for the number of units in “Non-allocatable” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table with the specified Transaction code and Transaction reason whose Warehouse type is “Non-allocatable” and whose Date falls on or within the date range defined: Cost x Qty = Allocatable dollars.

    • Total units: The number of units across all warehouse types (Allocatable, Store, and Non-allocatable) for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation: Allocatable units + Store units + Non-allocatable units = Total units.

    • Total dollars: The dollar value for the number of units across all warehouse types (Allocatable, Store, and Non-allocatable) for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation: Allocatable dollars + Store dollars + Non-allocatable dollars = Total dollars.

  • Total: The totals for each of the above categories (Allocatable units, Allocatable dollars, Store units, Store dollars, Non-allocatable units, Non-allocatable dollars, Total units, Total dollars) across all types of inventory transactions.

    • Allocatable units: The number of units in “Allocatable” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for each record whose Warehouse type is “Allocatable” and whose Date falls on or within the date range defined.

    • Allocatable dollars: The dollar value for the number of units in “Allocatable” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table whose Warehouse type is “Allocatable” and whose Date falls on or within the date range defined: Cost x Qty = Allocatable transaction change dollars.

    • Store units: The number of units in “Store” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for each record whose Warehouse type is “Store” and whose Date falls on or within the date range defined.

    • Store dollars: The dollar value for the number of units in “Store” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table whose Warehouse type is “Store” and whose Date falls on or within the date range defined: Cost x Qty = Store transaction change dollars.

    • Non-allocatable units: The number of units in “Non-allocatable” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for each record whose Warehouse type is “Non-allocatable” and whose Date falls on or within the date range defined.

    • Non-allocatable dollars: The dollar value for the number of units in “Non-allocatable” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table whose Warehouse type is “Non-allocatable” and whose Date falls on or within the date range: Cost x Qty = Non-allocatable transaction change dollars.

    • Total units: The total number of units, across all warehouse types and all inventory transactions, that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation: Total allocatable units + Total Store units + Total Non-allocatable units = Total total units.

    • Total dollars: The dollar value for the total number of units, across all warehouses and all inventory transactions, that occurred within the date range entered at the Inventory Valuation Reports Screen. The system uses this calculation: Total allocatable dollars + Total Store dollars + Total Non-allocatable dollars = Total total dollars.

For each of the allocatable/store/non-allocatable unit and dollar buckets:

  • Ending balance (transactions): The ending inventory balance from the Item Transaction History table, including all inventory transactions up to the To date.

    • Allocatable units: The system uses this calculation: Starting balance allocatable units + Total allocatable units = Ending balance (transactions) allocatable units.

    • Allocatable dollars: The system uses this calculation: Starting balance allocatable dollars + Total allocatable dollars = Ending balance (transactions) allocatable dollars.

    • Store units: The system uses this calculation: Starting balance store units + Total store units = Ending balance (transactions) store units.

    • Store dollars: The system uses this calculation: Starting balance store dollars + Total store dollars = Ending balance (transactions) store dollars.

    • Non-allocatable units: The system uses this calculation: Starting balance non-allocatable units + Total non-allocatable units = Ending balance (transactions) non-allocatable units.

    • Non-allocatable dollars: The system uses this calculation: Starting balance non-allocatable dollars + Total non-allocatable dollars = Ending balance (transactions) non-allocatable dollars.

    • Total units: The system uses this calculation: Ending balance (transactions) allocatable units + Ending balance (transactions) store units + Ending balance (transactions) non-allocatable units = Ending balance (transactions) total units.

    • Total dollars: The system uses this calculation: Ending balance (transactions) allocatable dollars + Ending balance (transactions) store dollars + Ending balance (transactions) non-allocatable dollars = Ending balance (transactions) total units.

  • Ending balance (value): The ending inventory balance from the Item Transaction Control table, including all transaction dates up to the To date.

    • Allocatable units: The Allocatable valuation ending units.

    • Allocatable dollars: The Allocatable valuation ending dollars.

    • Store units: The Store valuation ending units.

    • Store dollars: The Store valuation ending dollars.

    • Non-allocatable units: The Non-allocatable valuation ending units.

    • Non-allocatable dollars: The Non-allocatable valuation ending dollars.

    •  Total units: The system uses this calculation: Allocatable valuation ending units + Store valuation ending units + Non-allocatable valuation ending units = Ending balance (value) total units.

    • Total dollars: The system uses this calculation: Allocatable valuation ending dollars + Store valuation ending dollars + Non-allocatable valuation ending dollars = Ending balance (value) total dollars.

  • Ending balance (variance): The difference between the transactions ending balance and the value ending balance. A value in these fields indicates a discrepancy between the inventory balance in the Item Transaction Control table and the inventory balance in the Item Transaction History table.

    • Allocatable units: The system uses this calculation: Ending balance (transactions) allocatable units - Ending balance (value) allocatable units = Ending balance (variance) allocatable units.

    • Allocatable dollars: The system uses this calculation: Ending balance (transactions) allocatable dollars - Ending balance (value) allocatable dollars = Ending balance (variance) allocatable dollars.

    • Store units: The system uses this calculation: Ending balance (transactions) store units - Ending balance (value) store units = Ending balance (variance) store units.

    • Store dollars: The system uses this calculation: Ending balance (transactions) store dollars - Ending balance (value) store dollars = Ending balance (variance) store dollars.

    • Non-allocatable units: The system uses this calculation: Ending balance (transactions) non-allocatable units - Ending balance (value) non-allocatable units = Ending balance (variance) non-allocatable units.

    • Non-allocatable dollars: The system uses this calculation: Ending balance (transactions) non-allocatable dollars - Ending balance (value) non-allocatable dollars = Ending balance (variance) non-allocatable dollars.

    • Total units: The system uses this calculation: Ending balance (transactions) allocatable units + Ending balance (transactions) store units + Ending balance (transactions) non-allocatable units = Ending balance (value) total units.

    • Total dollars: The system uses this calculation: Ending balance (transactions) allocatable dollars + Ending balance (transactions) store dollars + Ending balance (transactions) non-allocatable dollars = Ending balance (value) total dollars.

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.

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.

Purchase Orders in Docked Status Report

How to print: Enter PDPO in the Fast path field at the top of any menu, or select Print Docked Purchase Orders from a menu. See Printing the Purchase Orders in Docked Status Report (PDPO).

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

Contents:

  • purchase order number

  • vendor number

  • vendor name

  • docked date

Verify Inventory Sharing Report

Purpose: The Verify Inventory Sharing report lists the items in the sharing warehouse that are not setup correctly for inventory sharing.

The Inventory Sharing (A69) system control value defines whether a company will fulfill orders from another company’s inventory. When this system control value is selected, the Sharing warehouse and Shared company/warehouse fields appear on the Create, Change, or Display Warehouse screens.

Note:

  • The Shared company and warehouse is the company and warehouse that contains the actual inventory. This is the company and warehouse that shares inventory with other warehouses in other companies. In this company, you select the Sharing warehouse field for the shared warehouse.

  • The Sharing company and warehouse is the company and warehouse that does not contain inventory, and instead, points to the shared company and warehouse. In this company, you set the Shared company/warehouse fields for the sharing warehouse; these fields correspond to the actual shared warehouse in the other company.

How to print: In the sharing company (the company that does not contain the inventory), enter a sharing warehouse and select OK at the Verify Inventory Sharing Screen (VISH).

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

Contents:

  • Warehouse: A code for the sharing warehouse you entered at the Verify Inventory Sharing Screen. This is the warehouse that does not contain the actual inventory, and instead shares inventory with a specified sharing company and warehouse.

  • Inventory sharing company: A code for the shared company that shares inventory with the sharing warehouse. This is the company that contains the shared warehouse where the actual inventory is located.

  • Warehouse: A code for the shared warehouse in the company that shares inventory with the sharing warehouse. This is the warehouse where the actual inventory is located.

  • Item: A code for an item that is not setup correctly for sharing inventory.

  • SKU: The SKU of the item that is not setup correctly for sharing inventory.

  • Not in company: An X indicates the specified item/SKU does not exist in the shared company (the company that contains the warehouse where the actual inventory is located).

  • Not in sharing warehouse: An X indicates the specified item/SKU does not exist in the shared warehouse (the warehouse where the actual inventory is located).

  • Total items: The total number of items in the sharing warehouse. This is the warehouse that does not contain that actual inventory.

  • Total errors: The total number of items in the sharing warehouse that need to be set up correctly for shared inventory. The Not in company and Not in sharing warehouse columns on the report indicate why the item is in error.

Where Kit Component Item Used Report

How to print: Complete the Where Finished Good Component Item Usage Screen.

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

Contents:

  • Component item

  • Finished good item

  • Finished good item SKU

  • Kit quantity (the quantity of the component item needed to make up the finished good)

Where Set Component Item Used Report

How to print: Complete the Where Set Component Item Usage Screen.

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

Contents:

  • Component item

  • Set item

  • Set SKU

  • Set quantity (the quantity of the component item need to make up the set)

  • Cost percent (the percentage of the set's cost that this item comprises)

  • Coordinate group number

Where Variable Set Component Used Report

How to print: Complete the Where Variable Set Component Usage Screen.

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

Contents:

  • Component item

  • Variable set item

  • Variable set SKU

  • Group

  • Group description

  • Number of items (the number of units the customer must order from this group)

Work Order Error Listing

This report lists each work order detail line in error and the reason why the error occurred. You can use this report to fix each work order detail line that was in error and then recreate the work order.

How to print: Select Print Errors on the Create Work Order Details Screen.

Sample report: A sample of this report will be provided at a later date.

Contents:

  • Work order number
  • Warehouse number and description
  • Kit name and description
  • Kit quantity
  • Sequence number
  • Component item and SKU
  • Component description
  • Kit quantity
  • Total quantity
  • Location
  • Error reason

Work Order Ticket

Purpose: The work order ticket provides information about a finished good work order including:

  • the work order number and its expected due date
  • the finished good and its component items
  • the component locations and quantities taken from each
  • the quantity of components damaged during the work process

How to print: On the Work with Work Orders Screen, select Print Ticket for the work order you wish to print a ticket for, or select Print All Unprinted to print all tickets that have not yet been printed for existing work orders.

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

Contents:

  • work order number
  • item/SKU number
  • item description
  • warehouse
  • buyer
  • date printed
  • order quantity
  • date ordered
  • date due
  • component/SKU
  • component description
  • quantity per finished good
  • quantity required per location
  • location
  • quantity pulled
  • workorder pulled by
  • produced by
  • received in workcenter by (a workcenter is an area within the warehouse where the finished good is assembled)
  • total hours
  • item
  • waste product (a component that was damaged during the finished good work order process)
    • waste product quantity
    • waste product location
  • bind (a binder used during the finished good work order process)
    • bind quantity
    • bind location
  • total quantity
  • total location
  • receipts
  • receipt date
  • receipt quantity
  • receipt location
  • reviewed by
  • inspected by
  • entered by