Receiving Calculations: Invoicing Fields

The table in this topic reflects the fields in the Invoice Information section of the PO Receive Items window that use calculations to obtain the presented information.

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) |

Published date: 06/04/2021