How Can We Help?
Payment terms say when an invoice is due and whether the order must be paid before it
ships. You choose them in the Terms combo on the customer’s Financials pane
(Customer Service → Customer Management), and every new quote or order copies them. The list
itself is kept in OJ Setup → Product Setup → Payment Terms.
What a term holds
| Setting | What it does |
|---|---|
| Description | The name shown in the Terms combo (e.g. NET30, COD). |
| Type | 1 = due a number of days after the invoice date. 2 = due on a fixed day of the month. Any other value = due on the invoice date. |
| Days | Type 1: the number of calendar days after the invoice date. |
| Day of month | Type 2: the day of the month the invoice falls due. |
| Days of due date | Type 2: the minimum number of days between the invoice date and the due date. 0 or less means 30. |
| Pay before ship | When on, an order with an outstanding balance cannot be added to a shipping manifest. |
| Pay-by lines | A list of dates with a discount percent, used for early payment discounts (below). |
| Discount, Reference | Stored; the discount on the term itself has no effect found (the early payment discount comes from the pay-by lines). Reference is the code other programs use for the term: it is sent to the SalesPad integration, and it picks the order’s terms when OpenJanela is launched from an outside program. |
How the invoice due date is worked out
When an invoice is created, its due date comes from the order’s terms:
- Type 1: invoice date + Days (calendar days; weekends are not skipped).
- Type 2: the system looks at the Day of month in the invoice’s month and the next five
months, and picks the first one that is at least Days of due date days after the invoice
date. - Other types: the invoice date.
Pay-by lines and early payment discount
Each pay-by line of the term adds a line to the invoice with a date and an amount:
- Date: the invoice date + the line’s days, or, when days is 0, the line’s day of the
month in the month of the due date. - Amount: the whole invoice balance less the line’s discount percent. The lines are
not split amounts; each says “pay this much if you pay by this date”.
When you record a customer payment and tick an invoice, the system takes the first pay-by line on or
after the payment date. If its amount is lower than the invoice amount, the difference is offered as the
discount on that payment.
Worked examples
| Term | Set up as | Invoice dated 3 March |
|---|---|---|
| Net 30 | Type 1, Days 30; one pay-by line 30 days, 0% | Due 2 April. Pay-by line: full amount by 2 April. |
| 2% 10, Net 30 | Type 1, Days 30; pay-by lines 10 days 2% and 30 days 0% | Due 2 April. On 1,000.00: pay 980.00 by 13 March, or 1,000.00 by 2 April. A payment entered on 10 March is offered a 20.00 discount. |
| 10th of the month, at least 15 days | Type 2, Day of month 10, Days of due date 15 | 10 March is only 7 days away, so the due date is 10 April. An invoice dated 20 February would be due 10 March (18 days). |
| COD / Net 0 | Type 1, Days 0, Pay before ship on | Due on the invoice date; the order cannot be put on a manifest until it is paid. |
Pay before ship
In Shipping Management → Ready to Ship, adding orders to a manifest is refused for every
order whose terms have Pay before ship and whose balance is above zero. The message names each order,
its outstanding balance and its terms, and ends: “Take the payment, or change the order’s
payment terms, before adding it to a manifest.” The check uses the order’s own terms, so
changing the customer’s Terms later does not change existing orders.
that does not exist in a month (for example 31 in April) can make invoice creation fail.