Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
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
Judy Culanding | RPM | New to NetSuite
Learn how to Refer a member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!
0