NSC | Understanding the computation for Payment’s Amount Due field

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