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 y th 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 y th day of the next month. |
2022-02-12 | eom 10 |
26 (2022-03-10) |
y |
Starting from the invoice date, goes to next y th 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 y th 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 Condition
field 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 Condition
field on the subscription. - When creating invoices from other objects using the generic invoice run, you create the ON field
ON_PaymentDueCondition
on 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_PaymentDueCondition
on the account.