In ISPnext, it is possible to maintain payment terms. If the user has the correct permissions and the functionality has been activated through addtional configuration, payment terms can be maintained via ‘Setup’ → ‘Financial setup’ →‘Payment terms’.
Important note: If this functionality is used, payment terms are no longer imported from the ERP system, including the standard payment terms. In addition, this functionality can only be activated through additional configuration and may involve additional costs. If you would like to make use of this functionality, please submit a change request to our support department. The support department will assess the request and share a cost estimate with you.
Detailscherm
Fields
|
Field |
Explanation |
|---|---|
| Company | The company to whom the payment term applies. |
| Code | The payment term code. |
| Description | The description of the payment term. |
| Base date |
The date on which the calculation of the payment period should be based. There is a choice between: Invoice date: The invoice date indicated on the invoice. |
| Frequence type | The payment term can be specified in days and months. |
| Frequence number | The number of days or months the payment indicates, belonging to the frequency type. |
| Planning |
The schedule that the calculation should adhere to for coming out at the correct due date. Calculated day: The day as calculated using the base date and frequency. |
| Specific day of the month | A specific day of the month, e.g. the 15th of the month. Should be entered as a number e.g.: 15. |
| Extra days | Additional days added at the end of the calculation after the base date, frequency, schedule, (and any specific date). |
Berekening & voorbeeld
The calculation of the due date following the payment period goes from top to bottom.
Thus, it first looks at the base date next it looks at the number of frequency days or months. Finally, it looks at the schedule and any specific or additional days.
The example below shows a complicated payment period:
End of month + 2 months + 4 days.
Invoice date: 03-05-2024
|
Field |
Choice |
Calculated due date |
|---|---|---|
| Base date | End of the month |
31-05-2024 |
| Frequence type | Month |
31-05-2024 |
| Frequence number | 2 |
31-07-2024 |
| Planning | Calculated day |
31-07-2024 |
| Specific day | 0 |
31-07-2024 |
| Extra days | 4 |
04-08-2024 |
Add payment term
Manually
It is possible to manually add a payment due date via the add button. When doing this, make sure that all fields are filled in correctly so that the calculation of the due date is correct.
Via Excel upload
The Excel template can be downloaded via the download icon. This can be used to add a whole new set of payment terms or to modify existing payment terms by overwriting the data.
In the Excel, the fields should be filled in according to the downloaded format so that the calculation of the due date is correct. It is not possible to change the columns, column names (titles) and order, as this will cause an error during the upload. This setup makes it possible to support complicated payment terms via various combinations. Then, via the upload icon, the file can be uploaded.
Format
The format from the Excel should be followed for a successful import. In doing so, it is important that the first row of titles is not modified strurcture is maintained. In addition, the fields below should be filled in with a specific format:
|
Veld |
Format |
|---|---|
|
Frequency number (Frequency_number) |
Numerical: maximum of 3 decimals |
|
Base date (base_date) |
|
|
Frequency type (frequency) |
Day: DAY Month: MONTH |
|
Planning (schedule) |
|
|
Specific day of the month (specific_day) |
Numerical: maximum of 3 decimals |
|
Extra days (extra_days) |
Numerical: maximum of 3 decimals |
Discount
It is also possible to record and process discount agreements associated with payment terms. The discount agreements must be set up separately using the 'Discounts' tab. It is possible to setup several discount agreements using the icon. Discount agreements can be deleted using the
icon. The discount agreements can also be left empty.
Via Excel upload
It is also possible to add the discount agreements using an Excel upload. The Excel template can be downloaded via the download icon. can be used to add a whole new set of payment terms and discount agreements or to modify existing payment terms and discount agreements by overwriting the data.
In the Excel, the fields should be filled in according to the downloaded format so that the calculation of the due date is correct. It is not possible to adjust the columns, column names (titles), and the order, this will cause an error during the upload. This setup makes it possible to support complicated payment terms and multiple discount agreements via different combinations. Then, via the upload icon, the file can be uploaded.
Format
The format from the Excel should be followed for a successful import. In doing so, it is important that the first row of titles is not modified strurcture is maintained. In addition, the fields below should be filled in with a specific format:
|
Field |
Format |
|---|---|
|
Field |
Format |
|
Company (Company) |
The company stated at the payment term. Partly due to this field, the discount term can be linked to the correct payment term. |
|
Betalingstermijn code (code) |
The code of the corresponding payment term. By the company and payment term code, the discount term can be linked to the correct setting. |
|
Dagen (days) |
The number of days until when discount applies. Numeric: maximum of 3 decimals. |
|
Percentage (percentage) |
The discount percentage belonging to the number of days. Numeric: maximum of 3 decimals. |
View discount
Invoice detail
- After setting up the payment term and discount, it is possible to see the discount date is and what discount amount can be achieved, under the header of the invoice.
Invoice overview
- The invoice overview also shows the (last possible) discount date and discount amount.
- By making use of the Quick Access block it is possible to quickly navigate to all invoices with discount. By sorting the discount date column it is possible to further specify.