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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
NSC | Understanding the Amount and Quantity computation of a Billing Schedule with Initial Amount
Scenario
The user created a Billing Schedule with an Initial Amount and wanted to understand how the Amount and Quantity were calculated after generating the initial Invoice.
Computation and Explanation
Sales Order Data
- Sales Order Total Amount = 120,000
- Item Quantity = 1
- Sales Date = 5/29/2025
Billing Schedule Data
- Initial Amount = 10,000
- Initial Payment Terms = Null
- Recurrence Frequency = Monthly
- Repeat Every = 1 month
- Recurrence Count = 12
- In Arrears = Unchecked
- Recurrence Payment Terms = Null
Below is the Schedule generated from the setup above:
Amount Computation
- First month: 10,000 (Initial Amount) + 9166.6667 (Monthly Amount) = 19,166.67
- Monthly Amount: 120,000 (total amount) - 10,000 (Initial Amount) = 110,000 / 12 (12 months) = 9166.6667
- Second until the last month = 9,166.67
Note that the last month amount will be adjusted automatically to make sure that all the Billed Amount is still equal to the Sales Order Total Amount
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