NAVAX NCP Payments User Manual

14.7.2020 Manual - NCP Payments by NAVAX
NCP Payments by NAVAX
Manual
2020.07.14
https://www.navax.app/manual.php?AppID=NCP&L=en 1/65
14.7.2020 Manual - NCP Payments by NAVAX
Table of Contents
Setup
NCP Payment Export Setup Wizard NCPE Payments Export Setup Bank Account Setup Bank Codes XML Schemas XML Schema Values Countries/Regions Language Setup SEPA Mandates Text Lines Customer Bank Account List Vendor Bank Account List SEPA-Direct Debit-Mandates
Export Tasks
Working with Payments Export Payment Journals Make Payment Suggestions One-Time Transfer Create Payment File Payment File Summary Payment Notification E-Mail Suggestion
Reports and Analysis
Payment Statistics
Archive
Customer Ledger Entries Vendor Ledger Entries Employee Ledger Entries Bank Account Ledger Entries Clearing Entries Payment Entries Payment Remittance Entries Payment Posting Entries
https://www.navax.app/manual.php?AppID=NCP&L=en 2/65
14.7.2020 Manual - NCP Payments by NAVAX
Appendix
Payments Export - Delete Data Release Notes Version History
https://www.navax.app/manual.php?AppID=NCP&L=en 3/65
14.7.2020 Manual - NCP Payments by NAVAX
General
NCP Payments is integrated in the financial management of Business Central. The extension NCP Payments consists of 2 modules, which are available separately, and adds the following
functions to Business Central:
Export
NCPE Payments Export (NCPE Payments Export by NAVAX) extends Dynamics 365 Business Central with the capability to create payment files for submitting to your bank. NCP Payments Export works with payment suggestions (and direct debit suggestions) based on open entries of vendors and customers to create a payment file. This file can then be transferred to your bank via the banking software. The following formats are supported:
Non-SEPA-Credit Transfer SEPA-Credit Transfer SEPA-Direct Debit
Import
NCPI Payments Import (NCPI Payments Import by NAVAX) extends Dynamics 365 Business Central with the functionality of importing the payment files that you can download from your bank to use in Business Central in a payment book sheet. The following formats are supported:
camt.052 - includes the balance report and the intraday sales. This includes debits and credits to the corresponding accounts. The camt.052 message also contains details of the individual transactions on the accounts. camt.053 - provides information about posted transactions on the relevant accounts. It contains the posted transactions, details of the corresponding postings, and the balance notifications for the accounts.
camt.054 - informs about upcoming and posted transactions and their details. To be able to use the extension NCPE Payments Export, some settings must be done. The module comes with a Assisted Setup that helps to configure the necessary parameters for use. To do this, go to Setup and Extensions > Assisted Setup from the role center and select the entry NCPE Payments Export Setup. The step-by-step wizard guides you through the setup.
Navigation
The NCPE Payments Export or NCPI Payments Import is integrated in the roles of Accountant and Accounting Manager.
Note
SEPA-Direct Debit is only possible for customers.
https://www.navax.app/manual.php?AppID=NCP&L=en 4/65
14.7.2020 Manual - NCP Payments by NAVAX
Actions, pages and reports that originate from the extension NCPE Payments Export (NCPE Payments Export by NAVAX) will be "Tell me what you want" recognized. Use the search term "Payments Export" or the alternative search terms "ncpe", "sepa" and/or "navax".
Actions, pages and reports that originate from the extension NCPI Zahlungsverkehr Import (NCPI Payments Import by NAVAX) will be "Tell me what you want" recognized. Use the search term "Payments Export" or the alternative search terms "ncpe" and/or "navax".
https://www.navax.app/manual.php?AppID=NCP&L=en 5/65
14.7.2020 Manual - NCP Payments by NAVAX
Setup,
Payments Export Setup Wizard
Before the NCP Payments Export (NCPE Payments Export by NAVAX) can be used, its basic functionality must be set up. This wizard will help you to setup the necessary parameters by walking through them step by step, so you can immediately start working with the NCP Payments Export.
In the following section the steps with the parameters are explained.
Fields, Page Originator Setup
In the section Originator Setup the settings for the export file are defined that specify the originator. If the payment file is exported then this is the data that is that makes your company identifiable as the ordering party. When you start the wizard for the first time, the values from the company information are used for this step.
Name Specifies the originator name.
Name 2 Specifies an addition to the originator name.
Address Specifies the address of the originator.
Address 2 Specifies an addition to the address of the originator.
Post Code Specifies the post code of the originator.
City Specifies the city of the originator.
Country/Region Code Specifies the country/region code of the originator used in payment
transactions.
CreditorIdentifier(CI) The SEPA Direct Debit Scheme (SDD), requires the mandatory provision of a
Creditor Identifier, Creditor ID or CID with each direct debit. This ID is stored in this field.
With next you get to the next setup page of the wizard.
Note
You can skip individual steps at any time and complete the configuration at a later time in the NCP Payments Export Setup.
https://www.navax.app/manual.php?AppID=NCP&L=en 6/65
14.7.2020 Manual - NCP Payments by NAVAX
Page, XML Schemas Setup
XML Schemas are required for the generation of SEPA and non-SEPA files. With this wizard you
can import predefined schemas. In order to be able to use them for the export of the payment file for your bank, you must assign the XML Scheme to a bank. The association of the schemas to the individual bank accounts is done in the Bank Account Setup which you will find later within the wizard. With the action
Download XML Schemas the download and import into the database is started.
Page, SEPA Countries Setup
With this wizard page you can set up the SEPA countries in the countries/regions table. The field "SEPA" is set, which is used to identify the participating SEPA countries based on a list of all participating countries. With the action Setup SEPA Countries the setup is started.
Page, Bank Codes Setup
With this wizard, you can import bank codes from 3 different sources. You have the choice to download the data from the specific banking institutions or from all of them together. The sources of the data are the European Central Bank, the Austrian National Bank or the Deutsche Bundesbank. This download creates records in the table Bank Codes.
Page, Bank Account Setup
In this step the Bank Account Setup can be completed. If you click on the action Open Bank Account Setup, the page will open where you can enter your bank details and link the XML Schemas that you want to use.
For more information, see Setup, Bank Account Setup.
Note
The XML Schemas can change or be supplemented in the future. We provide the latest rulebooks online, these updates and changes can be downloaded in the NCP Payments Export Setup using the action XML Schemas. In the opened page click the action Download in the XML Schemas setup. For more information, see Setup, XML Schemas.
https://www.navax.app/manual.php?AppID=NCP&L=en 7/65
14.7.2020 Manual - NCP Payments by NAVAX
Fields, Payment File Setup
Define here the necessary settings for the creation of the Payment File.
CreateBal.AccountLine Here you can configure whether an balanced 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 creation.
Payment Notification Nos.
Here the payment notification number series is set up.
The action Payment File Setup creates default entries that are not assigned to a specific account. A line is created in the table Payment File Setup for each Payment Type. For more information, see Setup, Payment File Setup.
Fields, Payment Notification E-Mail Setup
Use this wizard to configure the necessary parameters for sending the notification e-mails.
SenderName Here the sender name of the payment notification e-mails is specified. This is also
the name the recipient of the e-mail can see in his e-mail program.
Sender E-Mail The sender e-mail of the payment notification e-mails is specified here.
CC E-Mail Here the CC e-mail of the payment notification e-mails is specified.
BCC E-Mail Here the BCC e-mail of the payment notification e-mails is specified.
HTMLFormatted This value specifies that the payment notification e-mails should be sent in HTML
format.
With the action Send Test Message an E-Mail can be sent to check the settings.
Page, Language Setup
All the necessary settings for the individual language codes, as well as notification texts and the SEPA mandate texts will be set up on this page. Values can be suggested for the language setup
Note
Before you can send a test message or use the notification e-mail functionality, you must first complete the SMTP Mail Setup. You can find information about this in the Business Central Online Help under Set Up E-Mail
https://www.navax.app/manual.php?AppID=NCP&L=en 8/65
14.7.2020 Manual - NCP Payments by NAVAX
via the action Initialize Languages. In most cases, no language code is stored for vendors and customers. You should therefore also set up a record without a language code.
Finish Setup
If you click on Finish the configuration will be written into the table NCP Payments Export Setup.
https://www.navax.app/manual.php?AppID=NCP&L=en 9/65
14.7.2020 Manual - NCP Payments by NAVAX
Setup,
Payments Export Setup
Before the NCPE Payments Export (NCPE Payments Export by NAVAX) 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 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 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 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.
Important
The trial version expires in 30 days. After that, the functions of NCPE Payments Export (NCPE Payments Export by NAVAX) can only be used with a valid license. Please note that the licensing process may take some time. The license can be applied for or verified using the action What's New?. A browser window is opened. Then click on Send License Request to send an e-mail with your request. In the following days you will receive an e-mail with further information. As soon as the licensing is completed (or if a license already exists), the license can be updated using the action Update License. For more information, see Update License..
https://www.navax.app/manual.php?AppID=NCP&L=en 10/65
14.7.2020 Manual - NCP Payments by NAVAX
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
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Line Here 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 Type Specifies the payment method for which the settings apply. The settings
must be defined for all payment types that are in use.
https://www.navax.app/manual.php?AppID=NCP&L=en 11/65
14.7.2020 Manual - NCP Payments by NAVAX
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
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:
https://www.navax.app/manual.php?AppID=NCP&L=en 12/65
14.7.2020 Manual - NCP Payments by NAVAX
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, Pmnt. Notification E-Mail
In the section Pmnt. 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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.
SenderE-Mail Here the sender e-mail of the payment notification e-mail message is specified.
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 Tasks, Payment Notification E-Mail Suggestion.
ed ate y a te t e p ace o de . a p e % o [ ote:
%10<15>].
https://www.navax.app/manual.php?AppID=NCP&L=en 13/65
14.7.2020 Manual - NCP Payments by NAVAX
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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, Bank Codes.
https://www.navax.app/manual.php?AppID=NCP&L=en 14/65
14.7.2020 Manual - NCP Payments by NAVAX
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.
https://www.navax.app/manual.php?AppID=NCP&L=en 15/65
14.7.2020 Manual - NCP Payments by NAVAX
System, Fields
Version Specifies the currently installed version of the Extension.
Serial No. Specifies the serial number of the Extension.
License Status
Displays the license status of the Extension.
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.
https://www.navax.app/manual.php?AppID=NCP&L=en 16/65
14.7.2020 Manual - NCP Payments by NAVAX
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.
For more information, see Appendix, Payments Export - Daten löschen.
Note
The licence must be updated once a year.
In the NCPE Payments Export Setup, the expiry date of the license and the remaining
days are viewed under System.
Within the last 30 days before the license expires, messages will be viewed.
Note
The files can no longer be exported.
https://www.navax.app/manual.php?AppID=NCP&L=en 17/65
14.7.2020 Manual - NCP Payments by NAVAX
Setup,
Zahlungsverkehr Import Einrichtung
Bevor der NCPI Zahlungsverkehr Import (NCPI Payments Import by NAVAX) verwendet werden kann, muss dessen grundlegende Funktionalität eingerichtet werden. Im Fenster NCPI Zahlungsverkehr Import Einrichtung werden die allgemeinen Einstellungen und Vorgaben festgelegt.
TODO
Important
Die Testversion läuft in 30 Tagen ab. Danach können die Funktionen von NCPI Zahlungsverkehr Import (NCPI Payments Import by NAVAX) nur mehr mit einer gültigen Lizenz genutzt werden. Beachten Sie, dass der Lizenzierungsprozess einige Zeit dauern kann. Die Lizenz kann über die Aktion What's New? beantragt bzw. überprüft werden. Dabei wird ein Browserfenster geöffnet. Klicken Sie anschließend auf Lizenzanfrage senden um eine E-Mail mit Ihrer Anfrage zu senden. In den nächsten Tagen erhalten Sie eine E-Mail mit weiteren Informationen. Sobald die Lizenzierung abgeschlossen ist (oder wenn bereits eine Lizenz vorhanden ist, kann die Lizenz über die Aktion Lizenz aktualisieren aktualisiert werden. Weitere Informationen dazu finden Sie unter Lizenz aktualisieren.
https://www.navax.app/manual.php?AppID=NCP&L=en 18/65
14.7.2020 Manual - NCP Payments by NAVAX
Setup,
Bank Account Setup
In the window NCP Payments Bank Account Setup, all bank accounts that are required for payment transactions are entered or managed here.
https://www.navax.app/manual.php?AppID=NCP&L=en 19/65
14.7.2020 Manual - NCP Payments by NAVAX
Fields
Bank Account No. Specifies the bank account number.
Bank Account Name Shows the bank account number.
Bank Account Country-/Regioncode
View the country-/region code of the bank account.
Bank Account IBAN Shows the IBAN of the bank account.
SEPA Credit Transfer Schema
Specifies which payments XML schema should be used for the SEPA credit transfer. For more information, see Setup, XML Schemas.
SEPA Direct Debit Schema
Specifies the payment transaction XML Schema to be used for SEPA Direct Debit. For more information, see Setup, XML Schemas.
Non-SEPA Credit Transfer Schema
Specifies the payment transaction XML schema to be used for the non-SEPA transfer. For more information, see Setup, XML Schemas.
Originator ID Specifies the originator ID for the payment transaction XML schemas if
required.
Originator ID Issuer Specifies the issuer of the originator ID for the payment transaction XML
schemas if required.
Charge Account No. Specifies the expense account for the direct transfer of expenses to a ledger
sheet, or the indirect transfer to a ledger sheet via bank account reconciliation.
Note
The field country/region code must be specified with the current bank account so that the account can be used for payment transactions.
Note
Only fill the originator ID if it is permitted or required in the XML file after consultation your bank.
Note
Only specify the issuer of the originator ID if specification in the XML file is permitted or required after consultation your bank.
https://www.navax.app/manual.php?AppID=NCP&L=en 20/65
Loading...
+ 45 hidden pages