Appendix > Appendix > Purchase Order Calculations > Receiving Calculations: Detail Fields
Receiving Calculations: Detail Fields
The table in this topic reflects the fields in the Detail Information section of the PO Receive Items window that use calculations to obtain the presented information.
Detail Field
Calculation Used
Extended Invoice
Qty Invoiced * Actual Cost of the line item
Inv. Unit Discount
Inv. Ext. Discount / Quantity to Invoice
Inv. Ext. Discount
If a Percent discount and the Purchase Discount field in the Invoice Information section is unedited: (Extended Invoice amount for the line item) * (Discount Amt percentage from the original purchase order)
If a Dollar discount or if recalculating after the Purchase Discount field in the Invoice Information section is edited: (Extended Invoice / Extended Invoice subtotal of all items with the Discount check box checked) * (Purchase Discount)
Inv. Unit Tax
Inv. Ext. Tax / Quantity to Invoice
Inv. Ext. Tax
If the Tax field in the Invoice Information section is unedited: (Extended Invoice - Inv. Ext. Discount) * Sales Tax % from the original purchase order
If the Tax field in the Invoice Information section is edited: (Extended Invoice - Inv. Ext. Discount / ((Extended Invoice subtotal of all items with the Taxable check box checked)-(Inv. Ext. Discount subtotal of all items)) * (Tax field in the Invoice Information section)
Inv. Unit Freight
Inv. Ext. Freight / Quantity to Invoice
Inv. Ext. Freight
(Extended Invoice / Extended Invoice subtotal of all items with the Apply Freight check box checked) * (Freight field in the Invoice Information section)
Extended Receive
For Receive Only transactions: Quantity Received/Returned of the line item * Estimated Actual Cost of the line item
For Receive and Invoice transactions: Quantity Received/Returned of the line item * Actual Cost of the line item
Land Unit Tax
Land Ext. Tax / Quantity Received/Returned
Land Ext. Tax
If the Landed Tax field in the Estimated Landing Information section is unedited): (Extended Receive - Land Ext. Discount) * Sales Tax % from the original purchase order.
If the Landed Tax field in the Estimated Landing Information section is edited: ((Extended Receive - Land Ext. Discount) / ((Extended Receive sum of all items with the Taxable and the Land Item fields checked in the original purchase order) - (Land Ext. Discount subtotal of all items)) * (Landed Tax field in the Estimated Landing Information section))
Land Unit Discount
Land Ext. Discount / Quantity Received/Returned
Land Ext. Discount
If a Percent discount and the Landed Purchase Discount field in the Estimated Landing Information section is unedited: (Extended Receive amount for the line item) * (Discount Amt percentage for the original purchase order)
If a Dollar discount or if recalculating after the Landed Purchase Discount field in the Estimated Landing Information section is edited: (Extended Receive / Extended Receive subtotal of all items with the Discount check box checked) * (Landed Purchase Discount field in the Estimated Landing Information section)
Land Unit Freight
Land Ext. Freight / Quantity Received/Returned
Land Ext. Freight
(Extended Receive / Extended Receive sum of all items with the Apply Freight and Land Item fields checked in the original purchase order) * (Landed Freight field in the Estimated Landing Information section)
Landed Unit Cost
Landed Ext. Cost / Quantity Received/Returned
Landed Ext. Cost
Extended Receive + Land Ext. Tax - Land Ext. Discount + Land Ext. Freight
Published date: 06/04/2021