Scenario
Users are confused about how the Amount Due on a Payment record is computed, as it does not match the actual amount due for the Customer or Vendor.
Computation and Explanation
Data
- Invoice Amount = $100
- First Payment = $20
- Second Payment = $30
- Third Payment = $40
Upon first payment
- Amount Due is equal the Original Invoice amount of $100
Upon second payment
1st Payment – Amount Due was updated from $100 to $70
- Amount Due = $100 Invoice Amount – $30 Payment applied from another payment record (from 2nd Payment)
2nd Payment – Amount Due is $80
- Amount Due = $100 Invoice Amount - $20 from 1st Payment
Upon third payment
1st Payment – Amount Due was updated from $100 to $70 to $30
- Amount Due = $100 Invoice Amount – $30 2nd Payment - $40 3rd Payment
2nd Payment – Amount Due was updated from $80 to $40
- Amount Due = $100 Invoice Amount – $20 1st Payment - $40 3rd Payment
3rd Payment – Amount Due
- Amount Due = $100 Invoice Amount – $20 1st Payment - $30 2nd Payment
The Amount Due field is dynamically calculated.
- Amount Due =Vendor Bill amount -(Other credit applied to the bill and other payment applied on the bill).
Our QA and Development teams have confirmed that this is working as designed. The Amount Due is calculated by deducting all previous Payments from the original amount of the bill. When the first payment is made, the original amount and the Amount Due are the same. When a second payment is made, the Amount Due is reduced by the amount of the first payment.
This behavior is the same for both the Customer Payments and Vendor Payments.
-----
If you find this information useful, let us know by reacting or commenting on this post!