How to customize the payment due calculation?
← Billing & Invoice Management FAQ
Usually, JustOn determines the Payment Due Date of an invoice adding the value of Payment Due (in days) to the set Invoice Date.
For details on payment due date concepts, see How to control the payment due date?.
Your business may, however, require a more flexible way for determining the Payment Due Date – like, for example, you want it always to be set automatically to the last day of the next month. To this end, use the Invoice field Payment Due Condition. It provides a way to define a custom calculation for the Payment Due Date and for the Payment Due value.
JustOn evaluates the Payment Due Condition
- on invoice creation,
- when setting a date on (draft) invoices,
- on invoice finalization.
Note
Each evaluation recalculates the values for Payment Due Date and Payment Due. Hence, do not set Payment Due when using Payment Due Condition.
The following table lists the calculation options for Payment Due Condition and illustrates the behavior:
| Pattern | Result | Example Invoice Date | Example Payment Due Condition | Calculated Payment Due (Date) |
|---|---|---|---|---|
xd |
Adds x days to the invoice date. |
2022-01-01 | 14d |
14 (2022-01-15) |
xd eom |
Adds x days to the invoice date, then goes to the last day of the month. |
2022-05-20 | 14d eom |
41 (2022-06-30) |
eom |
Starting from the invoice date, goes to the last day of the month. | 2022-02-05 | eom |
23 (2022-02-28) |
xd y |
Adds x days to the invoice date, then goes to the next yth day of the month. |
2022-01-01 | 14d 10 |
40 (2022-02-10) |
eom y |
Goes to the last day of the month, then goes to the next yth day of the next month. |
2022-02-12 | eom 10 |
26 (2022-03-10) |
y |
Starting from the invoice date, goes to next yth day of the month. |
2022-02-12 | 16 |
4 (2022-02-16) |
xd eom y |
Adds x days to the invoice date, then goes to the last day of the month, then goes to the next yth day of the next month. |
2022-05-20 | 14d eom 20 |
61 (2022-07-20) |
The spelling of eom in the picklist values does not matter – you can use lowercase, all caps or mixed-case spelling. JustOn converts the letters to lowercase before processing the payment due condition.
To set the payment due condition for a draft invoice:
- Open the invoice you want to modify.
- Click
next to the
Payment Due Conditionfield and specify the intended calculation condition. - Click Save.
Info
As an alternative to the manual configuration, you can have JustOn set the payment due condition automatically.
- When creating invoices from subscriptions, you can set the
Payment Due Conditionfield on the subscription. - When creating invoices from other objects using the generic invoice run, you create the ON field
ON_PaymentDueConditionon the source object to have these values set on the resulting invoice. - To define payment due conditions on an account-specific basis, you create and set the ON field
ON_PaymentDueConditionon the account.