Common data > BP tables > Payment terms 

Use this table to define the payment conditions used in invoices (irrespective of whether they are customer or supplier).
They are transferred to sales, purchasing and A/P-A/R accounting documents (orders, invoices…).
They can be modified if required in each document.

A payment condition is composed of one or more lines, each line corresponding to an open item calculation rule and a payment method.
This way, for a given invoice, schedules with multiple due dates can be defined, the various due dates each corresponding to a record of the open items table.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Presentation

The setup of the grid is used to:

  • implement a variable method that enables the due date for the open items to be calculated based on the original document date, with the possibility to add a number of days or months. The due date can be forced to the end of month (Fdm column) and/or be pushed to the next fixed day on the month given in a list with a maximum of 6 set days(D1, D2, D3, D4, D5, D6).
    An additional option exists to exclude certain days of the week or holidays from the calculation. It should be noted that, by convention the fixed day 99 signifies the last day of the month,
  • to enter an open item minimum amount.
    If this minimum amount has not been reached for a given open item, the amount is transferred to the next open item (except if there is none).

Close

 

Fields

The following fields are present on this tab :

Block number 1

Code associated by default with the current BP, used to define the payment conditions.
This code defines the payment method, open item type, as well as the payment schedule (one or several open items cash, 30 days, end of month etc.).
When managing this table, it is possible to simulate the calculation rules that will be applied in entry mode.

In creation mode, the legislation code can be initialized via the user parameter LEGFIL - Legislation (selection filter) (SUP chapter, INT group). This parameter is also used to filter the selection panel in order to present only the codes defined for this legislation and those defined at the All legislations level.
If a legislation is entered, the payment condition can only be used on documents associated to the companies set up with this legislation.
SEEREFERTTO For further information, refer to the documentation on general principles linked to the multi-legislation setup.

SEEINFONotes:

  • If a legislation is specified, only payment methods defined for this legislation can be associated to this payment condition.
  • If no legislation is specified, only the payment methods defined as All legislations can be associated to this payment condition.
  • Description (field DESAXX)

This long description is used as a title in screens and reports.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFOThe connection language must be defined as a default language for thefolder.

  • Short description (field SHOAXX)

Short title used in the screens and reports. This title is recorded in your connection language.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFOThe connection language must be defined as a default language for thefolder.

By entering a company group, you can limit the scope to companies in the selected group only. When this data is used for another record or with a setup element also defined in the group, a control checks that the groups have at least one company in common when the groups are different.  

In addition, a consistency check is performed for the legislations of the companies in the selected group.
At least one of these companies must have the same legislation as the one entered in the Legislation field. If  not, a warning message displays.

If a group is entered, the payment condition can only be used on documents associated to the companies of this group.
There is a control to check the coherence between the legislation/group specified for the payment condition and the legislation/group of the document.
SEEREFERTTO For further information, refer to the documentation on general principles linked to the multi-legislation setup.

Peculiarity linked to the use of a payment condition in the Customer BP and Supplier BP setup:
Using a payment condition in the BP/Companies setup is only possible if the group indicated on the payment condition matches the group to which the BP company belongs. The All groups notion is not taken into account.

SEEINFONote:

  • If a group is specified, only payment methods defined for this group can be associated to this payment condition.
  • If no group is specified, only the payment methods defined in All groups can be associated to this payment condition.

Grid Management

  • No. (field PTELIN)

 

The payment method defines the payment means (check, cash, bank card, instrument etc.).

  • SEPA (field TAMSDDFLG)

This indicator is automatically activated when at least one of the payment methods is SEPA-type.

  • Due date % (field DUDPRC)

Specify, for each open item line to calculate, the part of the tax inc. amount of the document that has to be assigned to this open item line. This proportion is expressed in percentage. If there is only one open item to calculate, enter 100% in this field.

  • Sales tax % (field VATPRC)

  • If the activity code TPT - Payment conditions with VAT is active, the column Sales tax % is displayed in addition to the column Due date % .
    If the payment is of the Prepayment type and if the Sales tax % field has for value 0, the calculation of the automatically generated prepayment will be based on the excluding tax amount of the order.
    If the payment is of the Prepayment type and if the Sales tax % field has for value 100, the calculation of the automatically generated prepayment will be based on the tax-including amount of the order.
  • If this TPT activity code is not active, only the column Due date % is displayed.
    The calculation of the automatically generated prepayment is based on the tax-including amount of the order.

  • Payment type (field PAMTYP)

Specify the open item payment type.

Prepayment

The open items are paid before the invoice is issued.

Open item

The open items are paid on the invoice issue date.

Holdback

The invoice is considered as closed, although no payment has been made. No specific set of accounting entries is triggered.

 
  • Months (field NBRMON)

Specify the number of months to be added to the start date during the due date calculation so to determine the due date.
For example, the following results will be obtained with a time-lag equal to 1 month:

  • 15/12/1997 + 1 month = 15/01/1998 (31 days month)
  • 30/06/1998 + 1 month = 30/07/1998 (30 days month)
  • 30/01/1998 + 1 month = 28/02/1998 (28 days month)
  • Days (field NBRDAY)

Specify the number of days to be added to the start date during the due date calculation so to determine the due date.
It is the exact number of days.

  • Month end (field ENDMONFLG)

The three values for this field are:

No

The flag is not taken into account.

End of next month:

The due date calculated after applying the number of months and days is postponed until a month end (ex: 45 days and on month end).

End of current month:

The due date start is postponed up to the end of month first and then the additional number of months and days are applied to determine the final due date (ex: End of month and 45 days).

  • Day 1 (field J1)

The value entered must be a date in the month (between 1 and 30) or 99 which corresponds to the last day of the month.
The use of this date is used to automatically postpone the due date calculated up to the nearest day of the month.
There can be up to 6 days on a same scheduled invoice line.

  • Day 2 (field J2)

 

  • Day 3 (field J3)

 

  • Day 4 (field J4)

 

  • Day 5 (field J5)

 

  • Day 6 (field J6)

 

  • Minimum due date amount (field DUDMINAMT)

Specify the minimum amount for this open item.
If the amount is not reached the concerned open item date is postponed to the following due date.

 

Block number 3

  • SDD management (field SDDFLG)

The management of this field is subject to the activity code SDD - SDD management.
This flag cannot be entered. It is automatically activated when at least one of the payment methods is SEPA-type.

Specify the code of the payment term to be used when the total amount of the journal entry is lower that a given threshold.

A substitute payment method applies if the total payment amount is lower than the threshold. This is a cascading process: for example, a payment by draft is replaced with a payment by check when the amount is below the threshold, and then replaced with a payment in cash if the amount is even lower.

 
  • If amount less than (field PTEMINAMT)

Minimum amount under which the conditions of replacement payment are used.
This value is only entered when the condition of replacement payment has been entered.

 

  • Holidays excluded (field FBDHLYFLG)

Specify if the due date calculated can correspond to a bank holiday. If the due date calculated corresponds to a forbidden day, the due date is systematically postponed to the next authorized day. This check is combined with the authorized days of the week.

  • Statement due date (field SOIFLG)

If this box is checked, the due dates calculated from these payment conditions are taken into account by the automatic generation of customer statements (knowing that each payment method has a statement code used to refine the rules, which can be modified due date by due date).

Excluded days

  • field FBDDAYFLG

Specify for which days of the week a due date calculation is authorized. If the due date calculated corresponds to a forbidden day, the due date is systematically postponed to the next authorized day.
This control is combined with the bank holidays.

Close

 

Specific buttons

Click this action to display a screen in which you can enter a global payment amount and a start date. The various open item lines are then displayed at the bottom of the simulation screen.
If a substitute payment method has been used, its code will display at the bottom of the screen.

The following fields are included on the window opened through this button :

Block number 1

  • field OBJET

 

  • field CLES

 

Block number 2

  • From folder (field DOSORG)

Use this field to define the folder from which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

  • All folders (field TOUDOS)

Use this option to copy the record to all the folders defined in the dictionary (ADOSSIER table of the current solution).

  • To folder (field DOSDES)

Use this field to define the folder to which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

Close

Click this action to transfer all table contents to another folder.

Local menus

In addition to the generic error messages, the following messages can appear during the entry :

The total must not exceed 100%
The distribution does not reach 100%

These two messages appear when the total of percentages assigned to the open item lines is not equal to 100% (either higher or lower).

All days are excluded!

This message appears if you have checked all the days of the week.

Tables used

SEEREFERTTO Refer to documentation Implementation