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 |