QAD 2017 Enterprise Edition > User Guides > Sales > Customer Consignment Inventory > Reporting Consignment Inventory Data
  
Reporting Consignment Inventory Data
The system automatically collects consignment inventory data during transactions. The Customer Consignment Inventory module provides several reports for collecting, locating, tracking, and reviewing consigned inventory. These reports are designed to clearly show consigned and shipped inventory data. Consigned inventory data is shown in many standard reports also.
A number of reports and inquiries let you evaluate accounts and track inventory movement from its initial stocking location to customer consumption. Reports and Inquiries in the Customer Consignment Inventory Module shows reporting tools available in Customer Consignment Inventory and a brief explanation of the data that each provides.

Reports and Inquiries in the Customer Consignment Inventory Module
 
Menu
Report
Function/Purpose
7.18.2
Ship-To/Item Controls Report
Displays defaults defined for consigned inventory items and customer ship-to address or a range of customer ship-to addresses.
7.18.4.1
Consignment Inventory Report
Displays consigned inventory items selected by inventory attributes.
7.18.4.2
Consignment Inventory by Loc
Displays selected consigned inventory items sorted by site and location.
7.18.4.3
Consignment Inventory by Order
Displays selected consigned inventory shipments sorted by sales order. Can display with or without quantities and sorted by:
(1) Ship-from, customer, ship-to, order, item, PO or
(2) Ship-from, item, customer, ship-to, order, PO
7.18.4.4
Consignment by Order with Sequence
Displays selected consigned inventory shipments by sales order and customer sequence. Can display with or without shipment ID and quantities and sorted by:
(1) Ship-from, customer, ship-to, order, item, PO or
(2) Ship-from, item, customer, ship-to, order, PO
7.18.4.7
Aging Inventory Report by Order
Displays inventory quantities and aging dates by sales order.
7.18.4.8
Aging Inventory by Part
Displays inventory quantities and aging dates by item number.
7.18.4.9
Aging Inv by Order with Seq
Displays inventory quantities and aging dates by scheduled order with sequence numbers.
7.18.4.13
Inventory Usage Report
Displays inventory usage by selected criteria including ship-from, sold-to, ship-to, item, PO, SO, date used, ID, batch number, and customer reference.
7.18.4.14
Authorization Usage Report
Displays inventory usage by selected criteria and shipping authorization.
7.18.4.15
Sequenced Usage Report
Displays inventory usage by selected criteria and schedules order sequence number.
7.18.4.16
Usage Report by Order
Displays inventory usage by selected criteria including batch number and sales order sorted by:
(1) Ship-from, customer, ship-to, order, item, PO or
(2) Ship-from, item, customer, ship-to, order, PO
7.18.4.17
Usage Report by Order with Seq
Displays inventory usage by selected criteria and scheduled order sequence number.
7.18.16
Usage Inquiry
Displays consumed inventory by batch number. Shows sales order, line, item, quantities, and other data.
7.18.17
Authorization Usage Inquiry
Displays consumed inventory by batch and authorization number. Shows order, line, item, quantities, and other data.
7.18.18
Sequenced Usage Inquiry
Displays consumed inventory by batch and customer sequence number. Shows order, line, item, quantities, and other data.
Standard reporting tools available in Customer Consignment Inventory are shown in Standard Reports and Inquiries used in Customer Consignment Inventory, followed by an explanation of the data that each tool provides.

Standard Reports and Inquiries used in Customer Consignment Inventory
 
 
 
Menu Number
Title
Function/Purpose
3.6.5; enhanced .NET UI version available at 3.6.29
Inventory Detail Report
Shows inventory availability. Detail format shows quantities of consigned items. Lists inventory information for site and location.
1.5.21 and 3.6.13; enhanced .NET UI version available at 1.5.45 and 3.6.37
Inventory Valuation Report
Shows the value of inventory in a site by product line or item number. Includes total value of each item and a grand total for the product line.
Options to exclude, include, or show only consignment shipments.
1.5.22 and 3.6.14; enhanced .NET UI version available at 1.5.46 and 3.6.38
Inventory Valuation by Location
Shows the value of inventory in each location of a site by product line or item number. Includes total value at each location and a grand total for the site.
Options to exclude, include, or show only consigned inventory.
1.5.23 and 3.6.15; enhanced .NET UI version available at 1.5.47 and 3.6.39
Inventory Valuation as of Date
Displays the value of all items in a product line as of a user-specified date. Shows total inventory in each site and a grand total for product line.
Options to exclude, include, or show only consignment shipments.
1.5.24 and 3.6.16; enhanced .NET UI version available at 1.5.48 and 3.6.40
Inventory Valuation as of by Loc
Shows the value of inventory in each location of a site on a user-specified date. Shows the total value of each location and a grand total for the site.
Options to exclude, include, or show only consignment shipments.
3.21.1
Transaction Detail Inquiry
Displays detailed inventory transaction history records ordered by transaction number. Includes transaction types.
7.3.14
Scheduled Order Inquiry
Shows scheduled sales orders and consignment settings.