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. |
Related Topics