Consumer Usage Reconciliation - Summary Report (INS9070)

Field or Control Description

Item Usage QTY (item usage quantity)

The quantity of the item used, according to the associated consumer usage entry.

Item Usage Cost

The cost of the item usage recorded at the time of usage entry. This is the Item Usage Qty times the Unit Cost.

Item Ship QTY (item ship quantity)

The quantity of the item shipped to the location, expressed in the item's standard UOM.

Item Shipment Cost

The cost of the shipped items. This value is derived from the average cost defined on the Define Business Unit Item - General page.

Item Receipt QTY (item receipt quantity)

The quantity of the item that was received. You define this value on the Receiving page.

Item Receipt Cost

Cost of the items received. This value is derived from the PO price that you defined on the Receipt Distributions page.

Delta QTY (delta quantity)

The quantity of items that did not reconcile for the row. This value is the difference between the Item Usage Quantity and the Item Receipt Quantity.

Lost Charge

The total cost of items that could not be reconciled for the row. This value is the Item Usage Cost - (Item Receipt Cost + Item Shipment Cost)

Location Usage Cost

Total item usage costs for the location ID.

Location Shipment Cost

Total item shipment costs for the location ID.

Location Receipt Cost

Total item receipt costs for the location ID.

Grand Usage Cost

Total usage item costs for all location IDs included in the report.

Grand Shipment Cost

Total item shipment costs for all location IDs included in the report.

Grand Receipt Cost

Total item receipt costs for all location IDs included in the report.