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

SEEREFERTTO 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.

SEEINFO   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.

Tab Criteria

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.

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.

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.

SEEINFO 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.

Memo

Click this action to save the current settings to a Memo code to be reused later. The memo is linked to your user profile, not to the function or the screen.

The STD memo code is associated with the screen and is loaded immediately when you open the function.

For more information on the advanced use of the Memo action, refer to the documentation on the General ergonomics of SAFE X3 software.

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.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation