☰ Contents
  Support|  Feedback|  Print|  Share


Payments Export Setup


2021/06/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.
    Email Features activeIndicates that the enhanced email features are active in your Dynamics 365 Business Central.

    Important

    Depending on whether the advanced email features are enabled, some of the fields below may not be available.
    For more information, see Set up Email.
    Edit before sendingIf 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 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. This option is only available if the Email features active option is disabled.
    SenderE-MailHere the sender e-mail of the payment notification e-mail message is specified. This option is only available if the Email features active option is disabled.
    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 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, 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 StatusSpecifies the current license status of the Extension. For more information, see Appendix, NAVAX License Overview.
    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?

      Opens an external website with additional information about the extension and through which the license of the extension can be requested or checked. For more information, see Appendix, NAVAX License Overview.
    • Update License

      Updates the License of the Extension or checks if it is up to date. For more information, see Appendix, NAVAX License Overview.
    • Version History

      Views when which version of the Extension was installed. For more information, see Appendix, Version History.
    • 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|  Share
    DE|EN Imprint
    <>