Use this function to generate automatic payment proposals for posting invoice payments from the Purchasing, Sales, or A/P-A/R accounting modules.
Open items (invoices and credit memos) that cannot be managed by this function:
Open items that are not yet recorded on a statement.
Open items with an unknown payment approval status ("payment approval" field different from "payment approval").
See Payment entry (GESPAY) to generate payments manually.
Refer to documentation Implementation
The automatic payment proposal is carried out on a selection of open items of invoices/credit memos. Payments are generated thanks to the data available on the original invoice, but also using information available in the automatic proposal screen. These screens can be displayed in two different ways:
For the same sequence of invoice open items to be settled, there can be one or more payments created on the basis of the selection and the chosen options.
For example: by default, a single payment is created for a set of invoice open items with different due dates for the same BP. If the option 'one payment/due date' has been selected, as many payments are created as there are due dates.
The open item is thus a 'fixed' concept, that represents the amount to be paid for a specific invoice. On the other hand, the concept of payment varies since it is defined for a selection of options.
From the results table, right-click the invoice to specify whether the discount has been generated.
Presentation
It is important to indicate the action to be performed:
It is mandatory to enter the company on which the payment campaign is carried out.
Two blocks of criteria ('Due date' and 'Settlement discount') help refine the selection of the open items to be paid. Each of them corresponds to an open item selection mode.
These two selection blocks must be considered as being independent from one another and linked by condition 'OR'.
Data:
| No. of days | rate |
1 | -10/ | -10.00/ |
2 | 0/ | 0.00/ |
|
|
|
| Discount | 'Virtual' discount date | Due date until |
Open item A | Yes | August 20 | August 30 |
Open item B | Yes | August 05 | August 15 |
Open item C | No | - | August 28 |
Open item D | Yes | August 03 | August 13 |
Criteria and results:
Close
Fields
The following fields are present on this tab :
Block number 1
|
Only open items associated with a type of payment with this sense will be generated. |
Block number 2
|
Only the open items for this company will be taken into account for the payment generation. |
Date selection mode
|
  |
Due date
|
Open items from: (1). to (2). Early discount until: (3). In a nutshell, if all the dates are entered, the following open items will be taken into account:
|
|
  |
Settlement discount
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
Close
Fields
The following fields are present on this tab :
Block number 1
|
Select this check box to include all payment transactions. If not, the Transaction field is required. When you select this check box, the Bank ID country, IBAN prefix, and Bank ID number columns display in the Details grid on the Payment proposal selection window. In this case, Bank ID number is required and the line is highlighted red if a mandatory field missing. |
|
Enter a single transaction for automatic payment proposals. This field is available when the All transactions check box is not selected. If Bank ID is managed for the specific transaction, the Bank ID country, IBAN prefix, and Bank ID number columns display in the Details grid on the Payment proposal selection window. In this case, Bank ID number is required and the line is highlighted red if a mandatory field is missing. If Bank ID is not managed for the transaction, these three columns do not display in the Details grid. Depending on the sense chosen (Expense or Revenue), the payment transaction proposals vary (see the documentation on the setup of the Payment transactions). If no transaction is selected, each payment is created on the first payment transaction encountered which refers to the payment mode. A filter can be applied to the payment mode: only the invoices or open items showing the selected payment mode will be taken into account (as a reminder, the payment mode is defined via the payment condition). Example 1: Data:
The first two payment conditions are linked to the CHQ payment mode (Check). The last one is linked to the VIR payment mode (VIR for Transfer). The CCHQ (Received checks) and CCHQR (Checks to cash) payment transactions use the CHQ payment mode. Only the CVIR (Received transfers) payment transaction use the VIR payment mode. Result:
Various payments are generated for the invoice open items on statement (see the explanations on the specific processings). Example 2: Data: Result: Example 3: Data: Result: Conclusion of the examples 1 and 2: the payment mode acts as a filter, either because it is a selection criterion (Example 2) or because, when it is associated with a transaction, it only authorizes open items involved by said payment mode (Example 3).
Example 4: For 10 invoice open items having the check as the payment mode (CHQ), all are settled, but only two are placed in intermediate posting These two payments must be entered under the CCHQR transaction. It is then possible to launch the automatic payment proposal for the other open items, by specifying the CCHQ transaction. Another method (using the "Control" mode) consists in generating all the payments on the CCHQ transaction, then refining the obtained result by deselecting the two payments to be recorded under draft management. It will then be possible to restart a campaign for the CCHQR transaction. |
|
All payment modes or a particular payment mode. |
|
Enter a single transaction for automatic payment proposals. This field is available when the All transactions check box is not selected. If Bank ID is managed for the specific transaction, the Bank ID country, IBAN prefix, and Bank ID number columns display in the Details grid on the Payment proposal selection window. In this case, Bank ID number is required and the line is highlighted red if a mandatory field is missing. If Bank ID is not managed for the transaction, these three columns do not display in the Details grid. Depending on the sense chosen (Expense or Revenue), the payment transaction proposals vary (see the documentation on the setup of the Payment transactions). If no transaction is selected, each payment is created on the first payment transaction encountered which refers to the payment mode. A filter can be applied to the payment mode: only the invoices or open items showing the selected payment mode will be taken into account (as a reminder, the payment mode is defined via the payment condition). Example 1: Data:
The first two payment conditions are linked to the CHQ payment mode (Check). The last one is linked to the VIR payment mode (VIR for Transfer). The CCHQ (Received checks) and CCHQR (Checks to cash) payment transactions use the CHQ payment mode. Only the CVIR (Received transfers) payment transaction use the VIR payment mode. Result:
Various payments are generated for the invoice open items on statement (see the explanations on the specific processings). Example 2: Data: Result: Example 3: Data: Result: Conclusion of the examples 1 and 2: the payment mode acts as a filter, either because it is a selection criterion (Example 2) or because, when it is associated with a transaction, it only authorizes open items involved by said payment mode (Example 3).
Example 4: For 10 invoice open items having the check as the payment mode (CHQ), all are settled, but only two are placed in intermediate posting These two payments must be entered under the CCHQR transaction. It is then possible to launch the automatic payment proposal for the other open items, by specifying the CCHQ transaction. Another method (using the "Control" mode) consists in generating all the payments on the CCHQ transaction, then refining the obtained result by deselecting the two payments to be recorded under draft management. It will then be possible to restart a campaign for the CCHQR transaction. |
|
Select this check box to include all sites for the selected company. |
|
Only the open items for this site will be taken into account for the payment generation. |
|
All BP types or a specific BP. |
|
Only the open items with this BP type will be taken into account for the payment generation. |
|
All BPs or a particular BP. |
|
The entered BP type must match the BP type that may have been entered previously. |
|
  |
|
  |
|
  |
Control accounts
|
If entered, only the open items whose collective account belongs to this group will be taken into account for the payment generation. |
|
Only the open items for this collective account will be taken into account for the payment generation. |
|
  |
Currencies
|
If entered, only the open items whose currency belongs to this group will be taken into account for the payment generation. |
|
If entered, only the open items for this currency will be taken into account for the payment generation. |
Open items
|
If yes, the pre-payment open items will also be taken into account for the payment generation. |
|
Clear this check box to filter the selection based on the open item entry type or based on a range of journal entry numbers. |
|
  |
|
  |
|
  |
Close
Presentation
When the invoice open items are entered on a statement, two separate cases occur:
In both cases, a payment specific to the statement is created.
Close
Fields
The following fields are present on this tab :
Amounts
|
If entered, only the open items whose amount is lower than this amount will be taken into account for the payment generation. |
  |
|
If this field is entered, only the payments in reporting currency with an amount greater than this amount are created. Caution, the payment amount depends on the selected payment options (for example: does the payment include all the open items on a single payment transaction? Does it have a range? Is it a payment by site, by open item, etc. ?) |
  |
|
The proposal will be limited to this amount, expressed in reporting currency. |
  |
Bank
|
This field displays the bank to which the payments are assigned. The mentioned bank must necessarily be associated with the company for which the automatic payment proposal is activated. The entry transaction of Payments determines if the information is mandatory or optional. |
|
Bank allocation to which payments will be allocated. If neither a bank nor a bank allocation have been entered, and the bank is mandatory for a type of payment previously entered, entry of a bank of a bank allocation is requested. |
|
In the event of a maximum proposal amount, if the payments are allocated to a bank allocation, this specifies which priority should be given to the open items to be integrated to a payment. In the other cases, the priority is given to large amounts. |
Payment grouping
|
If yes, a payment will be generated by open item meeting the criteria. |
|
If yes, the open items with the same due dates will be grouped together in a single payment. |
|
If yes:
|
|
If yes, the open items with the same site will be grouped together in a single payment. |
Miscellaneous
|
A log file is displayed at the end of the payment proposal. It draws up the list of the payments that are created or to be created in case of simulation.
|
|
If yes, a text file is generated and it displays the list of the submitted payments. |
|
If this option is checked, launching the automatic proposal will open a screen underlining the open items submitted for payment. Before the payments submitted by the program are generated, the user can modify the proposal. They can choose not to pay some open items, to modify the amount submitted for payment or the early discount amount of some other open items. The user can also decide not to generate anything. This type of generation is only possible if the "Simulation" field is not checked. |
|
This field is available when the Control check box is selected. When you select the Default selection check box, the Select column on the Payment proposal selection screen defaults to Yes for all suggested payments. If this box is not selected, the default value for this column is No. In either case, you can still select Yes or No for each proposed payment. |
Payments
|
Site of the generated payments. It must be compatible with the company, bank or bank allocation. |
|
Collective account of the generated payments. It must be compatible with the BP that may have been selected previously. |
|
  |
|
Optional field that is used to generated the payments in a specific currency. |
|
For the transactions with management by due date and whose first posting is the bank posting, payments are generated at the due dates. In the other cases, payments are generated at the date entered here. |
|
Note reference. |
|
The information indicated in this field is used for generating bank files in the SEPA format. It corresponds to the field 'Purpose code' in the .xml file. |
Close
Presentation
This screen displays the list of open items that can be proposed for payment based on the criteria from the previous screens.
From this window, you have the following options from the Action panel:
Create:
Currency totals: Click this button to view payment totals by currently.
Report: Generate the PAYPROPLIST - Automatic proposal report from information in the Details grid.
Details grid
This grid displays information for each open item for which payments are proposed. The Bank ID country, IBAN prefix, and Bank ID number columns display under these conditions:
The All transactions check box is selected on the Criteria tab.
Bank ID is managed for a selected transaction. In this case, the Bank ID is required. If it is missing, the line is highlighted in red.
Close
Fields
The following fields are present on this tab :
Block number 1
|
  |
|
  |
|
  |
  |
|
  |
  |
|
  |
  |
Block number 2
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
Grid Details
|
This field is used to remove specific due dates suggested in payment by the program. Only due dates with this zone set to 'YES' will be posted on the generated payments. |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
This field is initialized with the amount suggested in the due date payment. It is expressed in due date currency. The user can modify the amount of the due date payment. |
|
This field is initialized with the discount amount of the open item calculated by the automatic proposition program, as a function of the discount code associated with the invoice. Once a discount code is associated with an open item, the discount amount can be modified. |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
This field displays the country for the Bank ID. This field displays when the All transactions check box is selected on the Criteria tab or when Bank I D (BID) is managed for a selected transaction. If BID is managed and a mandatory field is missing, the line is highlighted in red. |
|
This field displays the IBAN prefix. This field displays when the All transactions check box is selected on the Criteria tab or when Bank ID (BID) is managed for a selected transaction. If BID is managed and a mandatory field is missing, the line is highlighted in red. |
|
This field displays when the All transactions check box is selected on the Criteria tab or when Bank ID (BID) is managed a selected transaction. The Bank ID displayed defaults from one of the BP’s pay-by addresses and there can be a different BID for each pay-by address. If you change the Bank ID, it changes for all lines for the same payment and that are set to Yes in the Select column for the line. The related Bank ID country and IBAN prefix fields update to match the new Bank ID. If BID is managed and the Bank ID number field is empty, the line is highlighted in red if a mandatory field is missing. |
Block number 4
|
  |
|
  |
  |
Close
The PAYPROPLIST - Automatic proposal report is generated from the control grid that displays the list of the open items which could be proposed for payment. Hence, it is only available when the processing control for the automatic proposal has been requested. For the same reason, this report cannot be edited through the standard function of report generation.
lt can be generated by clicking the Edit menu in the Action panel or clicking List from Print pull-down menu. The standard print screen displays for the entry of the report settings.
By default, open items marked in the table to be paid (Yes in the Selection column) are printed in the report. However, the report setting Print excluded payments can modify this.
This function can be run in batch mode. The standard task PAYPROPAL is provided for that purpose.
When a discount line related to the early payment of a purchase or a supplier invoice is generated, a negative capitalizable expense is automatically created provided the following terms are met:
When the payment entry transaction sets several steps for the paying process, the expense generation related to the discount takes place during the first step of the payment posting.
The reference of the generated expense is mentioned in the corresponding log after the payment saving.
At the expense level, the payment reference is displayed in the field: Invoice and the Invoice type gets the value: Early discounts/Late charges.
Should the payment related to a discount be cancelled:
When the company manages tax discounts for the invoicing elements (the DEPMGTMOD - Discount management mode parameter (TC chapter, INV group) is set to Rebate on VAT), then the early discount/late charge amounts in payment entry or proposal includes taxes. The calculation does not take into account the VAT already deducted from the early discount/late charge when invoicing.
After cancelling a payment, the open items for a payment and associated open items:
This is because the accounting cancellation of a payment does not always take into account the matching information if:
Creating payments for an inactive BP is prohibited in Manual entry of payments.
To avoid completely blocking the recording of a payment received from, or directed to, a recently inactive BP, the payment of the open items for this BP remains possible in the automatic Payment proposals function.
While creating a payment by selecting an open item date, the Currency field is loaded with the currency of the first selected open item date. The currency cannot be modified.
If you require a payment currency different from the open item currency, enter the payment currency before selecting a due date.
Sage X3 does not manage the following cases in standard mode: payment in currency A and prepayment in currency B, with a BP in the payment header different from the BP of the order.
In the selection panel, the Open items and Grouped open items lists only suggest open items with an entry type where the Management of open items check box is selected.
Specific case :
For a payment in creation progress with the payment site not yet entered (payment legislation not known). In this case, the legislation of the entry type to be considered is determined as follows:
Exceptions when the entry type is linked to no legislation:
1) When the site is not specified on the payment, the open item is displayed in the grouped open item list, even when the open item has been posted for a company with a legislation different from the one of the entry transaction.
2) If the payment entry transaction is not linked to any legislation, the open item is displayed, regardless of the default folder legislation or value of the LEGFIL parameter.
If you allocate open items by manual matching, the payment remains allocated and the payment is still displayed on the print-out.
When creating a prepayment open item linked to a sales order where the Exempted tax field is set to Yes, the following apply: