Contents
  Support|  Feedback|  Print Page


Payments Export Setup


2020/11/30
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, Suggest Payments

In the section Suggest Payments the settings for the creation of the Payment Suggestions are defined.
Due Date CalculationSpecifies 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 CalculationSpecifies 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 CalculationSpecifies a date formular with which the field Posting Date in the Payment Suggestion should be suggested. The date is calculated based on the work date.
External Bank Account SearchSpecifies 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.

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.
NameSpecifies the originator name.
Name 2Specifies the originator name 2.
AddressSpecifies the originator address.
Address 2Specifies the originator address 2.
Post CodeSpecifies the originator post code.
CitySpecifies the originator city.
Country/Region CodeSpecifies 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

In the section Create Payment File and Payment File the settings for the different payment files are defined. You can set up one bank account per payment type that uses this setting. If the field Bank account number leaved blank, then this setting applies globally for all bank accounts.
Create Bal. Account LineHere you can select if a balancing account line should be created.
Modify allowed after "File Created"With this option you can determine whether the payment data can still be manipulated after file creation.
Payment Notification Nos.Here the payment notification number series is set up.
Payment TypeSpecifies 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 NameSpecifies 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. LengthShows 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

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 TransactionSpecifies 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 NotificationSpecifies 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

    In the section Pmt. Notification E-Mail, the settings for the notification e-mail sending are configured. If you have created a Payment File you can view a list of possible payment notification e-mails on the page NCP Payment File - Summary with the action Payment Notification E-Mail Suggestion. The parameters you set up in this section will be used as the default value for sending.
    HTML FormattedThis value specifies that the payment notification e-mail message should be sent in HTML format.
    Sender NameHere 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.
    SenderE-MailHere the sender e-mail of the payment notification e-mail message is specified.
    CC E-MailHere the CC e-mail of the payment notification e-mail message is specified.
    BCC E-MailHere the BCC e-mail of the payment notification e-mail message is specified.
    For more information, see Tasks, Payment Notification E-Mail Suggestion.

    Fields, Bank Codes Resources

    In the section Bank Codes Resources the sources for the Download of the bank codes are defined. You can start the Download through assisted setup or on the Bankcodes page.
    EZB Bank Codes URLSpecifies the URL for the download of the bankcodes from European Central Bank
    OENB Bank Codes URLSpecifies the URL for the download of the bankcodes from European Central Bank.
    DBB Bank Codes URLSpecifies the URL for the download of the bankcodes from German National Bank.
    For more information, see Setup, Bank Codes.

    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 Bank 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 the creation of SEPA and non-SEPA files. The assignment of the schemes to the individual bank accounts can be done in the Payments Bank Account Setup. For more information, see Setup, 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, 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, Languages.

    System, Fields

    License StatusDisplays the license status of the Extension.

    Important

    The trial version of an extension expires in 30 days. After that the functions of the extension can only be used with a valid license. Please note that the licensing process may take some time. The license can be requested or checked via the action What's New?. This opens a browser window. Click on Send License Request to send an E-Mail with your request. In the next few days you will receive an E-Mail with further information. As soon as the licensing has been completed, the license can be activated via the Update License action.

    Note

    The licence must be updated once a year via the Update License action. The update is only possible or necessary within the last 30 days before the license expires, or afterwards. Within the last 30 days before the license expires, notes are displayed.
    Serial No.Specifies the serial number of the Extension.
    VersionSpecifies the currently installed version of the Extension.
    Delete Data Date CalculationThis 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 deletedShows the date on which Payments Export - Delete Data were last executed.
    Archived Files deleted untilSpecifies the date until which archived files were deleted from the clearing entries.

    System, Actions

    • What's New?

      Via What's New? you have access to additional information, documents and resources of the Extension.
    • Update License

      Updates the License of the Extension or checks if it is up to date.
    • Version History

      Views the history, where you can see, which version of the Extension was installed.
    • 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, Payments Export - Delete Data.
    Contents
    Next Topic: XML Schemas
      Support|  Feedback|  Print Page
    DE|EN Imprint