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.

Payment due date: General concepts

Usually, JustOn determines the Payment Due Date of an invoice adding the value of Payment Due (in days) to the set Invoice Date. That is,

Payment Due Date = Invoice Date + Payment Due

The invoice date is set on invoice finalization. For draft invoices, that is, those that are not yet finalized, JustOn displays a preliminary due date based on the current date (Today + Payment Due).

The payment due (the number of days to be added) is fetched – in this order – either from

• the invoice source record (PaymentDue on the subscription or ON_PaymentDue on another source object)
• the field Default Payment Due on the account, or
• the field Default Payment Due on the template.

If you have not set a default payment due on the account or the template, JustOn defaults to 0.

Once the invoice is finalized, you can no longer modify the payment due date. You can, however, postpone the payment due date for open and draft invoices. Doing so suspends applicable payment collections and dunning procedures for the specified time.

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.	2018-01-01	14d	14 (2018-01-15)
xd eom	Adds x days to the invoice date, then goes to the last day of the month.	2018-05-20	14d eom	41 (2018-06-30)
eom	Starting from the invoice date, goes to the last day of the month.	2018-02-05	eom	23 (2018-02-28)
xd y	Adds x days to the invoice date, then goes to the next yth day of the month.	2018-01-01	14d 10	40 (2018-02-10)
eom y	Goes to the last day of the month, then goes to the next yth day of the next month.	2018-02-12	eom 10	26 (2018-03-10)
y	Starting from the invoice date, goes to next yth day of the month.	2018-02-12	16	4 (2018-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.	2018-05-20	14d eom 20	61 (2018-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:

1. Open the invoice you want to modify.
2. Double-click the Payment Due Condition field and specify the intended calculation condition.
3. 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.