NSC | Invoice Amount and Quantity Differences When Using Billing Schedules

Scenario

A user wanted to generate invoices by splitting a single Purchase Order line into 12 equal monthly installments using a Billing Schedule in NetSuite.

The business requirement was to bill a fixed monthly amount over a 12 month contract period. For example, a 120,000 yen contract should generate 12 monthly invoices of 10,000 yen each.

During testing, the user created a Purchase Order with:

• Quantity = 1
• Unit Price = 120,000 yen
• Billing Schedule = Standard
• Initial Payment Amount = 10,000 yen

However, the generated invoice displayed an unexpected quantity value of 0.15972 instead of quantity 1. The user wanted to understand how Billing Schedules calculate invoice quantities and amounts.

Solution

To achieve your target billing amount, create a billing schedule that includes the following details: