Payment Proposals
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.
See Payment entry (GESPAY) to generate payments manually.
If the PAYUNALL - Unalloc. payments considered parameter (TRS chapter, PAY group) is set to Yes, the Selection list displays unallocated payments under Open items and .
Prerequisites
Refer to documentation Implementation
Screen management
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:
- in a control grid, that lists the payments coming from the campaign ('Control' mode activated in the second tab), or
- in the payment entry function ('Control' mode deactivated).
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.
Header
It is important to indicate the action to be performed:
- a withdrawal (Expense)
- a receipt (Revenue)
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.
- Due date block: a date range makes it possible to select the open items according to their due dates.
- Settlement discount block: only applies to the open items entered with an early discount/late charge code. In this case, the selection criteria are:
- a discount date range
- a due date range, whose activation is determined by the general parameter DEPDUDDAT - Due dates in discount section (TRS chapter, TDC group)
- a number of allowance days
- a check box 'Always discount'
These two selection blocks must be considered as being independent from one another and linked by condition 'OR'.
For example:
Data:
- The DATDEP - AR Discount reference date (chapter TRS, group TDC) has the 'Due date' value.
- The early discount/late charge code is set up as follows:
No. of days
rate
1
-10/
-10.00/
2
0/
0.00/
A 10% discount is applied if the payment is made more than ten days before the due date. - Open items contained in the database:
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:
- Example no. 1: 'Due date' block only.
Criteria entry: due date from August 20 to August 31.
Selection of open items A and C.
- Example no. 2: The DEPDUDDAT - Due dates in discount section parameter has the 'Activated' value. 'Settlement discount' block only.
Criteria entry:
- discount date from August 06 to August 20,
- due date from August 10 to August 30,
- no allowance days, nor always discount option.
Selection of open item A:
With a number of allowance days = 2, open items A and B would be selected.
If the accounting date of the payment is August 23, a payment will indeed be generated for these two open items, but without the benefit of an early discount since the payment is too late with respect to the 'virtual' discount date.
If in addition the always discount option were selected, the selection would still concern open items A and B, but whatever the payment accounting date, the two selected open items would benefit from the calculation of an early discount.
- Example n°3: The DEPDUDDAT - Due dates in discount section parameter has the "Activated" value.
Use of both selection modes at a time, with the same criteria as above.
Selection of open items A and C.
With a number of allowance days = 2, open items A, B and C would be selected.
If in addition the always discount option were selected, the selection would still concern open items A, B and C. But whatever the payment accounting date, open items A and B (entered with a discount code) would benefit from the calculation of an early discount.
Block number 1
Payment sign (field SNS) |
Block number 2
Company (field CPY) |
Date selection mode
Date selection mode (field DATSELMODE) |
Due date
From due date (field DATMIN) |
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:
|
To due date (field DATMAX) |
Settlement discount
From discount date (field DATDISMIN) |
To discount date (field DATDISMAX) |
From due date (field DATDISDUDM) |
To due date (field DATDISDUDM) |
Allowance days (field ADDALLDAY) |
Always discount (field ALWDISFLG) |
Tab Criteria
Block number 1
All transactions (field ALLTPY) |
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. |
Transaction (field TPY) |
Enter a single transaction for automatic payment proposals. This field is available when the All transactions check box is not selected. If the bank details are managed for the specific transaction, the Bank details country, IBAN prefix, and Bank acct. country columns display in the Details grid on the Payment proposal selection window. In this case, the bank account number is required and the line is highlighted red if a mandatory field is missing. If bank details are not managed for the transaction, these three columns do not display in the Details grid. Depending on the sign (Expense or Revenue), the payment transaction proposals vary (see the documentation the Payment transactions setup). If no transaction is selected, each payment is created on the first payment transaction found 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 using 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). All validated invoice open items using the payment mode(s) linked to the payment transaction, and meeting the other selection conditions, are submitted for payment WITHIN THE SAME TRANSACTION.Exceptions must be managed either in the control grid (if the "Control" option is activated) or, if the case arises, directly upon payment entry. 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 as notes payable/receivable. It will then be possible to restart a campaign for the CCHQR transaction. |
All payment methods (field ALLPAM) |
Payment method (field PAM) |
Enter a single transaction for automatic payment proposals. This field is available when the All transactions check box is not selected. If the bank details are managed for the specific transaction, the Bank details country, IBAN prefix, and Bank acct. country columns display in the Details grid on the Payment proposal selection window. In this case, the bank account number is required and the line is highlighted red if a mandatory field is missing. If bank details are not managed for the transaction, these three columns do not display in the Details grid. Depending on the sign (Expense or Revenue), the payment transaction proposals vary (see the documentation the Payment transactions setup). If no transaction is selected, each payment is created on the first payment transaction found 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 using 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). All validated invoice open items using the payment mode(s) linked to the payment transaction, and meeting the other selection conditions, are submitted for payment WITHIN THE SAME TRANSACTION.Exceptions must be managed either in the control grid (if the "Control" option is activated) or, if the case arises, directly upon payment entry. 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 as notes payable/receivable. It will then be possible to restart a campaign for the CCHQR transaction. |
All sites (field ALLFCY) |
Select this check box to include all sites for the selected company. |
Site (field FCY) |
All BP types (field ALLTYPBPR) |
BP type (field TYPBPR) |
All BPs (field ALLBPR) |
From BP (field BPRDEB) |
To BP (field BPRFIN) |
All users (field ALLUSR) |
User (field USR) |
Control accounts
Control group (field GRPSAC) |
Control (field SAC) |
Account (field SACACC) |
Currencies
Currency group (field GRPCUR) |
Currency (field CUR) |
Open items
Prepayments (field INSFLG) |
All document types (field ALLTYP) |
Clear this check box to filter the selection based on the open item entry type or based on a range of journal entry numbers. |
Entry type (field TYP) |
From entry (field PCEDEB) |
To entry (field PCEFIN) |
Tab Generations
Open items on statement
When the invoice open items are entered on a statement, two separate cases occur:
- If there is no statement posting (the value of the parameter SOICPT - Statement posting (TRS chapter, SOI group) is set to No), the payment is submitted for the open items on the basis of the characteristics of the statement (payment mode, site, etc.).
- In the event of statement posting (the value of the SOICPT - Statement posting parameter is set to Yes), the payment is submitted for the open item associated with the journal that closed the statement.
In both cases, a payment specific to the statement is created.
Amounts
Maximum item (field DUDMNTMAX) |
If entered, only the open items whose amount is lower than this amount will be taken into account for the payment generation. |
field CURDUDMAX |
Minimum payment (field PAYMNTMIN) |
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. ?) |
field CURPAYMIN |
Total maximum (field MNTMAX) |
field CURMNTMAX |
Bank
Bank (field BAN) |
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. |
Banking pool (field POO) |
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. |
Application mode (field ALLMOD) |
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
One item/payment (field PAYDUD) |
Due date (field PAYDUDDAT) |
Control account (field PAYSAC) |
If yes:
|
Site (field PAYFCY) |
Miscellaneous
Sort order (field ORDRE) |
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.
|
Simulation (field SIM) |
Control (field CTLFLG) |
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. |
Default selection (field SELDEF) |
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 (field FCYPAY) |
Site of the generated payments. It must be compatible with the company, bank or bank allocation. |
Control (field SACPAY) |
Collective account of the generated payments. It must be compatible with the BP that may have been selected previously. |
Account (field SACPAYACC) |
Currency (field CURPAY) |
Optional field that is used to generated the payments in a specific currency. |
Accounting date (field ACCDAT) |
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. |
Remittance reference (field REF) |
Payment nature (field EPANATPAY) |
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. |
Payment proposal selection
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.
Block number 1
Site (field FCY) |
Remittance reference (field REF) |
Maximum item (field DUDMNTMAX) |
field CURDUDMAX |
Minimum payment (field PAYMNTMIN) |
field CURPAYMIN |
Total maximum (field MNTMAX) |
field CURMNTMAX |
Block number 2
Accounting date (field ACCDAT) |
Control (field SACPAY) |
field SACPAYACC |
Currency (field CURPAY) |
Bank (field BAN) |
Banking pool (field POO) |
Grid Details
Select (field SELEC) |
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. |
BPs (field BPRPAY) |
Company name (field BPRNAM) |
Due date (field DUDDAT) |
Accounting date (field ACCDATLIN) |
Discount date (field DISDAT) |
Type (field TYP) |
Invoice (field NUM) |
Original document (field ORINUM) |
Curr. (field CUR) |
Amount (field AMTCUR) |
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. |
Discount/Late charge (field AMTDEP) |
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. |
Withholdings (field RITAMT) |
Balance (field SOLDE) |
field AMTLOC |
Site (field FCYLIN) |
Ctrl. (field SAC) |
Account (field SACACC) |
Address (field BPAPAY) |
Bank (field BANLIN) |
Trans. (field PAYTYP) |
Initial payment terms (field PTE) |
Payment method (field PAYMETH) |
Bank acct. country (field BIDCRY) |
This field displays the country for the bank account number. This field displays when the All transactions check box is selected on the Criteria section or when the bank account number is managed for a selected transaction. If the bank account number is managed and a mandatory field is missing, the line is highlighted in red. |
IBAN prefix (field IBAN) |
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. |
Bank acct. number (field BIDNUM) |
This field displays when the All transactions check box is selected on the Criteria section or when the bank account number is managed a selected transaction. The bank account number displayed defaults from the BP pay-by addresses and different account numbers can be entered for each pay-by address. If you change the bank account number, 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 account country and IBAN prefix fields update to match the new bank account number. If the bank account number is managed and the Bank account no. field is empty, the line is highlighted in red if a mandatory field is missing. |
Block number 4
No. of payments (field NBRPAY) |
General total (field TOTAMTCPY) |
field CURCPY |
Reports
The PAYPROPLIST - Automatic proposal report is generated from the control grid that displays the list of the open items that could be proposed for payment. 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 report generation function.
Click Report or List from the Print pull-down menu to access the report parameters.
By default, only 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.
Use the Print specific detail report parameter to display the specific bank ID for the payment if it is different from the BP default Bank ID. The specific bank ID and payment method display on a separate line below the payment.
Batch task
This function can be run in batch mode. The standard task PAYPROPAL is provided for that purpose.
Conditions for the automatic creation of a capitalizable expenditure
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:
- The company is submitted to the German or Austrian legislation.
- The DEPMGTMOD - Discount management mode parameter (Module TC, group INV) has the value: Distribution by VAT (invoice level).
- Payment attribute: The setup of the discount line accounting code is compliant with:
- The Expense creation box is checked.
- The Early discount/Late charge box is checked.
- The generated entry matches this pattern: Account <=> BP.
- Accounting codes: The accounting allocations of Tax type codes (determined from the tax code on the payment line) are defined for line 13 Adjustment to deduct. These are used for the accounting allocations of the negative expense.
- Account setup:
- the Fixed asset tracking must be activated in order to authorize the use of the account on assets and expenditures that are managed in the Fixed assetsmodule,
- the Expense creation must be authorized,
- the Accounting nature must be entered.
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:
- The discount expense is automatically cancelled if it has not been capitalized yet.
- A positive expense is automatically created if the discount expense has already been capitalized.
Menu Bar
Recall |
Click this action to enter a Memo code to load the settings associated with the code. |
Del Memo |
Click this action to delete a Memo code. |
Limitations
Management of tax discounts
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.
Unmatching/Rematching
After cancelling a payment, the open items for a payment and associated open items:
- Could no longer be matched
- Could be partially matched (in lowercase) although the group is balanced
This is because the accounting cancellation of a payment does not always take into account the matching information if:
- The open items of the canceled payment are matched with other entries that are not present in the canceled payment
- These entries contain a credit memo that is allocated and matched to an invoice in the group even though it was closed (parameter LETAUTCNO- Auto match inv ->credit note, (CPT chapter, MTC group) is set to Yes).
Case of an inactive BP client or supplier
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.
Open item selection by payment currency picking
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.
Cases not managed in standard
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.
Open items in the selection panel
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:
- If the entry transaction includes a legislation, this legislation is considered. The open items displayed apply to the entry types of this legislation where the Manage open items check box is selected.
- If the entry transaction does not include a legislation, the system searches for the LEGFIL - Legislation (selection filter) parameter (SUP chapter, INT group).
- If the LEGFIL parameter includes a value, the legislation of this parameter is taken into account.
- If the LEGFIL parameter is blank, the system searches for the default folder legislation and the first legislation found is considered as a last resort.
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.
Manual matching
If you allocate open items by manual matching, the payment remains allocated and the payment is still displayed on the print-out.
Prepayment open items linked to a sales order
When creating a prepayment open item linked to a sales order where the Exempted tax field is set to Yes, the following apply:
- There no VAT calculation in the sales document, although a tax rate is set in the tax code grid in the Tax rates function (GESTVT).
- When such a prepayment is paid and posted, the VAT is calculated according to the tax rate in the tax code grid.