Scenario
User wanted to customize a Billing Schedule to set specific Amounts to be billed per month to follow their customer request and agreed terms.
Creating a billing schedule with set billing amounts ensures predictable, consistent invoicing over a defined period and amount.
Solution
- Navigate to Lists > Accounting > Billing Schedules > New
- Set the following:
- Add the Billing Schedule Name
- Initial Amount = 0 (zero)
- Initial Payment Terms = Null
- Recurrence Frequency = Custom
- On Custom table, add the following:
- Recurrence Count value will automatically be populated
- In Arrears = Unchecked
- Recurrence Payment Terms = Null
- Click Save
- Create the Sale Order from Transactions > Sales > Enter Sales Orders
- Enter all required details
- In Billing tab, add the Billing Schedule you just created
- Save the Sales Order
Below will be the sample schedule for the above setup:
Sales Order Data
- Total Amount = 500 (with one Item only)
- Sales Date = 5/30/2025
If the Item Amount is more than the Sum of Amounts added in the Billing Schedule, the excess amount will be added on the last Billing Date of the schedule. Since the Billing Schedule total Amount is only 500, if the Item Amount is set to 1,000, the excess 500 is expected to be billed on the last schedule date. See sample schedule below:
If another Item is added in the Sales Order without a set Billing Schedule, the Item amount is expected to be billed fully on the first Billing Date.
-----
If you find this information useful, let us know by reacting or commenting on this post!