| Docs Help
  AppSource  
Docs  /  NCP Payments  /  Setup  /  Export

Payments Export Setup


2024/06/21 • 9 min. to read
Before the NCPE Payments Export (NCPE Payments Export) extension can be used, it must be set up. In the window NCPE Payments Export Setup, the general settings and defaults are defined.

Fields, General

LCY Code Shows the currency code for the local currency. This value has been stored in the General Ledger Setup.
ISO LCY Code Specifies the ISO LCY Code, this will be pre-filled with EUR when LCY Code is set to EUR or EURO in the General Ledger Setup and the field has not yet been configured.

Fields, Suggest Payments

In the section Suggest Payments the settings for the creation of the Payment Suggestions are defined.
Due Date Calculation Specifies a date formula with which the Last Due Date field in the Payment Suggestion should be suggested. The date is calculated based on the work date.
Discount Date Calculation Specifies a date formula with which the field Last Discount Date in the Payment Suggestion should be suggested. The date is calculated based on the work date.
Posting Date Calculation Specifies a date formula with which the field Posting Date in the Payment Suggestion should be suggested. The date is calculated based on the work date.
Execution Date Calculation The execution date is calculated as follows: For urgent payments, the date is set to today. Otherwise the date is set to the next day, unless it is a SEPA direct debit in combination with direct debit type CORE - basic direct debit, in this case the date is set to Today + 2 days.
External Bank Account Search Specifies how the field External Bank Account Search (vendor/customer bank account) is determined in the general ledger lines for the Payment Suggestion. The following applies to all options: If the vendor/customer item contains a value in the field 'External Bank Account Search', this value is suggested.
Incl. Customers with Credit Specifies that customers with credit should be included in the payment suggestion.
Incl. Vendors with Credit Specifies that vendors with credit should be included in the payment suggestion.

Fields, Originator

In the section Originator Setup the settings for the export file are defined. When the payment file is exported, this data is exported to make you or your company identifiable as the ordering party. When you start the wizard for the first time, the values from the company data are used as default values for this step.
Name Specifies the originator name.
Name 2 Specifies the originator name 2.
Address Specifies the originator address.
Address 2 Specifies the originator address 2.
Post Code Specifies the originator post code.
City Specifies the originator city.
Country/Region Code Specifies the country code of the ordering party used in payment transactions.
Creditor Identifier (CI) The SEPA Direct Debit Scheme (SDD), requires the mandatory specification of a Creditor Identifier, Creditor ID or CID with each direct debit. This ID is stored in this field.

Fields, Create Payment File

Create Bal. Account Line Specifies whether an offsetting entry line is to be created for the balanced account lines when the payment file is created. An offsetting entry line will only be created if there is more than one journal line for an offsetting entry line. For different document types, the offsetting entry line will only be created if all journal lines involved have a Applies-to Doc. No. set. If this is the case, the Document Type will be set to Payment for all affected journal lines. These changes will be saved. If the transaction is cancelled, the Document Type will be reset to the original value.
Modify allowed after File Created With this option you can determine whether the payment data can still be manipulated after file creation.
Summary after creation Specifies whether or not to display the summary after file creation.
Payment Notification Nos. Here the payment notification number series is set up.
Pmt. Notification Report ID Specifies the ID of the report that is printed when you print the payment notification.

Tip

Here you can enter your own report layout if the standard report does not meet your requirements. By default, the report with the ID 70322078 - NCPE Pmt. Notification is entered here.
Pmt. Notification Report Caption Specifies the name of the report that is printed when you print the payment notification.
Payment Type Specifies the payment method for which the settings apply. The settings must be defined for all payment types that are in use. The following options are available:
  • Non-SEPA Credit Transfer
  • SEPA Credit Transfer
  • SEPA Direct Debit
Bank Account No. Specifies the bank account to which the settings apply. The setting is optional. If no bank account is specified, the settings are valid for all bank accounts for which no special settings exist.
File Name Specifies the name to be used to save the payment file. The following placeholders can be used in the File Name field:
  • %1,%2,%3,%4,%5 Date of creation (day,week,month,year,year 4 digits)
  • %6 Bank Account No.
  • %7 File Reference (Message Reference)
  • %8 Clearing Entry No.
  • %9 User-ID
  • %10 Payment Type
Remittance Info. Length Shows the maximum number of characters for the payment remittance information.
Remittance Info. Specifies the structure and values for the remittance information in the payment file. The following Wildcards can be used in this field.
  • %1 Document Type
  • %2 External Document No. (if available) or Document No.
  • %3 External Document No.
  • %4 Document No.
  • %5 Currency
  • %6 Amount
  • %7 Discount
  • %8 Vendor-/Customer-/Employee-Number
  • %9 Our Bank Account No.
  • %10 Gen. Journal Line Description
  • %11 Document Date
  • %12 Payment Text (from Journal Line)

    Note

    The Payment Text field is hidden in Payment and Cash Receipt Journals to use it, add the field to the page using the Personalize function.

Tip

  • Use brackets, for example [Discount:% 7], if you want to output the text only if the placeholder has a value.
  • You can determine the maximum number of characters for the placeholder by specifying a numerical value within angle brackets immediately after the placeholder. Example %1<2> or [Note: %10<15>].
Collective Transaction Specifies whether transactions with the same vendor/customer/bank account number, external bank account code, and currency code should be combined when the payment file is created. They are then sent to the bank as collective transactions.
Always Create Notification Specifies whether a payment notice should always be generated when the payment file is created, regardless of if the payment remittance information can be transmitted in completely form or not.

Fields, Pmt. Notification E-Mail

Edit before sending If this option is enabled, the notification e-mails can be edited with the e-mail editor before sending.

Note

This option is only available if the Email features active option is enabled.
HTML Formatted This value specifies that the payment notification e-mail message should be sent in HTML format.
Sender Name Here the sender name of the payment notification e-mail message is specified. This is the name the recipient of the e-mail can see in his e-mail program. This option is only available if the Email features active option is disabled.
CC E-Mail Here the CC e-mail of the payment notification e-mail message is specified.
BCC E-Mail Here the BCC e-mail of the payment notification e-mail message is specified.
For more information, see Set Up Email For more information, see Tasks, Export, Payment Notification E-Mail Suggestion.

Fields, Bank Codes Resources

EZB Bank Codes URL Specifies the URL for the download of the bankcodes from European Central Bank
OENB Bank Codes URL Specifies the URL for the download of the bankcodes from European Central Bank.
DBB Bank Codes URL Specifies the URL for the download of the bankcodes from German National Bank.
For more information, see Setup, General, Bank Codes.

System, Fields

Delete Data Date Calculation This allows you to specify the period for deleting the data via Payments Export - Delete Data. Only data that is at least 6 months old can be deleted. If the field is empty, the minimum period is used.
Last Date Archived Files deleted Shows the date on which Payments Export - Delete Data were last executed.
Archived Files deleted until Specifies the date until which archived files were deleted from the clearing entries.

Setup, Actions

  • Bank Accounts

    In the window NCP Payments Bank Account Setup, all bank accounts required for payment transactions are defined or managed. For more information, see Setup, Bank Account Setup.
  • Bank Codes

    In this window, the Branch Codes and the SWIFT Codes of the banks are defined or managed. For more information, see Setup, Bank Codes.
  • XML Schemas

    XML schemas are required for SEPA and non-SEPA files creation. The assignment of the schemes to the individual bank accounts can be done in the NCPE Bank Account Setup page. For more information, see Setup, Export, XML Schemas.
  • Currencies

    Using this action the currencies can be set up.
  • Countries/Regions

    Using this action, countries/regions can be set up. For more information, see Setup, General, Countries/Regions.
  • Languages

    Payment Notification Texts und SEPA Mandate Texts are displayed and managed in the Language Setup window for each language code. For more information, see Setup, Export, Language Setup.
  • Update Bank Code URLs

    Fills or updates the bankcode URL fields. The up-to-date URL's are entered in the corresponding fields, this data is permanently updated on www.navax.app and offered as download.

System, Actions

  • NAVAX License Management

    Opens the NAVAX License Management which displays the current license status of the NAVAX extensions. For more information, see Appendix, NAVAX License Management.
  • Send Pmt. Notification Test Message

    This action, gives you the possibility, to test the settings of the payment notice e-mail functionality. If the function is called, the e-mail address to which the payment notice test message is to be sent must be specified in the field Test message to.
  • Delete Data

    By creating a payment file, an entry is made in the clearing entries. The created payment file is also saved there. If necessary, you can use this action to remove the archived payment files from the clearing items.

    Note

    The files can no longer be exported.
    For more information, see Appendix, Delete Data.

See also




Submit feedback for
DE|EN Imprint
<>