Detail Field | Calculation Used |
|---|---|
Early Payment Discount | (Subtotal - Total Discount) * (Discount percentage as defined in the AP Vendors window) |
Purchase Discount | If a Percent discount: (Extended Invoice sum for all discountable line items) * (Discount Amt percentage from the original purchase order) If a Dollar discount, one of these three outcomes occurs: • If B is less than or equal to zero, then the Purchase Discount is zero • If A is less than B, then the Purchase Discount equal A • If A is greater than B, then the Purchase Discount equals B A = (Extended Invoice sum for all discountable line items) / (Sum of all discountable line items (Received and Not Invoiced + Quantity Invoiced + Quantity already invoiced) * (Actual Cost))) * (Discount Amt field from the original purchase order) B = (Discount Amt field from the original purchase order) - Total Purchase Discount already posted for the purchase order) |
Tax | (Sales Tax %) * (Extended Invoice sum for all Taxable line items) - (Extended Discount sum for all Discountable line items) |
Freight | Depending on the amount, one of these three outcomes occurs: • If B is less than or equal to zero, then the Freight is zero • If A is less than B, then the Freight equal A • If A is greater than B, then the Freight equals B A = (Extended Invoice sum for all discountable line items) / (Sum for all discountable line items (Received and Not Invoiced + Quantity Invoiced + Quantity already invoiced) * (Actual Cost))) * (Freight Amt field from the original purchase order) B = (Freight Amt field from the original purchase order) - (Total Freight already posted for the purchase order) |