Scenario
The user created a Billing Schedule with different set of Amounts to be billed monthly, however, Sales Order with multiple Items shows incorrect Amounts.
When only one item is added to an order, all monthly amounts are correct. However, when multiple items are added with the same Billing Schedule added per Item Line, the schedule shows incorrect Billing Amounts.
Solution
To successfully use and follow the specific amounts from a custom Billing Schedule, ensure that the 'Apply to Subtotal' checkbox is selected on the Billing Schedule record.
Initial setup of Billing Schedule
Sales Order Data
- Total Amount = 500
- Item A = 200
- Item B = 300
- Sales Date = 5/30/2025
Here’s the Billing Schedule for Sales Order with multiple Items where Apply to Subtotal = F
Computation
The Billing schedule amounts were followed per Line item, and the schedule shows the Total amount per Bill date.
While this is the Billing Schedule for Sales Order with multiple Items where Apply to Subtotal = T
Even if you add multiple items on a Sales Order with a Billing schedule, the schedule will be computed based on the Total Amount of the order.
-----
If you find this information useful, let us know by reacting or commenting on this post!