Create payment files for your bank and import files from your bank.
Current Versions: Exports 21.2.2.3as of Business Central 21, konfipay Export 22.2.2.1as of Business Central 22, Imports 21.2.1.0as of Business Central 21 and konfipay Import 22.1.1.0as of Business Central 22. AppSource Names: NAVAX Payment Exports, NAVAX Payment Imports, NAVAX konfipay Connector Export, NAVAX konfipay Connector Import
Manual
Creation date: 2024/11/22 The current version of this manual can be found at:
☰ Contents
General
NAVAX Payment Welcome to the help page of NAVAX Payment. This page provides you with comprehensive information and support for our payment solutions, including NAVAX Payment Exports and NAVAX Payment Imports. Our goal is to enable you to seamlessly and efficiently manage your payment transactions. The modules NAVAX Payment Exports and NAVAX Payment Imports, as well as their NAVAX konfipay Connector extension, are available separately...
Setup
General
Bank Account Setup In the NCP Bank Account Setup window, all bank accounts required for payment processing with NAVAX Payment are stored and managed. Here, you can add new bank accounts, edit or remove existing accounts, and update important account details. The overview provides a clear and structured representation of all relevant bank information to make payment processing efficient and transparent...
Bank Codes In the page NCP Bank Codes you can manage the bank codes. You have the possibility to import bank codes easily and comfortably from 3 banking institutions...
Vendor/Customer Bank Account In the Creditor/Debtor Bank Account Overview, you can assign your creditor and debtor bank accounts. You can access the overview by clicking on Navigate > Creditor/Debtor > Bank Accounts on the Creditor or Debtor list or the corresponding card...
Countries/Regions In this overview you can setup and manage settings for countries and regions to use them for payment transactions...
Pay with QR-Code With the NCP Pay with QR Code function you can create a QR code that can then be placed on your invoices - whether digital or paper. The customer thus saves the tedious typing of data and also does not run the risk of entering incorrect data. This also makes it easier to apply payments later that were imported into Business Central via bank account statement...
Exports
Exports Setup Wizard Before the NAVAX Payment Exports 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 NAVAX Payment Exports...
Exports Setup Before the NAVAX Payment Exports extension can be used, it must be set up...
XML Schemas The EU and the EPC (European Payments Council) are intent on using the XML format as a standard in European payment transactions. At the moment, efforts are being made to minimize the numerous different national variants of payment transaction solutions and ultimately to eliminate them completely. The XML format should replace all other formats in order to standardize the processing of transactions on a technical level Europe-wide. This format is to be introduced and accepted as a standard both in the interbank sector and by customers...
Language Setup All necessary settings for the individual language codes are set up here. Also the Payment Notification Texts and the SEPA Mandates Texts can be stored or set up here...
SEPA-Direct Debit-Mandates With the authorization of your customer, you can collect payments directly from the customer's bank account...
Imports
Imports Setup Wizard Before NAVAX Payment Imports can be used, its basic functionality must be set up. In the window NCP Imports Setup the general settings and defaults are defined...
Imports Setup Before NAVAX Payment Imports can be used, its basic functionality must be set up. In the window NCP Imports Setup the general settings and defaults are defined...
NAVAX Dropzone Setup In the NAVAX Dropzone Setup page the settings and defaults for the different Dropzones are defined...
Customs Formats You can define a special format for the payment file if the existing standard formats do not meet the requirements of your bank...
Imports Codes The NCP Import Codes are references to various types of transactions. Different code fields are filled depending on the imported file format...
Fixed Account Allocations If a bank account is determined when importing a payment file (Import Payment File), the system first checks whether fixed account allocations exist. If there are any, this bank account is used...
konfipay Connector
konfipay Connector Setup Here, the general settings and default settings for the konfipay Connector are defined. konfipay offers a REST-compliant web service as a communication interface, which can be integrated by Microsoft Dynamics Business Central to automate business processes...
konfipay Connector Access Data konfipay Connector operates exclusively in conjunction with a validated Finmatics account...
Tasks
Exports
Working with Payment Exports When you make payments to vendors or customers or gather open entries, you post the respective payment entries in a payment or cash receipt journal. These journals have been optimized for applying and executing payments. They contain several powerful features, such as the Payment Suggestion function, which helps you to find outstanding payments and insert them into a payment or cash receipt journal. NAVAX Payment Exports extends this functionality to enable you to process your payment transactions quickly, easily and in a customer-friendly manner, in compliance with national and international standards. You can export data to a Payment File from a payment or cash receipt journal...
Make Payment Suggestions You start the Payment Suggestion in a Payment Journal (Payment Journals and Cash Receipt Journals)...
Create Payment File
Payment/Cash Receipt Journals Export The documentation on this page applies to the payments and cash receipt journals...
One-Time Transfer You can use a one-time statement to execute a bank transfer ad hoc without having to manage vendors/customers and external bank accounts. In the Journals you can define per line if it is a One-Time Transfer. To open the page One-Time Transfer click on the field One-Time Transfer (if no one-time payment has been defined yet, the value of the field is No), the page opens and you can set up the bank account for this transfer...
Payment File Summary After the action Create Payment File in the Journal has been successfully completed and a Payment File is created, the page Payment File Summary opens. Here, you can see, information about the created payment file, you can see at a glance which settings used and the amount for which the file was created. In addition, you can also see how many payment notifications have been created and whether the payment notifications have all been printed or sent...
Payment Notification E-Mail Suggestion With a payment notification, you can document which open entries you want to pay or collect in the payment file after you have created the payment file. A payment notification is useful (especially for collective transfers) to make it easier for the recipient to identify the payments...
Imports
Working with Payment Imports
Import Payment File
Applying Open Entries
Bank Account Reconciliation You must regularly reconcile your bank, receivables, and payables accounts by applying payments recorded in the bank to their related open (unpaid) invoices and credit memos or other open entries in Business Central...
Payment/Cash Receipt Journals Import The description on this help page applies to the Cash Receipt- and the Payment Journal and explains the extensions that NAVAX Payment Imports provides...
Pay With QR Code
Create invoices for paying by QR code The NAVAX Payment has been extended with the functionality Pay with QR Code, NCP Pay with QR Code generates a standardized QR code, also called EPC QR Code, which can be scanned by many banking apps, enabling it to automatically fill in payment details such as recipient, amount, IBAN, BIC and the remittance info. This QR code created by NCP Pay with QR Code can then be placed on your invoices. This saves the customer the tedious task of typing in the data, and also means that they do not run the risk of entering incorrect data...
Reports and Analysis
Payment Statistics This page views a line for each Payment File that was created from the journal...
Importlist
Imports Allocation Analysis If the indicator Show Analysis Window is set in the NCP Imports Setup, the system does not carry out a comparison of the Remittance Info when you execute the function Apply Entries in the journal. Instead, this window shows how the application is performed...
Import General Journal Deviation
Archive
Vendor/Customer and Bank Ledger Entries
Clearing Entries In the window NCP Clearing Entries the history of all created payment files are listed...
Payment Entries The action Create Payment File in the Payment Journals creates a NCP Clearing Entry with status Created, which contains information about the payment file...
Payment Status Entries After a payment file is created, it can be directly transmitted to the bank using the konfipay Connector Export extension. During this process, a payment status entry is created to reflect the status from konfipay in Business Central...
Imports On this page you can see the overview of the imported bank files. For each of the imported files a Import line is created, these in turn can have several transaction lines and remittance info lines...
Account Transaction Entries An account transaction file is a file that contains all the transactions of a bank account, including the resulting balance. A special variant is the electronic account statement, where the account statement data, for example in online banking, is provided in file format...
konfipay Connector Service Log Entries In modern web development, web services play a central role by enabling communication and data exchange between different applications and systems. These interactions leave behind extensive log entries that provide valuable information for monitoring, troubleshooting, and optimizing the services. Therefore, a structured and well-documented table for web service log entries is essential to ensure the integrity and efficiency of the web services...
Appendix
Data Structure
Delete Data
QR-Code Document Data Payments with QR Code generates a standardized QR Code, also called Girocode or EPC QR Code, this QR Code created by NCP Pay with Code can then be placed on your invoices...
konfipay Bank Account List On the konfipay Bank Account List page, all bank accounts available for synchronization in konfipay are displayed. This page opens when you click the Import Bank Accounts button on the Bank Account Setup page...
NAVAX License Management The NAVAX License Management page (in older versions NAVAX License Overview or NCEX License Overview) displays the current license status of the NAVAX extensions...
Information for Developers Auf der folgenden Seite sind Events aufgelistet die Ihnen dabei helfen sollen, Integrationen in NCPE Zahlungsverkehr Export und NCPI Zahlungsverker Import einzubinden...
Installation Notes
Possible Error messages konfipay Error messages occasionally occur due to a faulty file structure or more often due to missing bank authorizations. More rarely, connection interruptions or general transmission errors to the bank server are the cause. konfipay contains a sophisticated warning and notification system for this purpose...
Release Notes
Release Notes Payment Exports
Release Notes Payment Imports
Release Notes konfipay Connector Export
Release Notes konfipay Connector Import
Docs / NAVAX Payment / General NAVAX Payment
Welcome to the help page of NAVAX Payment. This page provides you with comprehensive information and support for our payment solutions, including NAVAX Payment Exports and NAVAX Payment Imports. Our goal is to enable you to seamlessly and efficiently manage your payment transactions. The modules NAVAX Payment Exports and NAVAX Payment Imports, as well as their NAVAX konfipay Connector extension, are available separately.
Export of payment files
The NAVAX Payment Exports extends Dynamics 365 Business Central with the functionality to efficiently and securely process your outgoing payments.
With this solution, you can:
Create and export payment files:
Create payment files in the required formats and export them. Additionally, the file can be transmitted directly to your bank via the NAVAX konfipay Connector.
Supported Formats:
Non-SEPA Credit Transfer
SEPA Credit Transfer
SEPA Direct Debit
Simplified payment processing:
Use simplified processes to minimize manual interventions and increase accuracy.
Compliance with standards:
Ensure that all payments comply with applicable legal and regulatory requirements.
Note
SEPA Direct Debit is only possible for customers.
Import of account transactions
The NAVAX Payment Imports extends Dynamics 365 Business Central with the functionality to efficiently manage incoming payments.
This solution allows you to:
Import and process incoming payments:
Import incoming payments and process them directly in your system.
Supported Formats for NAVAX Payment Imports:
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
- includes 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
- provides information about upcoming and posted transactions and their details.
MT940
- includes posted transactions on the relevant accounts.
File (MT=Message Type) corresponds to a bank statement in electronic form. It contains all relevant information on bank transactions made in the SWIFT standard for the electronic transfer of account statement data.
Automatic reconciliation with open entries:
Automate the reconciliation of incoming payments with open invoices to simplify accounting and reduce errors.
Efficient management of incoming payments:
Keep track of your incoming payments and efficiently manage them in your system.
NAVAX konfipay Connector
The NAVAX konfipay Connector has been added with the NAVAX Payment update to version 22.2.0.0 and is a powerful extension for Microsoft Business Central that enables seamless integration between Microsoft Business Central and Konfipay. Konfipay is a specialized platform for automated payment transaction processing that offers significant time and cost savings for businesses.
As a service provider, windata GmbH & Co.KG handles the transmission of your payment orders and the retrieval of your account statements.
konfipay offers fully automated online banking, even for large transaction volumes, with the highest level of security.
With the NAVAX konfipay Connector, users can:
Consolidate financial accounting and payment processing in one system
Integrating financial accounting and payment processing into a single system allows for seamless management of all financial processes.
This leads to significant efficiency gains and better control over company finances.
Simplified payment processing:
Payments are transmitted from Microsoft Business Central to konfipay, reducing manual input and errors.
Track and monitor financial transactions in real-time:
Users can track the status of their payments in real-time, providing better control and transparency over financial transactions.
Support multiple payment methods:
The konfipay Connector supports various payment methods, including bank transfers, direct debits, and SEPA transactions.
Security and compliance:
The konfipay Connector ensures that all payments are processed securely and in compliance with current legal regulations.
By integrating konfipay into Microsoft Business Central, businesses can optimize their payment processes, reduce the risk of errors, and save valuable resources.
This extension is ideal for companies that have a high volume of payments and want to manage them efficiently and securely.
For more information, see konfipay - Online Payment Services
On this help page, you will find detailed instructions, frequently asked questions (FAQs), troubleshooting tips, and useful resources about the features and processes of NAVAX Payment. Use the menu or the search function to find specific information.
If you need further assistance, our support team is always available. We are here to help you get the most out of our payment solutions and optimize your financial processes.
Navigation
NAVAX Payment Exports and NAVAX Payment Imports are integrated in the Profiles (Roles) Accountant and Accounting Manager.
Fields, actions, pages and reports originating from the NAVAX Payment Exports extension are identified by the abbreviation NCP Exports.
NCP Exports stands for NAVAX Consulting Payments Exports.
Fields, actions, pages and reports originating from the NAVAX Payment Imports extension are identified by the abbreviation NCP Imports.
NCP Imports stands for NAVAX Consulting Payments Imports.
The search terms "ncp", "sepa", "payments", ("ncpe", "ncpi" for compatibility reasons) and "navax" are recognized by "Tell me what you want to do".
This allows very fast access to the individual sections of the NCVV VAT Registration No. validation.
Permission Sets NAVAX Payment
The following permission sets are available for NAVAX Payment Exports and NAVAX Payment Imports
Docs / NAVAX Payment / Setup / General Bank Account Setup
In the NCP Bank Account Setup window, all bank accounts required for payment processing with NAVAX Payment are stored and managed. Here, you can add new bank accounts, edit or remove existing accounts, and update important account details. The overview provides a clear and structured representation of all relevant bank information to make payment processing efficient and transparent.
If you are using the konfipay Connector, specific settings for bank accounts required for synchronization are also made here. The konfipay Connector enables seamless integration and synchronization of your bank accounts with respective financial systems. This includes the configuration of access data.
For more information, see www.konfipay.de
In addition, the Bank Account Setup window offers various tools and functions to assist you in the daily management of your bank accounts. These include monitoring account balances and transactions, as well as performing error analysis and corrections. All of these functions are designed to make your work easier and increase the efficiency of your financial processes.
Furthermore, in the NCP Bank Account Setup window, you can store SEPA XML schemas. These schemas are necessary for the standardized processing of SEPA transfers and direct debits. By storing the SEPA XML schemas, you ensure that all transactions comply with the current SEPA guidelines and can be executed correctly and on time. This facilitates cross-border payment processing within the SEPA area and ensures higher accuracy and reliability in payment transactions.
Note
The Country/Region Code field must be specified for the bank account to be used in payment processing.
Fields
Bank Account Number
Specifies the bank account number for which the Payment Processing Bank Account Setup was created.
Name
Displays the name of the linked bank account.
IBAN
Displays the IBAN of the linked bank account.
Country/Region Code
Displays the country/region code of the bank account.
Important
The Country/Region Code field must be specified for the bank account to be used in payment processing.
Pay with QR Code
Indicates that this bank account should be used by default for Pay with QR Code. Only one account can be marked!
For more information, see Setup, General, Pay with QR-Code.
Note
If you do not use the Pay with QR Code feature, this field can be left empty.
Synchronize
Indicates that konfipay should act as middleware for communication with your bank. Enabling this option allows you to directly import bank statements into Business Central and send generated payment files (collections and transfers) to the bank from Business Central through the middleware without having to store files.
Test Account
Indicates whether the bank account in konfipay is a Sandbox Bank Account or a Production Bank Account.
Important
Test accounts do not send information to the bank; instead, konfipay simulates the validations. Therefore, do not use test accounts for real transactions!
Agreement Document exists
Indicates that the agreement document has been imported by konfipay.
The agreement document defines the permissions the user receives and how access to the various functions and services of konfipay is regulated. This is particularly important for the security and protection of sensitive financial data.
It establishes the legal framework under which the user can use the services of the bank or payment service provider.
By signing the agreement document, the user commits to complying with certain standards and rules in handling the offered services. This creates binding obligations and ensures smooth payment processes.
agreements documents imported through konfipay are stored in the Attached Documents and can be viewed in the Attachments factbox under Documents.
Note
By default, this field is hidden and can be displayed using the Personalize function.
Account Balance
Displays the account balance according to konfipay.
Acc. Balance Currency Code
Displays the currency code of the account balance according to konfipay.
Account Balance Date
Displays the date of the account balance according to konfipay.
Note
By default, this field is hidden and can be displayed using the Personalize function.
No. of Payment Status Entries
Displays the number of new payment status entries for this bank account. The payment status entries overview can be accessed using the AssistEdit function.
Note
By default, this field is hidden and can be displayed using the Personalize function.
Open Payment Status Entries
Displays the number of payment status entries for this bank account. The payment status entries overview can be accessed using the AssistEdit function.
Note
By default, this field is hidden and can be displayed using the Personalize function.
Pending Payment Status Entries
Displays the number of pending payment status entries without a final status for this bank account. The payment status entries overview can be accessed using the AssistEdit function.
Note
By default, this field is hidden and can be displayed using the Personalize function.
New Account Statement Entries
Displays the number of available account statement files.
Note
By default, this field is hidden and can be displayed using the Personalize function.
Imported Account Statement Entries
Displays the number of already imported account statement files.
Note
By default, this field is hidden and can be displayed using the Personalize function.
Last Import Date
Displays the date of the NCPI Import record for the account statement file.
Note
By default, this field is hidden and can be displayed using the Personalize function.
Home, Actions
Import Bank Accounts
Use the Import Bank Accounts action to import bank accounts from konfipay into Business Central. This function allows you to automatically transfer existing bank accounts from the konfipay system to your Business Central environment. This saves time and reduces errors as the account data does not need to be manually entered. During the import process, all relevant bank information is transferred and stored in Business Central, allowing you to work with synchronized data immediately.
Note
After importing a bank account, you still need to specify the bank account posting group on the bank account card, otherwise, there may be an error when posting.
Download Acc. Transaction Entries
Use this action to initiate the process of retrieving and importing account statement files from konfipay into Business Central. This converts the selected bank account's statement data into a format suitable for Business Central. After the import, the data is available as an XML file, which can then be further processed using the NCPI Payment Import.
Navigate, Actions
Payment Journals
Opens the most recently used cash receipt journal where you can register direct debits to customers.
Payment Output Journals
Opens the most recently used payment journal where you can register transfers to creditors.
NCP Imports
In the Payment Import window, you can import files, transfer data to payment journals or bank account reconciliations, and manage the associated journals and reconciliations. Depending on the setup, different actions and fields will be displayed.
Agreement Document
The action opens the agreement document in konfipay that was signed during the setup of the bank account. If the agreement document has not been imported yet, the download will be performed automatically.
The agreement document defines the permissions the user receives and how access to the various functions and services of konfipay is regulated. This is particularly important for the security and protection of sensitive financial data.
It establishes the legal framework under which the user can use the services of the bank or payment service provider.
By signing the agreement document, the user commits to comply with certain standards and rules in handling the offered services. This creates binding obligations and ensures smooth payment processes.
Posten, Actions
Clearing Entries
Displays the clearing entries for this bank account. When creating a payment file, a clearing entry is generated for each record.
For more information, see Archive, Clearing Entries.
Payment Status Entries
Opens the overview of payment status entries for this bank account.
For more information, see Archive, Payment Status Entries.
Account Transaction Entries
Opens the overview of imported account transaction entries from konfipay. These account transaction entries can then be imported into the NCPI Import page.
For more information, see Archive, Account Transaction Entries.
Bank Account, Actions
Bank Account Card
Use this action to open the Bank Account Card where you can set the data for this bank account.
Bank Account Information
This action lists all the information from konfipay related to this bank account. This function can be used to synchronize the data in Business Central with the data in konfipay.
Bank Account Setup Card
General, Fields
Bank Account Number
Specifies the bank account number for which the Payment Processing Bank Account Setup was created.
Name
Displays the name of the linked bank account.
IBAN
Displays the IBAN of the linked bank account.
Country/Region Code
Displays the country/region code of the bank account.
Important
The Country/Region Code field must be specified for the bank account to be used in payment processing.
Currency Code
Specifies the relevant currency code for the bank account.
Pay with QR Code
Specifies that this bank account should be used by default for payments with QR code. Only one account can be marked!
Max. Amount for Instant Transfer
Specifies the maximum amount for real-time transfers. If the field is left empty, the default value for SEPA real-time transfers will be used, which is € 100,000.
Posting, Fields
Charge Account No.
Specifies the expense account for the direct transfer of charges to a journal, or the indirect transfer to a journal via bank account reconciliation.
Import, Fields
Acc. Transaction File Format
Specifies in which Camt format the account transactions should be requested from konfipay.
Autom. File Acknowledge
Specifies that after successfully retrieving the account transaction entries from konfipay, the corresponding account transaction file should be automatically marked as confirmed. The file will not be downloaded again during the next retrieval from konfipay.
The initial value of the field is Yes.
For more information, see Transaction view
Export, Fields
SEPA Credit Transfer Schema
Specifies which payment XML schema should be used for SEPA transfers.
For more information, see Setup, Exports, XML Schemas.
SEPA Direct Debit Schema
Specifies which payment XML schema should be used for SEPA direct debits.
For more information, see Setup, Exports, XML Schemas.
Non-SEPA Credit Transfer Schema
Specifies which payment XML schema should be used for non-SEPA transfers.
For more information, see Setup, Exports, XML Schemas.
Originator ID
If necessary, specify the originator ID for the payment XML schemas.
Note
Only specify the originator ID if allowed or required by your bank in the XML file.
Originator ID Issuer
If necessary, specify the issuer of the originator ID for the payment XML schemas.
Note
Only specify the issuer of the originator ID if allowed or required by your bank in the XML file.
Connection to Bank, Fields
Synchronize
Enabling this option allows you to import bank statements directly into Business Central. In addition, generated payment files (collections and transfers) can be sent from Business Central to the bank via the middleware without having to save files locally.
Bank Connection Type
Specifies the data center access through which the account is connected between konfipay and the bank.
The following options are available:
Connection via EBICS
If you have your own fully initialized EBICS contact, EBICS will be automatically set as the connection type.
Note
The connection via EBICS allows for some more detailed setup options for the affected accounts, such as specifying automation intervals.
Connection via Service Data Center
If you do not have your own EBICS contact, the account will be linked to the bank's data center via a service data center connection. konfipay uses a company-owned connection to the bank, eliminating the need to set up your own EBICS contact.
Note
However, in order to use accounts via a service data center connection, it is essential that the customer fills out and sends the participation agreement to the bank, so that the bank can release the account for the service data center procedure on their side.
Test Account
Specifies whether the bank account in konfipay is a sandbox bank account or a productive bank account.
Important
Test accounts do not send information to the bank; instead, konfipay simulates the validations. Therefore, do not use test accounts for real transactions!
Account Balance
Displays the account balance according to konfipay.
Account Balance Currency Code
Displays the currency code of the account balance according to konfipay.
Account Balance Date
Displays the date of the account balance according to konfipay.
Statistics, Fields
Number of Payment Status Entries
Displays the number of new payment status entries for this bank account. The AssistEdit function can be used to view the overview of payment status entries.
Open Payment Status Entries
Displays the number of payment status entries for this bank account. The AssistEdit function can be used to view the overview of payment status entries.
Pending Payment Status Entries
Displays the number of pending payment status entries without a final status for this bank account. The AssistEdit function can be used to view the overview of payment status entries.
New Account Transaction Entries
Displays the number of available account transaction files.
Imported Account Transaction Entries
Displays the number of already imported account transaction files.
Date of Last Import
Displays the date of the NCPI import record for the account transaction file.
Home, Actions
Download Acc. Transaction Entries
This action initiates the import of the account statement files available for the selected bank account from konfipay.
Navigate, Actions
Cash Receipt Journals
Creates an incoming payment journal line for the bank account, for example, to record a payment received.
Payment Journals
Opens the list of outgoing payment journal lines where you can register payments to creditors.
Payment Import
In the Payment Import window, you can import files, transfer data to journal lines or bank account reconciliations, and manage the associated journal lines and reconciliations. Depending on the setup, different actions and fields will be displayed.
Agreement Document
The action opens the konfipay participation agreement that was signed during the setup of the bank account. If the participation agreement has not been imported yet, the download will be performed automatically.
Entry, Actions
Clearing Entries
Displays the clearing entries for this bank account. When creating a payment file, a clearing entry is generated for each record.
For more information, see Archive, Clearing Entries.
Account Transaction Entries
Opens the overview of imported account statements from konfipay. These bank account statement lines can then be imported into the NCPI Import page.
Payment Status Entries
The action opens the overview of payment status entries for this bank account.
Bank Account, Actions
Bank Account Card
Displays or sets detailed information about your bank account, such as the IBAN and SWIFT code or bank account number, the currency to be used, and general data.
Update Account Balance
Synchronizes the account balance in Business Central with konfipay Online Payment Services.
Retrieve Bank Account Information
Lists all information from konfipay related to this bank account. This function can be used to synchronize the data in Business Central with the data in konfipay.
Docs / NAVAX Payment / Setup / General Bank Codes
In the page NCP Bank Codes you can manage the bank codes. You have the possibility to import bank codes easily and comfortably from 3 banking institutions.
Note
If there are already records in the table NCP Bank Code you will be asked how to proceed. You have different possibilities how the import the data are to be handled.
Fields
SWIFT/BIC Code
Specifies the SWIFT code of the bank.
Bank Branch No.
Specifies the bank branch no. of the bank. If the data was imported via Download, the bank branch no., if available, is only imported and viewed for austrian and german bank institutes.
Name
Specifies the name of the bank institute.
ISO Country Code
Specifies the ISO code for the country or region of the bank.
Address
Specifies the address of the bank. If the data was imported via the Download, the address, if available, is only imported and viewed for austrian institutes.
Post Code
Specifies the postal code of the bank.
City
Specifies the city of the bank.
County
Specifies the federal region or country of the bank. If the data was imported using the Download, the county, if available, is imported and viewed only for austrian banks.
Telefon No.
Specifies the phone number of the bank. If the data was imported via the Download, the telephone number, if available, is only imported and viewed for austrian banks.
Fax No.
Specifies the fax number of the bank. If the data was imported via the Download, the fax number, if available, is only imported and viewed for austrian banks.
E-Mail
Specifies the e-mail address of the bank. If the data was imported via the Download, the e-mail address, if available, is only imported and viewed for austrian banks.
Website
Specifies the website address of the bank. If the data was imported via the Download, the website address, if available, is only imported and viewed for austrian banks.
Information
Contains further information about the bank. With Download of the German bank codes, the short name of the bank is entered in this field. With the Download of the Austrian bank codes you can see if the bank is the main bank or a branch. This makes it easier to find out whether it is a branch or the main bank
Actions
Download
The campaign starts the download of the current bank codes directly from the selected main banks.
Österreichischen National Bank
Deutschen Bundesbank
SIX Interbank Clearing AG
You need these bank codes to use the NAVAX Payment Exports.
When you start the download, you will be asked from which bank the bank codes should be imported. Select an institution or import from all three.
Note
If there are already data records in the NCP Bank Code table, you will be asked how to proceed. You have the choice of how to handle the import of the data,
The following options are available:
Create only new records - this option only creates new data records.
Create new records & overwrite existing data records - overwrites or updates the existing codes
Note
Please note that an online connection is established when downloading the bank codes.
Import
This action starts the import of bank codes from a JSON file.
These can be codes from older systems that you have already configured and exported using the export function.
Note
If there are already data records in the NCP Bank Code table, you will be asked how to proceed. You have the choice of how to handle the import of the data,
The following options are available:
Create only new records - this option only creates new data records.
Create new records & overwrite existing data records - overwrites or updates the existing codes
Export
Exports all bank codes from your database to a JSON file.
This exported file can be used for importing into other databases.
Note
Please note that older versions of NCP Payment Export cannot be imported with the exported files in JSON format.
Docs / NAVAX Payment / Setup / General Vendor/Customer Bank Account
In the Creditor/Debtor Bank Account Overview, you can assign your creditor and debtor bank accounts. You can access the overview by clicking on Navigate > Creditor/Debtor > Bank Accounts on the Creditor or Debtor list or the corresponding card.
For more information, see Set up bank accounts in the Business Central online help.
Fields
Code
Description
Code
Specifies a code to identify this debtor bank account.
Name
Specifies the name of the bank where the debtor's bank account is held.
Country/Region Code
Specifies the country/region of the address.
IBAN
Specifies the international bank account number of the bank account.
SWIFT Code
Specifies the SWIFT code (international bank identification number) of the bank where the debtor has the account.
Note
This field may be required when sending payments to a different country or receiving payments from a different country. If the value is not filled, it may cause issues with payment processing using the NAVAX Payment Exports.
Phone No.
Specifies the phone number of the bank where the debtor's account is held.
Contact
Specifies the name of the bank employee with whom you regularly communicate regarding this bank account.
Main Bank
Specifies the vendor bank account that will be used by default on payment journal lines for export to a payment bank file.
Tip
Starting from version 21.1.5.0, the main bank account can also be selected via the Preferred Bank Account Code field on the debtor card. The Main Bank field will then be automatically updated on the corresponding bank account. If the Main Bank field is checked, the Preferred Bank Account Code field on the debtor card will also be updated.
This field is only displayed on a debtor bank account.
Actions
Direct Debit Mandates
Display the direct debit mandates that you have set up to reflect agreements with debtors for the direct collection of payments from their bank account, or edit them.
Payment Entries
This lists all the payment entries for this bank account.
For more information, see Archive, Payment Entries.
Docs / NAVAX Payment / Setup / General Countries/Regions
In this overview you can setup and manage settings for countries and regions to use them for payment transactions.
For more information, see Change basic settings on Business Central online help.
Fields
Use this setup page to define the settings for the individual countries/regions for your business.
Code
Specifies the country/region of the address.
Name
Specifies the name of the country/region.
ISO-Code
Specifies a two-letter country code defined in ISO 3166-1.
SEPA
Indicates whether the country or region participates in SEPA. SEPA (Single Euro Payments Area) stands for the Single Euro Payments Area and aims to use the same procedures and standards in euro payments. With the help of the action Initialize SEPA countries, the countries participating in SEPA can be created automatically.
Important
If this check mark is not correctly set, no SEPA file can be created for the customers and vendors to which it applies.
ISO Numeric Code
Specifies a three-digit code number defined in ISO 3166-1.
Address Format
Specifies the format of the address that is displayed on external-facing documents. You link an address format to a country/region code so that external-facing documents based on cards or documents with that country/region code use the specified address format.
Note
If the County field is filled in, then the county will be printed above the country/region unless you select the City+County+Post Code option.
Contact Adress Format
Specifies where you want the contact name to appear in mailing addresses.
Intrastat Code
Specifies an Intrastat Code for the country/region you are trading with.
For more information, see Intrastat on Business Central online help.
VAT Scheme
Specifies the national body that issues the VAT registration number for the country/region in connection with electronic document sending.
Actions
Custom Address Format
Define the scope and order for fields that make up the country/region address.
VAT Reg. No. Formats
Specifies that the tax registration number for an account, such as customer, corresponds to the standard format for tax registration numbers in an account's country/region.
Initialize SEPA Countries
With this action, all SEPA Countries are automatically created. If the entry already exists, a message is displayed to decide whether the value should be adopted.
Docs / NAVAX Payment / Setup / General Pay with QR-Code
With the NCP Pay with QR Code function you can create a QR code that can then be placed on your invoices - whether digital or paper. The customer thus saves the tedious typing of data and also does not run the risk of entering incorrect data. This also makes it easier to apply payments later that were imported into Business Central via bank account statement.
Before the NCP Pay with Code Setup extension can be used, it must be set up. The general settings and defaults are defined in this window.
Fields
Pay with Code active
Specifies whether the pay with QR Code function is enabled and that a QR code should be printed on customer documents.
Name
Specifies the name to be used as the recipient name in the QR code. When the NCP Pay with Code Setup page is opened for the first time, the field is automatically filled with the company name.
QR Code Version
Specifies the QR Code Version to be used when creating the QR Code.
QR-Code Size
Specifies the QR-Code size for the documents.
QR-Code Resolution
Specifies the actual size of the QR-Code in pixels. If no value is specified, the QR-Codes will be created with a resolution of 600x600 pixels.
Payment Reference
Specifies the structure and values for the payment reference that will be used for the QR code generation. Wildcards can be used in this field. Note that there is a maximum of 35 characters allowed in the payment reference. You can get more information about this via AssistEdit.
The following placeholders can be entered in the Payment Reference field:
%1 Document No.
%2 External Document No.
%3 Customer No.
%4 Customer Name
%5 Our Account No.
%6 Customer Ledger Entry Description
%7 Document Date
%8 Your reference
Tip
Use square brackets, e.g. [REF%8], if you want to output the text only if the placeholder contains a value.
By specifying a numerical value within angle brackets directly after the placeholder, e.g. %1<2> or [Info: %10<15>], you can limit the maximum number of characters of the placeholder.
Important
Note that there is a maximum of 35 characters for the payment reference.
Actions
Bank Accounts
In the window Bank Account Setup, all bank accounts that are required for payment transactions are stored or managed.
Payment Methods
Set up the payment terms that you select from customer cards or sales documents to define when the customer must pay, such as within 14 days.
Setting up a payment method for Pay with QR Code
On the Payment Methods page, the NCP Pay with QR Code field has been added. If the field is enabled and you create an invoice using this payment method, a QR code will be generated for the document. In the NCP Pay with Code Setup, Pay with QR Code active must be enabled.
Set up an bank account for using Pay with QR Code
When generating the QR code, the bank account that should be applied must be specified. This is achieved on the Bank Account Setup page by activating the Bank Account for Pay with QR Code field.
Important
Only one bank account can be set as the default for creating the QR code. If a second one is checked, an error message will appear.
Before the NAVAX Payment Exports 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 NAVAX Payment Exports.
In the following section the steps with the parameters are explained.
Note
You can skip individual steps at any time and complete the configuration at a later time in the NCP Exports Setup.
Fields, Page Originator Setup
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.
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.
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 Exports 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.
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.
Fields, Payment File Setup
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.
Fields, Payment Notification E-Mail Setup
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.
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
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 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 Exports Setup.
Before the NAVAX Payment Exports extension can be used, it must be set up.
In the window NCP Exports 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.
SEPA Direct Debit Mandate ID Separator
Against the bank, the same mandate ID can be used for multiple customers/vendors. To use the same ID for multiple customers/vendors in payment transactions, you can specify a separator and a unique identifier. The separator and all subsequent characters will not be exported.
Enter the separator here. Use this special character when naming the mandate ID. When the setup is initialized, the value for the separator is empty.
Note
By default, this field is hidden and can be displayed using the Personalize function.
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
On this page you can specify whether a summary of the payment file should be shown after the payment file has been created.
In the summary, you have the option to either import the created file into your banking software using the Export Payment File action or send it directly via NAVAX konfipay Connector to konfipay with the Transfer Payment File action to forward it to your bank.”
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 - NCP Exports 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 or Customer 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 should be combined when the payment file is created. They are then sent to the bank as collective transactions.
When submitting transactions to the bank, they can be consolidated for more efficient and cost-saving processing. This is done by bundling posting lines that have the same creditor, customer, or bank account number, the same external bank account code, and the same currency code into a collective transaction.
However, there are certain types of transactions, such as individual transfers and transfers with a payment reference, that are excluded from this consolidation. Credits that are balanced with a document number are also considered if the collective transaction results in a positive amount, which also applies to direct debits.
The use of this functionality is advisable when the options to summarize per creditor or debtor are not selected in the payment proposal. If booking lines have been consolidated into a collective transaction, the resulting payment item receives a corresponding label. The description of the payment item is supplemented with collective transaction.
Note
The fields for the document number and booking date are only filled in if all booking lines within the collective transaction match. If there are differences, these fields remain empty.
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.
This allows you to specify the period for deleting the data via NCP Exports - 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 NCP Exports - Delete Data were last executed.
Archived Files deleted until
Specifies the date until which archived files were deleted from the clearing entries.
Actions
Bank Account Setup
In the window NCP Bank Account Setup, all bank accounts required for NAVAX Payment 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 NCP Bank Account Setup page.
For more information, see Setup, Exports, XML Schemas.
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, Exports, 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.
Docs / NAVAX Payment / Setup / Exports XML Schemas
The EU and the EPC (European Payments Council) are intent on using the XML format as a standard in European payment transactions. At the moment, efforts are being made to minimize the numerous different national variants of payment transaction solutions and ultimately to eliminate them completely. The XML format should replace all other formats in order to standardize the processing of transactions on a technical level Europe-wide. This format is to be introduced and accepted as a standard both in the interbank sector and by customers.
Use this page to manage the XML schemas that are required for exporting the payment file. These schemas are used to map the data from Business Central to the fields in the XML schema file.
Fields
Type
Specifies the type of XML schema. Possible values are: SEPA Credit Transfer, SEPA Direct Debit and Non-SEPA Credit Transfer
Code
Specifies the code of the XML schema. This code meets the SEPA standard of the schema. You can find more information on this on Stuzza
ISO Country Code
Specifies the countries for which the schema is valid. Some countries have different requirements of the ISO standard.
Description
The field Description is a combination of the abbreviation of the field Type, the ISO country code and the rulebook version of the schema. This only applies to downloaded schemas. If you have created a schema yourself, the Description is assigned by you.
IBAN Only possible
The field IBAN Only possible indicates that the schema also supports transactions without the specification of SWIFT Code.
Dom. IBAN Only
The field IBAN Only possible indicates that the schema also supports transactions without the specification of SWIFT Code. If Dom. IBAN Only is set, domestic transactions are also allowed without SWIFT Code.
Int. IBAN Only
The field IBAN Only possible indicates that the schema also supports transactions without the specification of SWIFT Code. If Int. IBAN Only is set, foreign transactions are also allowed without SWIFT Code.
IBAN or Bank Account No. possible
The field IBAN or Bank Account No. possible indicates that the schema also supports transactions without IBAN.
IBAN or Bank Account No.
The field IBAN or Bank Account No. possible indicates that the schema also supports transactions without IBAN. If IBAN or account number is set, the account number of the recipient bank is written to the payment file if no IBAN exists.
Address Specification possible
Indicates that the schema supports address information.
Originator Address
The field Address Specification possible views whether the scheme supports address data. The field Originator Address specifies whether the address data of the originator, which was stored in the NCP Exports Setup, should be written to the payment file.
Recipient Address
The field Address Specification possible indicates that the scheme supports address data. The field Recipient Address specifies the address data of the recipient that should be written to the payment file.
Batch Booking
Specifies how the transaction is posted on the bank side. That is, whether it is a collective posting ('Yes') or an individual posting ('No').
Extended Character Set
Specifies whether the extended character set will be enabled.
In general, the following characters are allowed:
abcdefghijklmnopqrstuvwxyz
ABCDEFGHIJKLMNOPQRSTUVWXYZ
0123456789
/-?:()., "space".
Until now, the following additional characters were allowed for Austrian bank accounts:
&;
In addition, the following characters were automatically converted:
< became "&lgt;"
> became ">"
& became "&"
" became """
became "'"
If the field is set, the above conversion is performed in this schema.
If the Extended Character Set field is not set, the & character is automatically converted to +, all other characters are replaced by a space.
all other characters are replaced by a space.
You can configure the character set by means of the action Allowed Character Set.
For more information, see SEPA Requirements for an Extended Character Set (UNICODE Subset) - Best Practices
Umlaut Conversion
Specifies whether to use umlaut conversion when creating a payment file. Some banking institutions do not allow the use of umlauts.
The conversion will:
Ä or ä to an Ae or ae
Ü or. ü to an Ue or ue
Ö or ö to an Oe or oe
Charges Selection possible
Indicates that the schema allows the specification of charges.
Urgent Payment possible
Indicates that the schema supports urgent payments.
Instant Payment possible
Indicates that the schema supports instant payments.
Date of Specification
Specifies the date of the specification.
Last Date Modified (Schema Lines)
Shows whether, and if so, when the schema lines were last changed.
In Use
Indicates that the scheme is in use.
Lines, Fields
Level
Specifies the level. The level can be understood as the parent XML nodes (e.g., GrpHdr, PmtInf..), within the level the position numbers are assigned per child XML node.
Available options:
A1
B1
C
B2
A2
Position
Specifies the position of the line in the schema. Use the action Update Positions to re-sort the position numbers per Level, this is necessary after inserting a new line.
Indentation
Specifies the indentation, which hierarchically arranges the child XML nodes. The field is not visible on the page, use the actions Indent or Outdent to indent or outdent the XML nodes.
Tag
Specifies the tag name or node name for the XML node.
Tip
By clicking on the field, the text editor opens, which facilitates the editing of the tag. This is especially helpful when the tag is long.
Start Tag
Specifies that the node should be a start tag. By enabling this field, you can indicate that it is an XML node that should contain a start tag. If you activate the field, but not the End Tag field, a parent node is created (e.g., <Tag>). If both fields are activated, a child node is created (thus the XML node is closed in the same line, e.g., <tag>Value</tag>).
End Tag
Specifies that the node should be an end tag. By enabling this field, you can indicate that it is an XML node that should contain an end tag. If you activate the field, but not the Start Tag field, a parent node is created (e.g., <Tag>). If both fields are activated, a child node is created (thus the XML node is closed in the same line, e.g., <tag>Value</tag>).
Value
Specifies the value to be used as the inner text in this XML node. Using the AssitEdit function opens the NCP Exports XML Schema Values page, which provides you with some standard values to choose from, but you can also enter a custom value in the field.
For more information, see Setup, XML Schema Values.
Default Value
Specifies the default value, a default value is understood as a constant. For example, in a SEPA domestic transfer in Austria, the <PmtMtd> node always needs to have the value TRF.
For more information, see Setup, XML Schema Values.
Maximum Character Count
Specifies the maximum number of characters valid for the value of the XML node.
XML
Displays the XML of the tag. This column helps you understand the structure of the XML file.
Attribute
Specifies that the XML node contains an attribute. Enter the attribute name and value in quotation marks.
Skip
Specifies that the XML node should be skipped when a condition is met. The values Yes, If - OR, and If - AND are available. The Skip - If empty and Skip - If not empty fields define the values for the condition.
Skip - If empty
Specifies the value used for the condition to skip. So if the set value for the XML node is empty, it will be skipped.
Skip - If not empty
Specifies the value used for the condition to skip. So if the set value for the XML node is not empty, it will be skipped.
Setup, Actions
Download
Via the action Download you can download or update schemata templates.
Import
With the import function schemas can be imported.
Export
With the export function schemas can be exported.
Init Allowed Characters
Using this action you can change the Allowed Character Set value, for all XML Schemas, to the default.
XML Schema Card, Actions
&Copy from
With Copy from you can create a copy of an existing schema and then edit it.
Allowed Characters
With this action you can configure the allowed characters that are valid for use in payment files. This is necessary if your bank allows a different character set than the SEPA standard.
Init Allowed Characters
Using this action you can change the Allowed Character Set value to the default.
Docs / NAVAX Payment / Setup / Exports Language Setup
All necessary settings for the individual language codes are set up here. Also the Payment Notification Texts and the SEPA Mandates Texts can be stored or set up here.
With the Assisted Setup, values can be suggested for the setup.
Note
In most cases, no language code is stored with the vendors and customers. Therefore, you should also set up a data record without language code.
Fields
Language Code
Specifies the code for the language. If you want to perform setup for vendors and customers who have not defined a language code, leave this field blank. Click the field to view the existing language codes in the Language table.
Language Name
Views the description for the language.
Linked Language Code
Using the field Linked language code allows you to link texts from another language code. This means that the text is not set up with the current language code, but with a linked code.
SEPA Mandates Text Exists
Views if there is a SEPA mandate text for this language setting or not. Click on the field or on the SEPA Mandate Text action to view the text.
Pmt. Notification Payment File Text
Specifies the text to be used for the payment notification in the payment file. The following placeholders can be used in the Payment Notification Text in Payment File field: %1 Payment Notification No.
Pmt. Notification E-Mail Subject
Specifies the text that is to be used for the subject of a notification e-mail. The following placeholders can be used in the Notification E-mail Subject field: %1 Notification No.
Actions
Pmt. Notification E-Mail Text
You can use this action to configure the texts in different languages for the payment notification e-mail messages.
SEPA Mandates Text
With this action the mandate text lines can be defined in different languages.
For more information, see Setup, SEPA Mandates Text Lines.
With the authorization of your customer, you can collect payments directly from the customer's bank account.
In order to be able to process Direct Debits you set up the customer's payment method. Finally, set up the direct debit mandate that corresponds to your agreement with the customer to collect payments within a certain period of time.
To advise the bank to transfer the payment amount from the customer's bank account to your company's account, create a direct debit posting that contains information about bank accounts, the sales invoices that are affected, and the direct debit payment instruction. You then export an XML file based on the direct debit entry and send it to your bank for processing.
Note
SEPA direct debits can only be executed for documents with the currency EURO.
Before you can create an XML file with the payment data, you must perform the following setup steps:
Set up the bank account to which the collected amounts from your customers should be posted.
For more information, see Setup, Bank Account Setup.
Set up the payment method of the customer.
Set up the direct debit mandate that corresponds to your agreement with the customer to direct debit his payments within a certain period of time.
Fields
The following fields are included on the SEPA Direct Debit Mandates page.
ID
Specifies the unique ID of the direct debit mandate.
If you want to use the mandate ID for multiple bank accounts of different customers, enter the mandate ID and extend it with a separator and a freely definable string (e.g., numbers - LAST00001_1). For this, a mandate must first be created as a reference.
The separator is stored in the NCP Exports setup under SEPA Direct Debit Mandate ID Separator.
NCP Direct Debit Type
Specifies that the mandate is a CORE - basic direct debit, a B2B - company direct debit or a COR1 - basic direct debit with reduced processing time.
NCP Final DD Created
Specifies when the final direct debit was created for this mandate.
NCP First Direct Debit Created
Specifies that the first direct debit was created for this mandate.
NCP Mandate Form Printed
Specifies that the mandate form has been printed for this mandate. This field is set if you called the action Print Mandate Form and you printed the form.
Valid From
Specifies the date when the direct-debit mandate starts.
Valid To
Specifies the date when the direct-debit mandate ends.
NCP Payment Entries Exists
Shows the number of payment entries (regardless of the direct debit sequence) for the mandate.
For more information, see Archive, Payment Entries.
Customer Bank Account Code
Specifies customer bank account that the direct-debit mandate is activated for. The field is filled automatically.
Date of Signature
Specifies when the direct-debit mandate was signed by the customer.
Payment Type
Specify that the agreement covers several (recurring) or a single (one-off) direct debit.
Blocked
Specifies that the mandate is locked. This is set if, for example, a customer has been declared as insolvent.
Closed
Specifies that the direct-debit mandate is closed, for example because the date in the Valid To field has been exceeded.
Actions
Print Mandate Form
Use this action to print a form that you can then hand over to the customer. It is used to confirm the agreement with the customer to collect his payments within a certain period of time by signing it.
For more information, see Direct Debit Mandate Form.
Before NAVAX Payment Imports can be used, its basic functionality must be set up. In the window NCP Imports Setup the general settings and defaults are defined.
Note
The import must be set up separately for each company.
Note
You can skip individual steps at any time and complete the configuration at a later time in the NCP Imports Setup.
Fields, Page Import Settings
In the area Import you define which files are allowed for import and where the data should be transferred to.
camt.052 - Account Report
Specifies if and where the camt.052 - Account Report files can be imported and transferred
The following options are available:
empty: no import possible, in the import selection dialog the option, camt.52 - Account Report, does not appear
Import Only: it is possible to import a camt.52 file, but not to transfer it to an journal or bank account reconciliation
camt.53 - Statement
Indicates whether, and if so, where the camt.053 - Statement files can be imported and transferred.
The following options are available:
empty: no import possible, in the import selection dialog the option, camt.53 - Statement, does not appear.
Import Only: it is possible to import a camt.53 file, but not to transfer it to an journal or to the bank account reconciliation.
General Journal: it is possible to import a camt.53 file and transfer the imported lines to a General Journal.
Bank Acc. Reconciliation: the import of a camt.53 file is possible and the imported lines can be transferred to the bank account reconciliation
camt.54 - Debit Credit Notification
Specifies if and where the camt.054 - return data files can be imported and transferred.
The following options are available:
empty: no import possible, in the import selection dialog the option, camt.54 - Debit Credit Notification, does not appear.
Import Only: it is possible to import a camt.54 file, but not to transfer it to an journal or to the bank account reconciliation.
General Journal: it is possible to import a camt.54 file and transfer the imported lines to a General Journal.
Custom
Specifies if and where the Custom Files can be imported and transferred.
The following options are available:
empty: no import possible, in the import selection dialog the option, Benutzerdefiniert, does not appear.
General Journal: the import of a custom file is possible and the imported lines can be transferred to a General Journal.
The section Transfer determines the field values in the Journal or the Bank Account Reconciliation. In addition, you can specify here whether Charges should also be transferred or considered.
Trans. Posting Date
Specifies the value with which the entry date is to be filled when it is transferred to an general journal or to the bank account reconciliation.
The following options are available:
Posting Date/Value Date (Import)
Value Date/Posting Date (Import)
Posting Date (Import)
Value Date (Import)
Workdate
Trans. Document Date
Indicates if and with what value the document date should be filled when it is transferred to an General Journal or to the Bank Account Reconciliation.
The following options are available:
Posting Date/Value Date (Import)
Value Date/Posting Date (Import)
Posting Date (Import)
Value Date (Import)
Arbeitsdatum
Trans. Document No.
Specifies if the document number is to be filled in, and if so, with what value when it is transferred to an General Journal or to the Bank Account Reconciliation.
The following options are available:
Statement No.
Trans. External Document No.
Specifies if the External Document No. should be filled, and if so, with which value when it is transferred to an General Journal or to the Bank Account Reconciliation.
The following options are available:
Statement No.
Trans. Description
Specifies if the description is to be filled in, and if so, with which value when it is transferred to an General Journal or to the Bank Account Reconciliation.
The following options are available:
Remittance Info.
Transaction Description
External Account Holder
Trans. Amount
Specifies if the amount should be filled up with a value when it is transferred to an General Journal or to the Bank Account Reconciliation.
The following options are available:
Order Amount/Transaction Amount: Initial amount, if available, otherwise transaction amount
Transaction Amount
Trans. Charges
Specifies if the expenses should also be transferred to the General Journal or to the Bank Account Reconciliation.
Source Code from Import
Shows the settings in the source code setup.
You can click on the AssistEdit button and select an source code in the Trans. Payment Import to Gen. Jnl page.
Source Code from Bank Acc. Reconciliation
Shows the settings in the origin code setup.
Fields, Page Matching/Application Settings
The setting in the section Matching/Application determine the behavior of the matching or application suggestion.
For more information, see Tasks, Imports, Applying Open Entries.
Document No. Alloc. Accuracy
This can have an impact on automatic assignment of the customer ledger entry.
The following options are available:
Sharp (Identical Value) The system searches for the exact value of the document number of the customer ledger entry.
Fuzzy (Incl. values without special characters) The system first searches for the exact value of the customer ledger entry document number. If nothing is found, the system then searches for the document number without special characters.
Fixed Account Allocations Exists
Indicates that fixed allocations to accounts exist.
Note
This indicator is set automatically if allocations exist.
Specifies that the account allocations are to be retained during automatic matching, even if no documents are found for matching.
Show Analysis Window
Specifies whether a window containing detailed information about the matching should pop up. If you close the window with OK, the suggestion is copied to the journal line or the bank account reconciliation.
Note
Use this indicator for information purposes only. To perform a application, this indicator must be deactivated.
If you specify a value here, the automatic bank account reconciliation lines will only suggest bank account entries for which the posting date does not differ further from the transaction date.
Check Application Amount
Specifies whether the action Import Suggest Application in the journal should only suggest open journal lines where the remaining amount matches the amount from the import.
With the fields Application Tolerance % and Max. Application Tolerance Amount you can specify a tolerance for this check.
Application Tolerance %
Tolerance for the application in percent.
The amount of the open entry can differ from the imported amount by the percentage in the field Application Tolerance %, but at most by the amount in the field Max. Application Tolerance Amount.
Seite Import Codes Download
The payments import codes are references to various types of transactions. Depending on the imported file format, different code fields are filled in.
By default, the table of import codes is empty. You can import the latest import codes via download or import codes from a file.
Using the action Download Import Codes the codes and their description can be downloaded or updated.
For more information, see Setup, Imports, Imports Codes.
Finish setup
If you click on Finish the settings will be saved in the table NCP Imports Setup.
Before NAVAX Payment Imports can be used, its basic functionality must be set up. In the window NCP Imports 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, Import
In the Import section, you define which files are allowed to be imported and where the data should be transferred to.
camt.052 - Account Report
Specifies if and where the camt.052 - Account Report files can be imported and transferred
The following options are available:
empty: no import possible, in the import selection dialog the option, camt.52 - Account Report, does not appear
Import Only: it is possible to import a camt.52 file, but not to transfer it to an journal or bank account reconciliation
camt.53 - Statement
Indicates whether, and if so, where the camt.053 - Statement files can be imported and transferred.
The following options are available:
empty: no import possible, in the import selection dialog the option, camt.53 - Statement, does not appear.
Import Only: it is possible to import a camt.53 file, but not to transfer it to a journal or to the bank account reconciliation.
General Journal: it is possible to import a camt.53 file and transfer the imported lines to a General Journal.
Bank Acc. Reconciliation: the import of a camt.53 file is possible and the imported lines can be transferred to the bank account reconciliation
camt.54 - Debit Credit Notification
Specifies if and where the camt.054 - return data files can be imported and transferred.
The following options are available:
empty: no import possible, in the import selection dialog the option, camt.54 - Debit Credit Notification, does not appear.
Import Only: it is possible to import a camt.54 file, but not to transfer it to a journal or to the bank account reconciliation.
General Journal: it is possible to import a camt.54 file and transfer the imported lines to a General Journal.
MT940 - Statement
Specifies if and where the MT940 - Statement data files can be imported and transferred.
The following options are available:
empty: no import possible, in the import selection dialog the option, MT940 - Statement, does not appear.
Import Only: it is possible to import a MT940 file, but not to transfer it to a journal or to the bank account reconciliation.
General Journal: it is possible to import a MT940 file and transfer the imported lines to a General Journal.
Custom
Specifies if and where the Custom Files can be imported and transferred.
The following options are available:
empty: no import possible, in the import selection dialog the option, Benutzerdefiniert, does not appear.
General Journal: the import of a custom file is possible and the imported lines can be transferred to a General Journal.
The section Transfer determines the field values in the Journal or the Bank Account Reconciliation. In addition, you can specify here whether Charges should also be transferred or considered.
Trans. Posting Date
Specifies the value with which the entry date is to be filled when it is transferred to a general journal or to the bank account reconciliation.
The following options are available:
Posting Date/Value Date (Import)
Value Date/Posting Date (Import)
Posting Date (Import)
Value Date (Import)
Workdate
Trans. Document Date
Indicates if and with what value the document date should be filled when it is transferred to a General Journal or to the Bank Account Reconciliation.
The following options are available:
Posting Date/Value Date (Import)
Value Date/Posting Date (Import)
Posting Date (Import)
Value Date (Import)
Arbeitsdatum
Trans. Document No.
Specifies if the document number is to be filled in, and if so, with what value when it is transferred to a General Journal or to the Bank Account Reconciliation.
The following options are available:
Statement No.
Trans. External Document No.
Specifies if the External Document No. should be filled, and if so, with which value when it is transferred to a General Journal or to the Bank Account Reconciliation.
The following options are available:
Statement No.
Trans. Description
Specifies if the description is to be filled in, and if so, with which value when it is transferred to a General Journal or to the Bank Account Reconciliation.
The following options are available:
Remittance Info.
Transaction Description
External Account Holder
Trans. Amount
Specifies if the amount should be filled up with a value when it is transferred to a General Journal or to the Bank Account Reconciliation.
The following options are available:
Order Amount/Transaction Amount: Initial amount, if available, otherwise transaction amount
Transaction Amount
Trans. Charges
Specifies if the expenses should also be transferred to the General Journal or to the Bank Account Reconciliation.
Source Code from Import
Shows the settings in the source code setup.
You can click on the AssistEdit button and select a source code in the Trans. Payment Import to Gen. Jnl page.
Source Code from Bank Acc. Reconciliation
Shows the settings in the origin code setup.
Fields, Matching/Application
The setting in the section Matching/Application determine the behavior of the matching or application suggestion.
For more information, see Tasks, Applying Open Entries.
Document No. Alloc. Accuracy
This can have an impact on automatic application of the customer ledger entry.
The following options are available:
Sharp (Identical Value) The system searches for the exact value of the document number of the customer ledger entry.
Fuzzy (Incl. values without special characters) The system first searches for the exact value of the customer ledger entry document number. If nothing is found, the system then searches for the document number without special characters.
Fixed Account Allocations Exists
Indicates that fixed allocations to accounts exist.
Note
This indicator is set automatically if allocations exist.
Use the AssistEdit function to navigate to the list of Fixed Account Allocations.
Specifies that the account allocations should be kept during automatic matching, even if no documents are found for the matching.
Caution
This setting can cause incorrect suggestions and should be used with caution.
Tip
If you notice that some allocations are not correct, enabling the analysis window can help identify the cause.
Separators Ext. Document No.
Shows the separators that will be used for automatic application in the journals for the external document no. field. The external document no. is then subdivided for the search to achieve a better result. If the field remains empty, the external document no. is used as entered for the search.
Show Analysis Window
Specifies whether a window containing detailed information about the matching should pop up. If you close the window with OK, the suggestion is copied to the journal line or the bank account reconciliation.
Note
Use this indicator for information purposes only. To perform an application, this indicator must be deactivated.
If you specify a value here, the automatic bank account reconciliation lines will only suggest bank account entries for which the posting date does not differ further from the transaction date.
Check Application Amount
Specifies whether the action Import Suggest Application in the journal should only suggest open journal lines where the remaining amount matches the amount from the import.
With the fields Application Tolerance % and Max. Application Tolerance Amount you can specify a tolerance for this check.
Application Tolerance %
Tolerance for the application in percent.
The amount of the open entry can differ from the imported amount by the percentage in the field Application Tolerance %, but at most by the amount in the field Max. Application Tolerance Amount.
Actions
Bank Account Setup
In the window NCP Bank Account Setup all bank accounts that are required for NAVAX Payment are stored or managed.
For more information, see General 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.
Setup, Actions
Import Codes
Using this action, the window NCP Import Codes can be opened. When a file is imported, different code fields are filled, depending on the imported file format. Here you can enter a more detailed description for these code fields. Using the action Download the codes and their description can be downloaded or updated.
For more information, see Import Setup, Import Codes.
This allows you to specify the period for deleting the data via NCP Exports - 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 NCP Export - Delete Data were last executed.
Archived Files deleted until
Specifies the date until which archived files were deleted from the clearing entries.
System, Actions
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.
Opens the NAVAX License Management which displays the current license status of the NAVAX extensions.
For more information, see Appendix, NAVAX License Management.
In the NAVAX Dropzone Setup page the settings and defaults for the different Dropzones are defined.
The NAVAX Dropzone can be used by various extensions. These extensions automatically add further options in the Dropzone field. For example, the NAVAX extension NAVAX Drag & Drop Document Attachments adds the option Document Attachments and the NAVAX extension Finmatics Autonomous Accounting adds the option Incoming Finmatics Documents.
Note
NAVAX Dropzones are suitable for upload sizes up to 15000 KB (15 MB).
If you change the settings, the page that displays the Dropzone may need to be reloaded or refreshed for the new settings to take effect.
Fields
Dropzone
Specifies for which Dropzone the settings apply.
The settings of the Default dropzone apply to all dropzones that do not have their own settings.
Max. Upload Size (KB)
Specifies the maximum total size of all files in KB that may be uploaded at the same time.
The default value that is suggested is 5000 KB (5 MB). The maximum value that can be entered is 15000 KB (15 MB).
Max. No. of Files
Specifies the maximum number of files that may be uploaded at the same time.
Allowed File Extensions
Specifies which file extensions may be uploaded. If the field is empty, all extensions are allowed. If multiple extensions are allowed, they can be specified separated by a comma. Example: pdf,doc*,xls*,png,txt,zip
Tip
If you specify 'doc', only files with .doc file extension may be uploaded. If 'doc*' is specified, files with file extension .docx, .docm etc. may also be uploaded.
Extract zip Files
Specifies whether *.zip files should be automatically decompressed or unzipped during upload.
Timeout (Milliseconds)
Specifies the duration in milliseconds that a file may take to upload before the process terminates with an error.
You can define a special format for the payment file if the existing standard formats do not meet the requirements of your bank.
In the setup (NCP Imports Setup) you define what user-defined formats can be used for. During import (Import Payment File) you can then select the option Custom Format.
Fields
Code
Specifies the code for the custom format.
Description
Specifies a description for the custom format.
Active
Specifies whether the custom format is completely set up and active. Only active formats can be used in NCP Imports.
Bank Account No.
Specifies the bank account number for whom the format is valid.
Bank Account Name
Shows the bank account name.
Note
This field is filled in automatically if you enter the Bank Account No..
Bank Account IBAN
Shows the bank account IBAN.
Note
This field is filled in automatically if you enter the Bank Account Number.
Separator
Specifies the separator symbol for the fields.
Start Delimiter
Specifies the start delimiter for the fields.
End Delimiter
Specifies the end character for the fields.
Decimal Separator
Specifies the decimal separator for the fields.
No. of Fields
Shows the number of existing fields for this format.
Note
If you click in the field you will open the page NCP Imports Custom Format Fields.
For more information, see NCP Imports Custom Format Fields.
No. of Assigned Import Fields
Shows the number of assigned import fields for this format.
Note
If you click in the field you will open the page NCP Imports Custom Format Fields.
For more information, see NCP Imports Custom Format Fields.
File Structure
Shows the file structure with the separators of the import format.
Actions
Fields
Shows the list of the configured fields of the custom format, you can make the settings regarding the fields here.
Suggest Fields
With the function Suggest fields, the fields can be automatically read or suggested from the CSV file (header line). Each field in the file that is to be imported into the NCP Imports must then be assigned to a field number of the import.
Actions, Setup
Import
This action imports a file with a user defined format in CSV format. The file must start with a header line containing the field names. A row or record cannot be longer than 1024 characters. After creating a format and setting up the separators used in the CSV file, the fields of the file and their assignment to the NCP Imports can be set up. These files can be imported from other systems that you have already configured and exported using the export function.
Export
Use this action to export a custom format to a file. This exported file can be used for import into other databases.
The NCP Import Codes are references to various types of transactions. Different code fields are filled depending on the imported file format.
The table of Import Codes is empty by default. You can import the latest Import Codes via download or import the codes from a file.
Go to NCP Payment > Setup > Imports > Setup > Import Codes.
You have the following options:
Click on Download to download the latest import codes.
Click Import to import the file NCP1600_ImportCodes.xml
Click Export to export all records to one file. (You do not have the option to select individual records only).
If import codes already exist, you can choose (during download and import) to create new records only or to overwrite existing records as well.
After the download/import the import codes are displayed:
Fields
Type
Specifies the type of the code.
The following options are available:
SWIFT Transaction
Transaction
Domain Transaction
Family Transaction
Sub-Family Transaction
Return Reason
Code
Specifies a code for the import code. The code must be unique - a code may not be used twice in a table. You can set up as many import codes as you like.
Description
Description of the import code.
Actions, Setup
Download
The Download action can be used to download or update the codes.
Download - Save as
With the action Download - Save as the codes can be downloaded and saved. No changes in the database will be made.
Import
With the Import action, the codes can be imported from a file. These can be codes from older systems that you have already configured and exported using the export function.
Export
With the Export action, the codes can be exported to a file. This exported file can be used for import into other databases.
If a bank account is determined when importing a payment file (Import Payment File), the system first checks whether fixed account allocations exist. If there are any, this bank account is used.
On this page you will find information about setting up these Fixed Account Allocations.
Fields
Search Order No.
Order in which the rows are searched when determining the bank account.
The first line matching the condition will be used.
If an account number is searched for (e.g. with the option Search for = Account No. via Ext. Bank Account) and a unique customer no. or vendor no. is found, this will be applied as a filter to the open entries for any subsequent lines.
Note
You can enter the lines in any order. The next time you open the window, the list is automatically sorted by number.
Search for
Text sequence or value to be searched for in the import file.
Search in
Specifies the area in the import where the search for value is located or where to search:
The following options are available:
Remittance Info
Payment Reference
Transaction Reference (Ordering Party Reference)
Check No.
Ext. Account Holder
Account Type
Specify the account type for the assignment.
The following options are available:
General Ledger
Vendor
Customer
Bank Account
Account No.
Select the account no. from your chart of accounts to be used for the mapping.
Actions
Dimensions
View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history.
Here, the general settings and default settings for the konfipay Connector are defined. konfipay offers a REST-compliant web service as a communication interface, which can be integrated by Microsoft Dynamics Business Central to automate business processes.
The received payment transactions (SEPA XML files) are checked for conformity by konfipay before acceptance and then stored. After submission, the payment transactions are transferred to the respective data centers of the banking institutions at regular intervals.
In addition, the data inventory of the account information is automatically updated by konfipay at equally regular intervals. These can then be retrieved via the web service. The data is retained by konfipay, meaning you can retrieve it again whenever needed.
For more information, see konfipay Wiki - Mandantenverwaltung
General, Fields
Environment
Specifies whether the konfipay Connector production environment or the konfipay Connector test environment should be used.
Real Data Permission
Indicates whether data may be sent from the current Business Central environment to the konfipay Connector production environment. This additional security level prevents test data from being accidentally interpreted as real data. Click on the field to manage the Permissions.
Connection, Fields
konfipay offers a REST compliant web service as a communication interface, which can be integrated by Microsoft Dynamics Business Central to automate business processes. The received payment transactions in form of SEPA XML files, are first checked and then stored by konfipay prior to acceptance. After submission, the payment transactions are transferred to the respective data centers of the banking institutions at regular intervals. In addition, the konfipay account information database is automatically updated at equally regular intervals. These can then be retrieved via the web service. The data is retained by konfipay, i.e. you can retrieve it at any time if required.
API Key
Specifies the access key required for communication between the konfipay Connector and the konfipay API.
Portal Address
Specifies the base URL of the konfipay portal. This is required for calling the API interfaces.
Tip
If you click on the button next to the field with the three dots, you will be taken to the respective portal.
Timeout (Milliseconds)
Specifies the length of time in milliseconds that the service is allowed to use, before aborting with an error.
konfipay Connector Active
Specifies whether konfipay is enabled and ready for submission. If you want to use konfipay for direct communication with your bank, this option must be enabled.
Account, Fields
RID
Shows the konfipay UUID. This corresponds to the UUID field in the konfipay portal configuration.
Customer No.
Shows the konfipay Customer No.. This corresponds to the Customer No. field in the konfipay portal configuration.
Financial Institutions supported by konfipay
Opens a website with a list of credit institutions that are already connected to konfipay.
Data Update, Fields
Bank Acc. Amounts
Shows whether a job queue is set up to automatically synchronize the bank account amounts from konfipay. If a job queue exists, its current status is displayed.
Click on the field to set up, manage or view the Job Queue.
Payment Status Entries
Indicates whether a job queue is set up to automatically synchronize status entries from konfipay. If a job queue exists, its current status is displayed.
Click on the field to set up, manage or view the Job Queue.
Account Transaction Entries
Shows whether a job queue has been set up to automatically synchronize the account transaction items via the konfipay Connector. If a job queue exists, its current status is shown.
Click on the field to set up, manage or show the task queue.
History, Fields
Delete Log Entries Date Calculation
Specifies the time period for deleting log entries. If the field is empty, the period is assumed to be 1M (1 month).
Log Service Requests
Specifies whether to store the data sent to the service.
Log Service Responses
Specifies whether the data returned by the service should be stored.
Actions
Check Connection
Tests the connection to konfipay with the specified settings.
Service Log
Opens the list of konfipay log entries.
Web Frontend
The action opens a new browser window with the selected konfipay portal. Here you can set up konfipay directly.
Setup, Actions
Bank Account Setup
In the window ''Bank Account Setup'', all bank accounts that are required for payment transactions are stored or managed.
Import Setup
Before the NCPI Payment Import can be used, its basic functionality must be set up. In the NAVAX Imports Setup window, you define the general settings and defaults.
Export Setup
Before the NAVAX Payment Exports can be used, its basic functionality must be set up. In the NCP Exports Setup window, you define the general settings and defaults.
Bank Codes
This action opens the page where bank data can be managed or set up per SWIFT code and bank branch number.
Currency Exchange Rate Services
View or edit the setup of the services that are set up to fetch updated currency exchange rates when you choose the Update Exchange Rates action.
System, Actions
NAVAX License Management
Opens the NAVAX License Management which displays the current license status of the NAVAX extensions.
konfipay Connector operates exclusively in conjunction with a validated Finmatics account.
Note
Please note that when using konfipay, additional costs may apply.
How do I request my konfipay access?
To create a new account with konfipay, it is necessary for you to fill out the Contact form on the konfipay website. konfipay will promptly get in touch with you, providing your account details and guiding you through the initial steps in the interface.
Docs / NAVAX Payment / Tasks / Exports Working with Payment Exports
When you make payments to vendors or customers or gather open entries, you post the respective payment entries in a payment or cash receipt journal. These journals have been optimized for applying and executing payments. They contain several powerful features, such as the Payment Suggestion function, which helps you to find outstanding payments and insert them into a payment or cash receipt journal. NAVAX Payment Exports extends this functionality to enable you to process your payment transactions quickly, easily and in a customer-friendly manner, in compliance with national and international standards. You can export data to a Payment File from a payment or cash receipt journal.
Below you will find instructions on how to do this.
Note
You initiate payments to vendors and customers (for example, credit memos) in the payment journal.
In the cash receipt journal, you initiate the collection of payments from customers.
In both cases the following steps will lead you to your goal:
Making a payment suggestion
To create a payment proposal, proceed as follows:
In the role center, klick NAVAX Payment > Payment Journal or Cash Receipt Journal or ☰ > NAVAX Payment > Payment Journal or Cash Receipt Journal if you are not in the Accountant role.
Click on Suggest Payments (Suggest Customer Payments or Suggest Vendor Payments)
The Vendor Payment Suggestion or Customer Payment Suggestion window opens.
Enter the desired parameters.
Click on OK.
The outstanding entries are determined and written to the journal.
If you also use the konfipay Connector extension, you can transfer the payment file to the bank using konfipay.
To do this, click on the action Transfer Payment File in the journal.
Information on how to retrieve the status of the sent payment file can be found in the Payment Status Entries section.
Getting Payment Information
In the following section you will learn how to get information about the entries in the journal or the created Payment Files.
The Payment Statistic
With the action Payment Statistics, a new page is opened. In the page, a line per payment file that was created from the journal is listed.
For more information, see Reports and Analysis, Payment Statistics.
Clearing Entries
When a payment file is created, a clearing entry is being created.
To display the clearing entries, proceed as follows:
With the action Clearing Entries you open the overview of the Clearing Entries for the respective bank account. You will find the action:
via the role centre under NAVAX Payment - Clearing Entries
Payment entries are created when a payment file is created. They contain information about which entries were cleared by the payment.
Open the Payment Entries as described above.
Click on the button Remittance Entries.
An overview of the entries, that were generated for the bank account when the payment file was created, is displayed.
Payment Posting Entries
When you post the journal, a Payment Posting Entry is created, which contains information about the posting.
You can access this overview by clicking on the No. of Pmt. Posting Entries field in the Payment Entry list.
Payment Status Entry
If the payment file was transmitted to the bank using the konfipay Connector, a Payment Status Entry is created. Since it sometimes happens that the bank does not process the payment file immediately, you can monitor the payment status through the Payment Status Entry.
You start the Payment Suggestion in a Payment Journal (Payment Journals and Cash Receipt Journals).
Depending on which suggestion you start, the Vendor Payment Suggestion or the Customer Payment Suggestion window opens.
The parameters define how the open entries are determined for the payment suggestion, how they are grouped by customer or vendor and which data is written to the journal lines.
The following section describes the available parameters:
Find Payments:
Last Payment Date
The payment suggestion only considers entries whose due date is before or on this date. Only entries for which no value is entered in the field On Hold are taken into account.
Find Payment Discounts
Indicator that the payment discount date is taken into account when searching for available payments.
Instead of the field Last Due Date, the field Last Payment Discount Date is taken into account.
If the option Consider Payment Discount Tolerance is activated, the Discount Tolerance is also taken into account.
Last Payment Discount Date
Indicator that the payment discount date is taken into account when searching for possible payments.
Instead of the field Last Due Date, the field Last Cash Discount Date is taken into account.
Last Payment Discount Date
If the indicator Find Payment Discount is set, this field (and not the field Last Due Date) is taken into account for filtering by payment discount date. If the field is empty, the field Last Due Date is used to find the items.
Check Other Journal Batches
Specifies whether to exclude payments that are already included in another journal batch from new suggested payments. This helps avoid duplicate payments.
Use Vendor Priority
Indicator that the Priority field on the vendor card determines the order in which the vendor entries are suggested for payment.
This field is available only for payment suggestions in payment journals.
Payments are made until the amount in the field Available Amount (LCY) is consumed.
Available Amount (LCY)
Amount available for payments to vendors.
Note
This field is only available for payment suggestions in payment journals.
Payments to vendors are made (ranked according to vendor priority) until the amount is used up.
Check Other Journal Batches
Specifies whether to exclude payments that are already included in another journal batch from new suggested payments. This helps avoid duplicate payments.
Incl. Customers with Credit
Specifies that customers with credit should be included in the payment suggestion.
Selecting this option will also include customers with a positive balance. Under normal circumstances, these customers would not appear in the payment suggestion. However, this additional option means that they can still be suggested.
Note
Differences between "Without Reductions" and "Incl. Customers with Credit"
The option Incl. Customers with Credit should not be confused with the option Without Reduction. Here are 3 examples to illustrate the differences:
Example 1 - Using "Without Reductions"
Customer Adatum Corporation has 3 outstanding invoices, which total € 1,200. However, there is also an open credit memo with an amount of € 200 for the same customer. If the option Without Reductions were selected, this credit memo would not be taken into account and an amount of € 1,200 would be debited when the direct debit is collected. This option can be used regardless of whether the sum of the refunds exceeds the sum of the outstanding invoices.
Example 2- Using "Incl. Customers with Credit"
Customer Trey Research has 3 outstanding invoices which total € 2 100. There is an open credit memo of € 3,000 for the same customer. In this case, the customer would not be included in the payment suggestion because the customer has a positive balance overall. However, if you want to include customers with credit balances in the payment suggestion (direct debit), you must activate the Incl. Customers with Credit function. However, you must note that if you do not use Summarize per Customer, the refunds must be manually removed from the payment journal, otherwise the journal cannot be posted.
Note
This field is only available in payment suggestions created for customers.
Incl. Vendors with Credit
Specifies that vendors with credit should be included in the payment suggestion.
When this option is selected, payments to vendors with a positive balance are also taken into account. This means that the existing credit balance with the vendor is higher than the outstanding invoices.
Note
Differences between "Without reduction" and "Incl. Vendors with Credit"
The option Incl. Vendor with Credit should not be confused with the option Without Reduction. Here are 3 examples to illustrate what the differences are:
Example 1 - Using "Without Reductions"
We have 3 outstanding invoices with the vendor Nod Publishers which total € 1,200. However, there is also an open credit memo with the same vendor with an amount of € 200. If the option Without Reductions were selected, this credit memo would not be taken into account and an amount of € 1 200 would be transferred. This option can be used regardless of whether the total of open credit memos exceeds the total of open invoices with the vendor.
Example 2- Using "Incl. creditors with credit balance"
We have 3 outstanding invoices with vendor Wide World Importers which total € 2 100,-. The same vendor has an open credit memo of € 3,000. In this case, the vendor would not be included in the payment suggestion because we have a positive balance. However, if you want to include the vendors with a credit balance in the payment suggestion, you must activate the Incl. Vendors with Credit function. Please note, however, that if you do not use Summarize per Vendor, the refunds must be manually removed from the payment journal, otherwise the journal cannot be posted.
Note
This field is only available in payment suggestions created for vendors.
Summarize Results:
Summarize per Vendor
Indicator that the lines are summarized per vendor (and currency).
Note
This field is only available in payment suggestions created for vendors.
Summarize per Customer
Indicator that the lines are summarized per customer (and currency).
Note
This field is only available in payment suggestions created for customers.
By Dimension
Select the dimensions by which you want to group the payment suggestions. It is possible for the same combination of
Vendor/Customer
Combination of Dimension Values
and Currency
to create a line.
Note
This field is only available if the indicator Summarize per Vendor or Summarize per Customer is set.
Fill in Journal Lines:
Posting Date
Date on which the payments are posted.
This field is transferred to the journal lines.
Consider Payment Discount Tolerance
If this field is set, the payment discount tolerance date of the entries is taken into account in the calculation, except if the field Block payment tolerance is set on the vendor/customer card. If the Use Payment Discount field is also set, the system filters not only on the payment discount date but also on the payment discount tolerance date when searching for possible (future) payments.
Calculate Posting Date from Applies-to-Doc. Due Date
Specifies if the due date on the purchase invoice will be used as a basis to calculate the payment posting date.
Applies-to-Doc. Due Date Offset
Specifies a period of time that will separate the payment posting date from the due date on the invoice. Example 1: To pay the invoice on the Friday in the week of the due date, enter CW-2D (current week minus two days). Example 2: To pay the invoice two days before the due date, enter -2D (minus two days).
Starting Document No.
Document number for the first line of the payment suggestion.
Note
If the indicator New Doc. No. per Line is not set, this number is applied to every journal line.
New Doc. No. per Line
Indicates that the journal lines are numbered sequentially (starting from the number in the field Starting Document No.).
Bal. Account Type
Type of balancing account (G/L account, bank account).
Note
The value is taken from the settings for the journal and is predefined. This field is applied to all journal lines.
Bal. Account No.
Number of the balancing account to which the posting is to be posted.
You can enter the account number or select from a drop down list.
Note
The value is taken from the settings for the journal and is predefined. This field is applied to all journal lines.
Payment Type
Payment type for the journal lines.
The following options are available:
Direct Debit Suggestion (only available in cash receipt journals)
Non-SEPA Credit Transfer
SEPA Credit Transfer
SEPA Direct Debit (only available in cash receipt journals)
Note
If the field is empty, you must manually specify the payment type in the journal for each line.
For the SEPA Credit Transfer and SEPA Direct Debit payment types, only lines with the ISO currency code "blank" or "EUR" are included in the payment suggestion.
.
If you select the option Credit Transfer Suggestion, the system will try to create a credit transfer in the following order
SEPA Credit Transfer (if the rules of the external bank account search apply (IBAN, country/region code, SWIFT code available) and the company's bank account contains a SEPA credit transfer scheme.
For more information, see Bank Account Setup.
Non-SEPA Credit Transfer if your bank account has a non-SEPA credit transfer scheme.
If you choose the option Direct Debit Suggestion, the system searches for existing transactions of the customer with this currency code. The system tries to create a Direct Debit in the following order
SEPA Direct Debit (if the rules of the external bank account search apply and the company's bank account contains a SEPA Direct Debit Scheme.
For more information, see Bank Account Setup.
If a transaction is found, the payment type and the external bank account code of the transaction are suggested. If no transaction is found, the system tries to determine the external bank account and payment type according to the rules of the external bank account search.
The external bank account search, especially with the option Last Transaction/Main Bank Account, in combination with direct debit/credit transfer suggestion, should provide the best results in most cases.
For more information, see NCP Exports Setup.
Foreign Currency Filter
Indicator that the filter is applied to items with ISO currency codes other than 'blank' or 'EUR'.
Without Reductions
Indicator that entries that would reduce the amount (credit memos, refunds) are not included in the payment suggestion.
Vendor/Customer
In this filter pane, you can limit the results of the payment suggestion by setting filters on the customer/vendor tables. You can find further information on this under Sorting, Searching, and Filtering
Vendor/Customer Ledger Entry
In this filter pane, you can limit the results of the payment suggestion by setting filters on the customer ledger entry/vendor ledger entry ledger entry tables. You can find further information on this under Sorting, Searching, and Filtering
Click (in the journal) on the action Create Payment File.
In the page that opens, specify which lines are to be exported to the Payment File. Select the required lines. Some of the data in the selected lines can still be changed when the payment file is created:
Specify the Execution Date on which the bank should proceed the payments.
The fields Direct Debit Type and Execution Date One-Off/First Direct Debit can only be changed for the payment type "SEPA Credit Transfer".
The field Charges can only be changed if the XML schema of the bank account supports charges.
For more information, see Setup, Exports, XML Schemas.
If you activate the checkbox Urgent payment, the execution date is set to the current day. If Urgent Payment is not activated, the execution date is set to the following day. For SEPA direct debits with the direct debit type "CORE - basic direct debit", the execution date is set to the current day + 2 days.
Click on OK and confirm the message.
The payment file is created. The Payment Status field is automatically set to Created for all lines exported to the payment file.
Transactions with the same currency codes, debit types, debit sequences and execution date are combined in one file.
Note
When the Collective Transaction option is active in the NCP Exports Setup window, journal lines are summarized in the payment file. In this way, they can also perform the collection of a credit memo. If an invoice with a higher absolute amount is to be cleared, the credit memo can also be cleared in the collective transaction. However, the amounts are posted separately in the payment journal.
For more information, see Setup, Exports, Exports Setup.
Options, Options
Bank Account No.
Enter the bank account number for which you want to create payment suggestions. This bank account number is then used in the payments journal lines.
Payment Type
Select the payment type for which you want to create the payment file. For all payment types that are to be available or are in use, the settings must be defined in the NCP Exports Setup under Payment File.
Execution Date
The execution date is calculated as follows: For urgent payments or instant credit transfers, 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.
Direct Debit Type
Select the type of direct debit from the list: CORE - basic direct debit, a B2B - company direct debit or a COR1 - basic direct debit with shortened lead time.
Execution Date One-Off/First Direct Debit
The date is only available for SEPA Direct Debit in combination with direct debit type CORE - Basic Direct Debit and is calculated as follows: Today + 5 days.
Charges
This option is available if the XML schema of the bank account supports charges for the selected payment type.
Urgent Payment
This option is available if the bank accounts XML schema supports urgent payments for the chosen payment type.
Instant Payment
This option is available if the bank accounts XML schema supports instant payments for the chosen payment type.
Show Summary
Specifies whether or not to display a summary after the payment file is created.
Note
The option can be preconfigured in the NCP Exports Setup with the option Show Summary after File Create option.
Transmit after create
Specifies whether the payment file should be sent to the bank via NAVAX konfipay Connector after it has been created.
Note
The option can be preconfigured in the NCP Exports Setup with the option Autom. send with konfipay option.
The documentation on this page applies to the payments and cash receipt journals.
The Payment Journals (payment journals or cash receipt journals) are a type of general journals that have been optimized for applying payments/direct debits.
Use the journal to routinely reconcile your bank, customer and vendor accounts by clearing the corresponding open (unpaid) invoices and/or credit memos in Microsoft Business Central.
The NAVAX Payment Exports extension can help you to suggest these payments/direct debits and automatically add them as ledger entries in the journal to create a payment file.
Once a payment file has been created, you can then import them into your banking software. The valid standards for SEPA payments are taken into account.
Fields
The table includes following fields:
Posting Date
Specifies the posting date for the entry.
Note
Please note - it may or may not be the date ON WHICH the payment is posted.
This field is copied from the payment suggestion, it is also taken into account when determining the discount.
Document Type
Specifies the type of document that the entry on the journal line is.
Document No.
The document numbers are numbered in ascending order by the payment suggestion. If a Start from Document No. is set in the payment suggestion, this is used for the first journal line.
External Document No.
Specifies a second document number. This usually refers to the numbering system used by the customer or vendor.
Account Type
Specifies the account type for the field Account No..
The following values are available:
G/L Account
Customer
Vendor
Bank Account
Fixed Asset
IC Partner
Employee
Note
If you fill the journal by payment suggestion then only customer and vendor appears in the Account Type.
Account No.
Specifies the account number that the entry on the journal line will be posted to.
Note
This field is copied from the payment suggestion.
Recipient Bank Account
Specifies the bank account that the amount will be transferred to after it has been exported from the payment journal.
Tip
Learn here how to set a preferred option for the payment journal lines, if for example: a vendor has one or more bank accounts::
For more information, see Set up a preferred vendor bank account
You can do the same for customers, the Preferred Bank Account Code field can also be found on the customers card in the Payments section.
Message to Recipient
Specifies the message exported to the payment file when you use the Export Payments to File function in the Payment Journal window.
Description
Specifies the description of the entry.
Note
This field is copied from the payment suggestion.
Currency Code
Specifies the code of the currency for the amounts on the journal line.
Payment Method Code
Specifies how to make payment, such as with bank transfer, cash, or check.
Amount
Specifies the total amount (including VAT) that the journal line consists of.
Amount (LCY)
Specifies the total amount in local currency (including VAT) that the journal line consists of.
Bal. Account Type
Specifies the type of account that a balancing entry is posted to, such as BANK for a cash account.
Note
This field is copied from the payment suggestion.
Bal. Account No.
Specifies the number of the general ledger, customer, vendor, or bank account that the balancing entry is posted to, such as a cash account for cash purchases.
Note
This field is copied from the payment suggestion.
Applied (Yes/No)
Specifies if the payment has been applied.
Applies-to Doc. Type
Specifies the type of the posted document that this document or journal line will be applied to when you post, for example to register payment.
Applies-to Doc. No.
Specifies the number of the posted document that this document or journal line will be applied to when you post, for example to register payment.
Applies-to Doc. Due Date
Specifies the due date from the Applies-to Doc. on the journal line.
Payment Type
Specifies the payment typ for the journal line.
The following values are available:
Non-SEPA Credit Transfer
SEPA Credit Transfer
SEPA Direct Debit
Note
The field Payment Type can already be filled by the payment suggestion. You can only change the value, in a standard setup, as long as the indicator Payment Created is not set.
Payment File Status
Specifies whether the line is ready to be exported to a payment file.
🗸 Ready indicates that the line is ready.
✉ Sent indicates that the line was sent via konfipay Connector.
✗ Check indicates that not all necessary values are missing in the line.
Note
Dieser Status verhindert nicht die weitere Verarbeitung, er dient nur zur Information dass die Zeile kontrolliert werden muss.
🖫 Created indicates that the line has already been exported.
Tip
Via the DrillDown function you can open an overview of the error messages.
Direct Debit Mandate ID
Specifies the identification of the direct-debit mandate that is being used on the journal lines to process a direct debit collection.
Note
This field is only available in the cash receipt journal.
Direct Debit Type
Specifies the direct debit type for the transaction.
Note
This field is only available in the cash receipt journal.
The value of the mandate in the Direct Debit Mandate ID field is automatically applied into this field.
Direct Debit Sequence
Specifies the direct debit sequence
Options:
One-Off
Recurrent
First
Last
Note
This field is only available in the cash receipt journal.
The value of the mandate is automatically applied in this field.
Original Direct Debit Sequence
The field Original Direct Debit Sequence is being filled if the sequence is changed automatically by the file creation. If the transaction is cancelled, the direct debit sequence is reset.
Note
This field is only available in the cash receipt journal.
The value of the mandate is automatically applied in this field.
Date of Mandate
This field will be filled when you enter the Recipient Bank Account field or via the payment suggestion and can be changed in the journal if necessary. The default value is based on the field Date of Signature from the customer bank account card.
Note
This field is only available in the cash receipt journal.
Payment Reference
Payment reference of the vendor (in the payment journal) or the customer (in the cash receipt journal).
One-Time Transfer
This is the indicator for a one-time instruction.
Note
This field is being filled by the system when a one-time bank transfer is set up.
If the file has already been created, this field is automatically filled with the option File Created.
konfipay Zahlungsstatus
Shows the status of a payment file transmitted to Konfipay.
Use the AssistEdit function to access an overview of Payment Status Entries.
The status can be queried at any time via the Konfipay connector, either using the Check Payment File Status action or on the Payment Status Entries page using the Update Payment Status action.
No. of Payment Entries
Number of payment entries for this journal line.
Execution Date
Date on which the payment will be executed.
Pmt. Notification
If a payment notification exists for this line, the field is automatically filled with the option "Yes". For more information, see Create Payment Notification.
Pmt. Notification No.
The number of the notification. This number is obtained from a number series that you have set up in the NCP Exports Setup in the field Payment Notification Numbers. For more information, see NCP Exports Setup - Create Payment Files.
Pmt. Notification Printed
Indicates that the payment advice note has already been printed.
Note
This indicator is automatically set when you execute the Payment Notification E-Mail Suggestion and print the Payment Notification after creating the Payment File.
Pmt. Notification E-Mail Sent
Kennzeichen, dass das Avis bereits versendet wurde.
Note
This indicator is automatically set when you execute the Payment Notification E-Mail Suggestion and send the Payment Notification vie e-mail after creating the Payment File.
Bank Payment Type
Specifies the code for the payment type to be used for the entry on the journal line.
Note
This field is only available in the payment journal. This field is copied from the payment suggestion.
Correction
Specifies the entry as a reversal entry. This only causes the entry to be viewed on the "wrong" side with a negative sign on various analyses.
Collective Transaction No.
This field is hidden by default. If the indicator Collective Transaction is not set in the NCP Exports Setup (For more information, see NCP Exports Setup.), collective transactions are not executed. Lines with the same collective transaction number are combined anyway.
Note
The aggregation only takes place if the following fields are the same for the rows: Payment type, Account Type, Account Number, Recipient Bank Account, Currency Code, Direct Debit Type, Direct Debit Sequence, Mandate ID, Date of Mandate. Lines with payment reference are always exported separately.
NCP Exports, Actions
Suggest Vendor Payments
This action determines open Vendor Ledger Entries according to your settings and inserts them in the journal to proceed the payment transaction.
For more information, see Tasks, Suggest Payments.
Suggest Customer Payments
This action determines open Customer Ledger Entries according to your settings and inserts them in the journal to proceed the payment transaction.
For more information, see Tasks, Suggest Payments.
Payment Suggestion List
Click on the action Payment Suggestion List to view the report. The payment suggestion list displays all lines waiting for payment and a summary of the amounts, grouped by bank account and message type.
Create Payment File
The action creates a payment file based on the lines in the journal.
For more information, see Tasks, Create Payment File.
Void Payment File
With this action you can void a previously created payment file. The already exported file can no longer be deleted by the application (has to be done manually), but the journal lines can now be modified and you can create a new, corrected payment file.
Payment File Test Report
You can click on the action Payment File Test Report to check with preview whether all required informations have been entered.
The report is especially helpful when you are making payments for the first time. You will then see an overview of all missing details. However, you can also try to create the payment file without this test report and correct any error messages manually.
Clearing Entries
When a payment file is created, an entry per file, with the status of the file is created in the Clearing Entry table. This action opens the overview of these entries.
For more information, see History, Clearing Entries.
Print Clearing List
Runs a report that displays detailed information about the created payment file.
Payment Statistics
This action opens a page with information about the payment file. One line is printed for each payment file created from the journal.
For more information, see Reports and Analysis, Payment Statistics.
Notification E-Mail Suggestion
The payment notification is useful to help the recipient to assign the payment(s). This is particularly true in the case of a collective transfer. Once the payment file has been created, you can send the payment notification by e-mail. Using the action Payment Notification E-mail Suggestion, a suggestion is first created. This suggestion will not be saved, but newly created each time you call the Payment Notification E-mail Suggestion.
For more information, see Tasks, Notification E-Mail Suggestion.
Print Notification
The payment notification is useful to help the recipient to assign the payment(s). This is particularly true in the case of a collective transfer. Once the payment file has been created, you can send the payment notification by e-mail. Using the action Payment Notification E-mail Suggestion, a suggestion is first created. This suggestion will not be saved, but newly created each time you call the Payment Notification E-mail Suggestion.
For more information, see Tasks, Notification E-Mail Suggestion.
Renumber Document Numbers
If you delete lines in the journal, gaps will occur in the document numbers. If this is a problem, click on the action Renumber Document Numbers. The document number is renumbered for all lines in the journal where neither Check Printed nor Payment File Created is set.
Note
Document Numbers that have been used in other suggestions are not renumbered.
Retrieve Payment File Status
With this action you can retrieve the status of a sent payment file via the konfipay Connector.
Docs / NAVAX Payment / Tasks / Exports One-Time Transfer
You can use a one-time statement to execute a bank transfer ad hoc without having to manage vendors/customers and external bank accounts. In the Journals you can define per line if it is a One-Time Transfer. To open the page One-Time Transfer click on the field One-Time Transfer (if no one-time payment has been defined yet, the value of the field is No), the page opens and you can set up the bank account for this transfer.
Field, External Bank Account
IBAN
Specifies the bank account information of the customer/vendor. Using the External Bank Account Card action in the journal pages, you can now also create a one-time payment transaction if no external bank account code is specified.
SWIFT Code
Specifies the bank account information of the customer/vendor.
Bank Branch No.
Specifies the Bank Branch No.
Bank Name
Specifies the name of the bank.
Bank Address
Specifies the address of the bank.
Bank Address 2
Specifies an addition to the address of the bank.
Bank Post Code
Specifies the post code of the bank.
Bank City
Specifies the city of the bank.
Bank Country/Region Code
Specifies the country/region code of the bank.
Fields, Recipient Data
Recipient Name
Specifies the name of the recipient.
Note
If nothing is specified, the data from vendor/customer will be written to the payment file.
Recipient Name 2
Specifies an addition to the name of the recipient.
Note
If nothing is specified, the data from vendor/customer will be written to the payment file.
Recipient Address
Specifies the address of the recipient.
Note
If nothing is specified, the data from vendor/customer will be written to the payment file.
Recipient Address 2
Specifies an addition to the address of the recipient.
Note
If nothing is specified, the data from vendor/customer will be written to the payment file.
Recipient Post Code
Spezifies the post code of the recipient.
Note
If nothing is specified, the data from vendor/customer will be written to the payment file.
Recipient City
Specifies the city of the recipient.
Note
If nothing is specified, the data from vendor/customer will be written to the payment file.
Recipient Country/Region Code
Specifies the country/region code of the recipient.
Note
If nothing is specified, the data from vendor/customer will be written to the payment file.
Actions
Suggest Data
Using the action Suggest Data, the data of the last one-time transaction (with the same account type/account number) can be suggested. The action only brings values if a Payment File has already been created for the combination of account type and account number. If, for example, a one-time payment transaction is defined for a line of the type G/L account and a payment file is created, this data can be suggested for the same G/L account in the next one-time payment transaction.
After the action Create Payment File in the Journal has been successfully completed and a Payment File is created, the page Payment File Summary opens. Here, you can see, information about the created payment file, you can see at a glance which settings used and the amount for which the file was created. In addition, you can also see how many payment notifications have been created and whether the payment notifications have all been printed or sent.
Fields
Entry No.
Views the entry number assigned to the clearing entry.
Creation Date
Views the date when the payment file was created.
Payment Type
Views the payment type of the payment file.
Bank Account No.
Views the bank account number for which the payment file was created.
File Reference (Message Reference)
Views the reference of the payment file.
Note
The reference is generated from the current date and time when the payment file is created.
Amount
Views the total of the amounts from all payment items.
Amount (LCY)
Views the total of the amounts, in local currency, from all payment items.
No. of Payment Entries
Views the number of payment entries relating to this clearing entry.
No. of Pmt. Notifications
Views the number of notifications relating to this clearing entry.
Pmt. Notifications not Printed/Sent
Views the number of printed notifications relating to this clearing entry.
No. of Bank Account Entries
Views the number of bank account entries relating to this clearing entry.
Actions
Export Payment File
With this action you can export the already created payment file. This will start the download of the file to your computer to import it into the banking software of your bank.
Show Payment File
This action can be used to show the payment file that you have created in the payment journal with the action Create Payment File in a text editor. The file cannot be edited.
Void Payment File
With this action a created Payment File can be voided. The status of the related Clearing Entry is set to Voided.
Payment Entries
Opens the overview of the Payment Entries that refer to this Clearing Entry.
For more information, see Archive, Payment Entries.
Bank Account Ledger Entries
Opens the overview of the Bank Account Ledger Entries that refer to this Clearing Entry.
For more information, see Archive, Bank Account Ledger Entries.
Clearing List
This list gives you information about the created Clearing Entry.
Suggest E-Mail Notifications
This list provides information about the created Payment Suggestion or the current situation (clearing etc.) in the journal.
Notification
A payment notification is useful (especially for collective transfers) to make it easier for the recipient to identify the payments. After the Payment File has been created, you can print the Notification or send it by e-mail.
With a payment notification, you can document which open entries you want to pay or collect in the payment file after you have created the payment file. A payment notification is useful (especially for collective transfers) to make it easier for the recipient to identify the payments.
By default, a payment notification is created if the remittance info is longer than 140 characters. In this case, a reference to the payment notification is written to the payment file.
The payment notification field is set automatically for the line.
Note
In the NCP Exports Setup, you can specify that a payment notification should always be created. You also define the payment notification texts in the setup.
For more information, see NCP Exports Setup.
Send Payment Notification E-Mail
To send a payment notification suggestion via e-mail, the following steps must be done:
Click on the action Notification E-Mail Suggestion - you will find the action in the Payment File - Summary, which opens after creating the Payment File, in the journal or in the Clearing Entries list.
Select the checkbox Include Accounts without Pmt. Notification E-Mail if you also want to include customers and vendors without payment notification e-mail in the report.
Set the required filters.
Confirm your selection with OK.
In the window that opens, the data can still be checked and adjusted if necessary. If all lines are correct, the selected payment notification can be sent using the action Send. Alternatively, with Send All the e-mails can be sent to all proposal lines.
Tip
If it is desired that some Pmt. Notifications are not sent, you can remove them from the list and then continue working with the function Send All.
Tip
If you have activated the option Edit before sending in the NCP Exports Setup in the area Pmt. Notification E-Mail, then you have the possibility to edit and format the Notification E-Mail in a text editor. This editor will appear as soon as you click on the Send action on the NCP Exports Pmt. Notification Email Suggestion page.
Print Payment Notification
To print the payment notification e-mail suggestion:
Click on the action Notification E-Mail Suggestion - you will find the action in the Payment File - Summary, which opens after creating the Payment File, in the journal or in the Clearing Entries list.
Select the checkbox Include Accounts without Pmt. Notification E-Mail if you also want to include customers and vendors without payment notification e-mail in the report.
Set the required filters.
Click the Preview button to check the result of the filtering.
Click the Print button to print the report or save it to a file.
Docs / NAVAX Payment / Tasks / Imports Working with Payment Imports
With this module you can import and process payment files provided by your bank. The following formats are supported:
camt.52
camt.53
camt.54
Custom
Data Structure
Each row in the window NAVAX Payment Imports can contain several Data entries, which in turn can contain several Transactions. The transactions, in turn, can contain several Remittance Infos. and Charges. Depending on the imported file format, different fields are filled or used.
During the transfer, for each NCP Imports Transaction a corresponding entry is created in the Journal or in the Bank Account Reconciliation.
If the field Trans. Charges in the NCP Imports Setup is set to Yes, a line is also created in the Journal or in the Bank Account Reconciliation for the total expenses per transaction.
You can either transfer the entire imported file, or individual NCP Imports Data, or just individual NCP Imports Transactions.
Note
As long as a line has not been posted, it can be deleted at any time in the General Journal or in the Reconciliation. Click on Transfer if you wish to transfer the deleted line again.
Select NAVAX Payment > Imports on the starting page of Business Central or ☰ > NAVAX Payment > Imports if you are not in the Accountant role.
Click on the action Import.
Select the file you want to import.
The import is executed. If not all bank accounts have been detected automatically, click on Data and select the Bank Account manually.
As long as there is no journal/reconciliation line for an import entry, you can still delete the line. Click Import to re-import deleted data.
Click on the action Transfer.
Open the Journal to clear open entries or the Bank Account Reconciliation to match the data with your bank account.
You can then post the imported entries.
Import payment files
To import a payment file provided by the bank
Select NAVAX Payment > Imports on the starting page of Business Central or ☰ > NAVAX Payment > Imports if you are not in the Accountant role.
Click on the action Import.
Select file you want to import.
Tip
Files can also be imported over the Dropzone for Bank Files by Drag & Drop.
For more information, see Import Tasks, Import Payment File.
The import is executed. If not all bank accounts have been detected automatically, click on Data and select the Bank Account manually.
As long as there is no journal/reconciliation line for an import entry, you can still delete the line. Click Import to re-import deleted data.
Transfer Transactions
During the transfer, for each NCP Imports Transaction a corresponding line is created in the Journal or in the Bank Account Reconciliation.
If the field Trans. Charges in the NCP Imports Setup is set to Yes, a line is also created in the Journal or in the Bank Account Reconciliation for the total of the Charges per transaction.
You can either transfer the entire imported file, or individual NCP Imports Data, or just individual NCP Imports Transactions.
Note
As long as a line has not been posted, it can be deleted at any time in the General Journal or in the Reconciliation. Click on Transfer if you wish to transfer the deleted line again.
Journal
In the Journals you can apply and closeOpen Entries on the basis of the imported data.
Once the data has been transferred, click on NCP Imports > Import Suggest Application - All Lines in the General Journal to create an automatic application suggestion.
The suggestion attempts to determine the Account No. and the corresponding open entries, based on various criteria.
The suggestion only considers lines for which no application has been defined. For lines that contain a value in the field Account No., this value is used as a filter for the entry search.
The field Import Source Code on the journal lines views if the line has been created from a transaction, from expenses, or indirectly through a bank account reconciliation line.
Click on Import Deviation - Set Filter to view only the entries that have not yet been completely cleared. Import Deviation - Remove Filter removes the filter.
For more information, see Import Tasks, Applying Open Entries.
Bank Account Reconciliation
Bank account reconciliation enables customers to reconcile their Business Central bank account with the imported statement files.
After the data has been transferred, the imported statement lines are displayed in the left part of the window. The right pane views the bank account entries.
Click on Automatic Match to perform an automatic matching of the two sides.
If there are statement lines that cannot be fully reconciled with the Bank Account Ledger Entries (automatically or manually), the reason may be that the corresponding payments have not yet been posted. Use the action Transfer to General Journal to transfer the unreconciled amount, viewed in the Difference field, to an journal for posting.
The field Import Source Code in the bank statement lines views that the line was created from a transaction or from charges.
For more information, see Import Tasks, Bank Account Reconciliation.
The import is performed and loads the file in Business Central. If not all bank accounts were determined automatically, click Data and select the Bank Account Number manually.
Note
The next time you import a file with the same criteria, the bank account will be suggested automatically.
Note
As long as there is no journal line or reconciliation line for an import line, you can delete the line. Click Import to re-import deleted data.
NCPI Dropzone for Bank Files FactBox
The settings and defaults for the Bank Files Dropzone are defined on the NAVAX Dropzone Setup page.
For more information, see Setup, Import, NAVAX Dropzone Setup.
Functionality
The functionality of the dropzone for bank files is shown by importing a camt.053 account statement file.
You can find the dropzone on the right side in the NCP Imports page, in the factbox Dropzone for Bank Files.:
Files can be imported over the Dropzone for Bank Files by Drag & Drop. NCP Imports checks the imported file whether it is a bank file (camt.052, camt.053, camt.054, mt940, etc.). This happens independently of which file type (xml, txt, etc.) is imported.
Note
It is also possible to click on the Dropzone. In this case a file selector appears where you can select a single file.
After the files have been checked and loaded by the Dropzone, it is necessary to confirm the import of files:
The added files will then appear on the left side in the NCP Imports page, as a new record:
Note
After a successful import, a new record is created for each file. The information from the imported file is written to the respective fields in the database.
You can clear and close open entries in the journals based on the imported data:
If the journal is not yet open, select NAVAX Payment > Imports on the Business Central home page or ☰ > NAVAX Payment > Imports if you are not in the Accountant role. Select the desired import line and click on Open Journals.
Click on
NCP Imports > Import Suggest Application - All Lines, to create an automatic suggested application for all lines.
NCP Imports > Import Suggest Application - Line, to create an automatic suggested application for the marked line.
The system attempts to determine the Account No. and the corresponding open entries based on various criteria.
Note
This only applies to those lines for which the Applied indicator is not set
For lines that contain a value in the field Account No. , this value is used as a filter for the entry search.
In the following sequence, the system attempts to determine a Account No. or Clearing Documents for each line:
The system checks whether a Fixed Account Allocation exists for the line.
Example
In the Fixed Account Allocation, it is defined that G/L account 241203 is used if the Remittance Info contains the word "tax office". The first line contains this account.
For more information, see Setup, Fixed Account Allocations.
Note
With G/L accounts, the description may not be written in the journal line. This is due to the setting Omit Default desc. in Jnl on the G/L account. The option specifies if the default description is automatically inserted in the Description field on journal lines created for this general ledger account.
If the Remittance Info contains a Document No. of a receivable or External Document No. of a vendor invoice, this Document No. is searched for in the database. The appropriate customer or vendor is determined and the payment is applied.
Example:: The Remittance Info of the third line contains a Document No.. Customer and document no. are assigned. The line is applied and automatically receives the indicator Applied.
If the remittance Info contains a customer/vendor number, the system searches the database for a suitable customer/vendor number. Applying with an open entry is not possible because the document number is not known.
Tip
In order to still get a suggested application, the option Keep Account Allocation can be activated in the NCP Imports Setup, so that the customer/vendor is suggested for the line, even if no document is found.
Example:
The Remittance Info of the second line contains a number that is not found in the database. However, a customer with this number could be found. The customer is assigned to the line.
Click on the NCP Imports > Import Deviation - Set Filter button to only show lines that have not yet been fully applied or that have no G/L account entered in the Account No. field.
.
Important
You can delete a line at any time if it has not yet been posted.
You must regularly reconcile your bank, receivables, and payables accounts by applying payments recorded in the bank to their related open (unpaid) invoices and credit memos or other open entries in Business Central.
You can perform this task on the Payment Reconciliation Journal page, for example, by importing a bank statement file or feed to quickly register the payments. Payments are applied to open customer or vendor ledger entries based on matches between payment text and entry information. You can review and change automatic applications before you post the journal. You can choose to close any open bank account ledger entries related to the applied ledger entries when you post the journal. The bank account is automatically reconciled when all payments are applied.
You can use the Bank Account Reconciliation to reconcile your Business Central bank account with the imported statement data:
Go to Tasks > Bank Account Reconciliation or enter the term in What do you want to do?
Create a new Bank Account Reconciliation using the + icon at the top center of the page.
Select the Bank Account Number of your own bank account.
If no number is generated automatically, enter a Statement No..
Click on Process > Suggest Lines
In the window that opens, enter the period in the field Start Date or End Date and click on OK. The imported lines are displayed on the left, the bank account ledger entries on the right.
You have the following options.
Click Match Automatically to perform an automatic match of the two sides.
Select two lines and click Match Manually to match two lines.
Click Remove Match to remove the link.
Note
If statement lines cannot be completely reconciled with the bank account ledger entries (automatically or manually), it is possible that the corresponding payments have not yet been posted. Use the function Transfer to General Journal to transfer the unreconciled amount displayed in the field Difference to a journal for posting.
Troubleshooting
Difference
Reason
Resolution
A transaction in the internal bank account is not on the bank statement.
The bank transaction did not occur although a posting was made in Business Central.
Make the missing money transaction (or prompt a debitor to make it), and then reimport the bank statement file or enter the transaction manually.
A transaction on the bank statement does not exist as a document or journal line in Business Central.
A bank transaction was made without a corresponding posting in Business Central, for example a journal line posting for an expense.
A transaction in the internal bank account corresponds to a bank transaction but some information is too different to give a match.
Information, such as the amount or the customer name, was entered differently in connection with the bank transaction or the internal posting.
Review the information, and then manually match the two. Optionally, correct the information mismatch.
You must resolve the differences, for example by creating missing entries and correcting non-matching information, or by making missing money transactions, until the bank account reconciliation is completed and posted.
You can fill in the Bank Statement Lines pane on the Bank Acc. Reconciliation page in the following ways:
Automatically, by using the Import Bank Statement function to fill in the Bank Statement Lines pane with bank transactions according to an imported file or stream provided by the bank.
Manually, by using the Suggest Lines function to fill in the Bank Statement Lines pane according to invoices in Business Central that have outstanding payments.
You can find more information at, reconcile bank accounts in the Business Central Online Help.
Fields
The table contains the following fields or columns:
Bank Account No.
Specifies the number of the bank account that you want to reconcile with the bank's statement.
Statement No.
Specifies the number of the bank account statement.
Statement Date
Specifies the date on the bank account statement.
Import Additional Info.
Specifies additional information from the NCP Imports. Click on the field to display all additional information.
Balance Last Statement
Specifies the ending balance shown on the last bank statement, which was used in the last posted bank reconciliation for this bank account.
Statement Ending Balance
Specifies the ending balance shown on the bank's statement that you want to reconcile with the bank account.
NCP Imports
This field indicates whether an import has already been performed and data are available.
Bank Statement Lines
Open Journal Lines
Specifies the number of journal lines for this bank account reconciliation.
Balance (Bank Statement Lines)
Specifies a balance, consisting of the Balance Last Statement field, plus the balance that has accumulated in the Statement Amount field.
Total Balance (Bank Statement Lines)
Specifies the accumulated balance of the bank reconciliation, which consists of the Balance Last Statement field, plus the balance in the Statement Amount field.
Total Difference (Bank Statement Lines)
Specifies the total amount of the Difference field for all the lines on the bank reconciliation.
Balance (Bank Account Ledger Entries)
Specifies the balance of the bank account since the last posting, including any amount in the Total on Outstanding Checks field.
Total on Outstanding Checks (Bank Account Ledger Entries)
Specifies the part of the bank account balance that consists of posted check ledger entries. The amount in this field is a subset of the amount in the Balance field under the right pane in the Bank Acc. Reconciliation window.
Balance To Reconcile (Bank Account Ledger Entries)
Specifies the balance of the bank account since the last posting, excluding any amount in the Total on Outstanding Checks field.
Actions, Process
Suggest Lines
Create bank account ledger entries suggestions and enter them automatically.
Import Data Card
The Data from the NCP Imports is displayed here. Each row in the NCP Imports window can contain multiple data lines, which can contain multiple Transactions. The Transactions, themselves, can contain multiple Payment Remittance Lines and Charges.
Actions, Matching
Match Automatically
Automatically search for and match bank statement lines.
Match Manually
Manually match selected lines in both panes to link each bank statement line to one or more related bank account ledger entries.
Remove Match
Remove selection of matched bank statement lines.
Import Fixed Account Allocations
If the applied amount should always assign certain transactions to a fixed G/L account, customer, vendor or bank account, you can set up fixed account allocations. Fixed account allocations are generally managed or created in the Payment Import Setup window, but can also be configured via the journal or bank account reconciliation.
For more information, see Setup, Imports, Fixed Account Allocations.
Actions, Posting
Transfer to General Journal
Transfer the lines from the current window to the general journal.
Post
Finalize the document or journal by posting the amounts and quantities to the related accounts in your company books.
Post & Print
Finalize and prepare to print the document or journal. The values and quantities are posted to the related accounts. A report request window where you can specify what to include on the print-out.
The description on this help page applies to the Cash Receipt- and the Payment Journal and explains the extensions that NAVAX Payment Imports provides.
Fields
The table contains the following fields or columns from NAVAX Payment Imports:
NCP Imports Source Type
Specifies the source from where the record was created either from a transaction, charges, or indirectly through a bank account reconciliation line.
NCP Imports Order Amount
Specifies the order amount of the transaction from the NAVAX Payment Imports.
NCP Imports Order ISO Currency Code
Specifies the ISO currency code for the order amount of the transaction from NAVAX Payment Imports.
NCP Imports Transaction Amount
Specifies the posting amount of the transaction from the NAVAX Payment Imports.
NCP Imports Transaction ISO Currency Code
Specifies the ISO currency code for the posting amount of the transaction from the NAVAX Payment Imports.
NCP Imports Payment Reference
Specifies the payment reference from the NAVAX Payment Imports.
NCP Imports Remittance Info.
Specifies the remittance info from the NAVAX Payment Imports. Depending on the data format imported or how the remittance info was formatted in the imported file, only a part of the remittance info is displayed in this here. Click the field to display the full remittance info.
NCP Imports Additional Info.
Displays additional information from the NAVAX Payment Imports. Click on the field to display the full additional information.
Aktions, NCP Imports
Import Suggest Application - All Lines
Use this function to create balance suggestions for all lines in this journal that have not been balanced already.
If the option Display analysis window is set in the NCP Imports Setup, a page with the information of the preselection is displayed. If the window is closed with OK, the suggestion is copied to the journal.
Note
It is generally recommended to activate the window for analysis tasks.
The reason for this is that at the time of confirmation with OK it is no longer possible to guarantee that all entries are still available and open for balancing. An error message or a notice may be shown that another user has changed data or that balancing can no longer set.
Imports Suggest Application - Line
Use this function to suggest a application for the selected line.
If the option >Display analysis window is set in the NCP Imports Setup, a page with the information of the preselection is displayed. If the window is closed with OK, the suggestion is copied to the journal.
Note
It is generally recommended to activate the window for analysis tasks.
The reason for this is that at the time of confirmation with OK it is no longer possible to guarantee that all entries are still available and open for balancing. An error message or a notice may be shown that another user has changed data or that balancing can no longer set.
Imports Fixed Account Allocations
If the balance suggestion should always assign specific transactions to a fixed G/L account, customer, vendor or bank account, you can set up fixed account allocations for this. Fixed account allocations are maintained or created in the NCP Imports Setup window, but can also be accessed via the journal or bank account reconciliation.
Imports Deviation - Set Filter
This action sets filters on the journal lines for which full adjustment is not possible.
Imports Deviation - Remove Filter
This action deletes the filters on the journal lines for which full adjustment is not possible.
Imports Deviation - Print
This list will show all journal lines for which the allocations has not been completely set.
Imports Transaction Card
Opens the import transaction card in which all important information about the Transaction from the NCP Imports is clearly displayed.
Docs / NAVAX Payment / Tasks / Pay With QR Code Create invoices for paying by QR code
The NAVAX Payment has been extended with the functionality Pay with QR Code, NCP Pay with QR Code generates a standardized QR code, also called EPC QR Code, which can be scanned by many banking apps, enabling it to automatically fill in payment details such as recipient, amount, IBAN, BIC and the remittance info. This QR code created by NCP Pay with QR Code can then be placed on your invoices. This saves the customer the tedious task of typing in the data, and also means that they do not run the risk of entering incorrect data.
You can provide a convenient transition between the analog paper world and the digital world. Use cases are diverse and should always provide the user with an advantage through smartphone scanning. Austrian banks have agreed on a standard to reflect electronic payments by a QR code. This saves your customers from typing IBANs and captures the payment directly in their e-banking app! At the same time, you generate the payment with the information you want to automatically assign to open invoices. NAVAX Payment has this functionality built into Microsoft Business Central when creating invoices!
The following section explains the functionality for creating invoices (sales invoices) that provide a QR code, for payment via e-banking, on the invoice printout.
Before this functionality can be used, some setup steps are required, For more information, see Setup, Paying with QR Code..
Below you will find instructions on how to do this.
Creating an invoice for paying with QR code
.
Create an invoice, either a sales invoice or a service invoice
.
Select the customer for which the invoice should be created
.
Check the Payment Method, this must have the NCP Pay with QR-Code flag enabled. If there is no payment form yet, create one.
For more information, see Setup, Pay with QR Code. section Setup a Payment Method for Pay with QR Code.
You can specify which of your bank accounts to use for generating the Pay with QR Code code, to do this select the desired account in the Company Bank Account Code field.
Tip
You can also store a bank account to be used by default for QR code creation, to do this go to the Bank Account Setup and specify a bank account by activating the Bank Account for Pay with QR Code box.
It is recommended to fill one of the fields Your Reference or External Document Number to be able to create a unique reference for the QR code. Using this QR code, you can then assign the payments to the customer ledger entries. NAVAX Payment Imports can help you do this.
For more information, see Setup, Pay with QR Code.
.
Post the invoice. If Pay with QR code active in the QR Code Setup is enabled, a QR code document data entry will be created and the generated reference will be written to the customer ledger entry.
It is possible to configure the generation of the reference text according to your requirements, For more information, see Setup, Pay with QR Code.
.
Docs / NAVAX Payment / Reports and Analysis Payment Statistics
This page views a line for each Payment File that was created from the journal.
Fields, General
Credit Transfer (LCY)
Views the credit transfer amount in local currency.
Direct Debit (LCY)
Views the direct debit amount in local currency.
Total Payments (LCY)
Views the total amount of payment transactions in local currency.
Other (LCY)
Views all other amounts in local currency.
Total (LCY)
Views the total amount in in local currency.
Fields, Details
Payment Type
Views the payment type used in the transaction.
Bank Account No.
Views the bank account number for which the payment file was created.
Currency Code
Views the currency for which the payment file was created.
Amount
View the total amount per payment type.
Amount (LCY)
View the total amount, in local currency, per payment type.
Docs / NAVAX Payment / Reports and Analysis Importlist
Print
Additional Info.
Specifies if additional informations in the list should also be printed.
Transaction Description
Specifies if transaction descriptions in the list should also be printed.
Return Reason
Specifies if return reasons in the list should also be printed.
Payment Reference
Specifies if payment references in the list should also be printed.
External Account Holder
Specifies if the external bank account holder in the list should also be printed.
Order Amount Deviation
Specifies if order amount deviations in the list should also be printed.
Charges
Specifies if charges in the list should also be printed.
Remittance Info.
Specifies if remittance informations in the list should also be printed.
If the indicator Show Analysis Window is set in the NCP Imports Setup, the system does not carry out a comparison of the Remittance Info when you execute the function Apply Entries in the journal. Instead, this window shows how the application is performed.
Important
Use this indicator for information purposes only (analysis). To perform and post a application, this indicator must be deactivated.
.
Fields
Position ID
Used to identify the line. Position IDs are used in the Delete Reason field to indicate conflicts or reasons that are related to other lines.
Line Information
Views information about this record.
Account Type
Views the account type.
Account No.
displays the account number.
Ledger Entry No.
Views the ledger entry number of the current allocation entry.
Deleted
Shows that no allocation was created.
Delete Reason (no assignment)
Shows the reason why no assignment was made.
Posting Date
Shows the posting date.
Amount
Shows the amount.
Remaining Amount
Shows the remaining amount.
Search Parameter
Shows the search parameter.
Amount Rating
Shows the rating used to search for the amount.
Payment Reference
Shows the payment reference found of the transaction.
Payment Reference Entry
Shows the payment reference found.
Remittance Info
Shows the payment remittance info found of the transaction.
Document Search for
Shows which value was searched for.
Document Found in
Shows where the searched value was found.
Document Rating
The rating for the search for the document number.
Account Search or
Shows which value was searched for.
account Found in
Shows where the searched value was found.
External IBAN (Account Number)
Shows the IBAN or account number of the transaction.
External SWIFT Code (BLZ)
Shows the SWIFT code or BLZ of the transaction.
External Account Holder
Shows the name of the account holder of the transaction.
Ext. Account Info found
Shows whether a bank account was found based on the account information of the transaction.
Account Info fount in Payment Reference
Shows that an account was found based on the payment reference of the transaction.
Account Info found in Remittance Info
Shows that an account was found based on the remittance info of the transaction.
Account Rating
Shows the rating for the search for the amount.
Rating
Shows the total rating for the assignment.
Actions
Transaction Card
Opens the import transaction card in which all important information about the Transaction from the NCP Imports is clearly displayed.
For more information, see Tasks, Imports, Working with Payment Imports.
Account Card
View or change detailed information about the record on the document or journal line.
Actions, Navigate
Fixed Account Allocations
If the applying suggestion should always assign certain transactions to a fixed G/L account, customer, vendor or bank account, you can set up fixed account allocations for this.
For more information, see Setup, Imports, Fixed Account Allocations.
Docs / NAVAX Payment / Reports and Analysis Import General Journal Deviation
Options
Include Lines without Deviation
Specifies if also lines without deviation should be printed in the report.
Docs / NAVAX Payment / Archive Vendor/Customer and Bank Ledger Entries
On the pages Vendor- and Customer-Ledger Entries the following NAVAX Payment fields are added:
Fields
Payment Reference
Specifies a payment reference which is suggested for the payment suggestion in the payment journal. You can change or delete the contents of the field.
Bank Account Ledger Entries
When you post the journal after checking the payments, a Bank Account Ledger Entry will be created. Using the action Bank Account Ledger Entries on the page Clearing Entries you can view this entry.
The page has been extended with the following NAVAX Payment Exports functions and fields:
Bank Account Ledger Entries, Fields
NCP No. of Payment Entries
Number of payment entries relating to this bank account ledger entry are listet here.
Bank Account Ledger Entries, Actions
Payment Entries
Opens the overview of the Payment Entries with reference to this Bank Account Ledger Entry.
For more information, see Archive, Payment Entries.
Clearing Entries
Opens the overview of the Clearing Entries with reference to this Bank Account Ledger Entry.
For more information, see Archive, Clearing Entries.
Docs / NAVAX Payment / Archive Clearing Entries
In the window NCP Clearing Entries the history of all created payment files are listed.
The action Create Payment File in the payment journals and cash recipient journals creates a Clearing Entry with status Created, which contains information about the file. Additionally, a Payment Entry is created for each individual transaction.
For more information, see Appendix, Data Structure.
If the journal is posted, the status is set to Posted and the corresponding bank account ledger entry can be displayed using the action Bank Account Ledger Entries.
If the file is cancelled, the status is set to Cancelled.
Fields
Status
Shows the status for the Clearing Entry.
Options:
Created - Indicates that the payment file was created.
Voided - Indicates that the payment file was canceled.
Posted - Indicates that the journal was posted.
Payment Type
Shows the payment type of the payment type.
Bank Account No.
View the bank account number for which the payment file was created.
Archived Payment File exists
Specifies if an archived payment file is available.
Creation Date
View the date when the payment file was created.
No. of Payment Entries
Number of all Payment Entries that refer to this Clearing Entries.
No. of Pmnt. Notifications
Number of all payment notification e-mails that refer to this Clearing Entries.
Pmt. Notifications not Printed/Sent
Views how many Payment Notifications remain to be printed or sent by e-mail.
No. of Bank Account Ledger Entries
Shows the number of Bank Account Ledger Entries that refere to this Clearing Entry
Amount
Shows the total amount from the Payment Entries that refer to this Clearing Entry.
Amount (LCY)
Shows the total amount in local currency from the Payment Entries that refer to this Clearing Entry.
File Reference (Message Reference)
View the reference of the payment file. The reference is generated from the current date and time when the payment file is created.
konfipay Payment Status
Shows the status of the payment file that has been sent to konfipay. Use Lookup to go to the NAVAX konfipay Connector Payment File Status entry where more detailed information is available.
Pmnt. Status Entry No.
Specifies the value of the Payment Status Entry No. field.
Entry No.
Views the entry number assigned to the Clearing Entry. The application assigns a unique number to each Clearing Entry.
Actions, Payment File
Export Payment File
The action Create Payment File in the payment journal creates a Payment File and a Clearing Entry with status Created, which contains information about the file. With the action Export payment File, this Payment File can be exported at a later time.
In the summary, all information on the created clearing item is displayed. The payment file can be made available for the bank software via Export payment file. The payment file can also be exported at a later time from the Clearing Entries.
For more information, see Tasks, Exports, Create Payment File.
Show Payment File
This action can be used to show the payment file that you have created in the payment journal with the action Create Payment File in a text editor. The file cannot be edited.
Void Payment File
With this action a created Payment File can be voided. The status of the related Clearing Entries is set to Voided.
Send Payment File
With this action, you can send the payment file that you created before via Create Payment File. The payment file will be send to konfipay which will check and transmit the file to the bank.
Check Payment Status
With this action, you can retrieve the status of a sent payment file.
Actions, Reports
Clearing List
This List contains information about the Clearing Entries.
Actions, Notification
Notification E-Mail Suggestion
This list shows information on the payment suggestion created, or the current situation (clearing etc.) in the journal page.
Notification
The payment notification is useful to help the recipient to assign the payment(s). This is especially important in the case of a Collective Transfer. It is also possible to send this notification by e-mail. After the payment file has been created, you can print the Notification or send it by e-mail.
Actions, Entry
Payment Entries
Opens the list of Payment Entries that refers to this Clearing Entry.
For more information, see Archive, Payment Entries.
Bank Account Ledger Entries
Opens the overview of the Bank Account Ledger Entries that refer to this Clearing Entry.
Payment Status Entries
The action opens the overview of payment status entries for this bank account.
Docs / NAVAX Payment / Archive Payment Entries
The action Create Payment File in the Payment Journals creates a NCP Clearing Entry with status Created, which contains information about the payment file.
Furthermore, a Payment Entry is created for each individual transaction.
For more information, see Appendix, Data Structure.
If the journal is posted, the status is set to Posted and the corresponding bank account ledger entry can be displayed using the action Bank Account Ledger Entries.
If the file is cancelled, the status is set to Cancelled.
Fields
Status
Shows the status for the payment entry.
Options:
Created - Indicates that the payment file was created.
Voided - Indicates that the payment file was canceled.
Posted - Indicates that the journal was posted.
Payment Type
Views the payment type of the created payment file.
Bank Account No.
View the bank account number for which the payment file was created.
No. of Payment Posting Entries
Shows the number of payment posting entries for the current payment entry.
Posted with Document No.
Shows the first value of the payment posting entries.
Note
If Navigate is called directly from the payment entry and there are several payment posting entries for the payment entry, Navigate is called with the first data record found.
Posted with Posting Date
Shows the first value of the payment posting entries.
Note
If Navigate is called directly from the payment entry and there are several payment posting entries for the payment entry, Navigate is called with the first data record found.
No. of Bank Account Entries
Views the number of Bank Account Ledger Entries for the current entry.
Description
View the description from the journal.
Execution Date
Views the desired execution date for the transaction.
Urgent Payment
Views information indicating whether the payment file was created with the Urgent Payment option.
Pmt. Notification
After a payment file has been created, this field views if a payment notification exists for the NCP Payment Entry.
If the Payment Remittance cannot be transferred completely when the payment file is created, a payment notification is created. You can also use additional parameters to set up the system to create a payment notification every time you create a payment file.
Note
The payment notification is useful to help the recipient to assign the payment(s). This is particularly relevant in the case of a collective transfer. It is possible to send the payment notification via e-mail.
Payment Notification No.
After a payment file has been created, the number of the payment notifications is displayed in this field, in case a payment notification exists for the created Payment Entry.
Pmt. Notification Printed
Views that a payment notification is printed.
Pmt. Notification E-Mail Sent
Shows that the notification was sent by e-mail
Pmt. Notification E-Mail Sent To
Shows the recipient E-Mail address of the notification e-mail.
Pmt. Notification E-Mail Date
Shows when the notification was sent by e-mail.
Pmt. Notification E-Mail Time
Shows when the notification was sent by e-mail.
No. of Payment Remittance Entries
Shows the number of Payment Remittance Entries for the current entry.
Currency Code
Views the currency code of the transaction.
Amount
Shows the amount for the transaction.
Amount (LCY)
Shows the amount for the transaction in LCY.
Account Type
Shows the type of account for the transaction.
Options:
Customer
Vendor
Bank Account
Account No.
Shows the account number used for the transaction.
External Bank Account Code
Shows which bank account of customer/vendor is used for the transaction.
One-Time Transfer
Indicate that the payment entry was a one-time transfer.
External IBAN
Shows the IBAN used by the customer/vendor.
External SWIFT Code
Shows the SWIFT-Code used by the customer/vendor.
External Bank Account No.
Shows the bank account of customer/vendor used for the transaction.
External Bank Branch No.
Shows the Bank Branch No. used by the customer/vendor.
Direct Debit Type
Shows which settings for the direct debit type were used to create the payment file.
Direct Debit Sequence
Shows which settings for the direct debit type were used to create the payment file.
Das Feld Spesen ist nur dann verfügbar, wenn die Zahlungsart und/oder das XML-Schema des Bankkontos Spesen unterstützt.
For more information, see Setup, Exports, XML Schemas.
Actions
Navigate
Sucht alle Posten und Belege, die für die Belegnummer und das Buchungsdatum laut dem ausgewählten Posten oder Beleg vorhanden sind.
Payment Remittance Entries
Opens the overview of the Payment Remittance Entries with reference to this NCP Payment Entry.
Bank Account Ledger Entries
Opens the overview of all Bank Account Ledger Entries with reference to this NCP Payment Entry.
Clearing Entries
Opens the overview of the NCP Clearing Entries with reference to this NCP Payment Entry.
For more information, see Archive, Clearing Entries.
Payment Remittance Entries
The action Create Payment File in the payment journals creates a Clearing Entry with status Created. This entry contains information about the file. In addition, a Payment Entry and a Payment Remittance Entry are created for every single transaction. These contain information about which entries were cleared by the payment.
Payment Remittance Entries, Fields
Document Type
Views the document type of the remittance entry.
Document No.
Views the document number ot the remittance entry.
Posting Date
Date on which the document was posted.
External Document No.
Specifies an additional document number. This usually refers to the numbering system by the customer or vendor.
Remittance Info.
Views the remittance info (which was stored in the NCP Exports Setup).
Currency Code
Views the currency code used when posting the entry.
Amount
Views the posted amount for the entry.
Discount
Views the discount of the entry that has been discounted.
Entry No.
Views the entry number that was assigned to the payment remittance entry. The application assigns a unique number to each payment remittance entry.
Payment Remittance Entries, Actions
Navigate
Finds all entries and documents that exist for the document number and posting date of the selected entry or document.
Docs / NAVAX Payment / Archive Payment Status Entries
After a payment file is created, it can be directly transmitted to the bank using the konfipay Connector Export extension. During this process, a payment status entry is created to reflect the status from konfipay in Business Central.
Since there can often be delays in status feedback, it is necessary to regularly update these payment status entries to keep the status synchronized. To address this, NAVAX Payment has introduced the capability to use an automatically configured job queue that updates the status of open and pending payment status entries.
Important
For some German banks, the status feedback can take up to 14 business days. Therefore, please note that some payment status entries may remain open for a longer period.
Page Payment Status Entries
Fields
Status
Shows the processing status of the file.
Status values with the prefix KON specify the status of the file within konfipay.
Status values with the prefix FIN represent the status of the file within the financial institution.
Bank Account No.
Specifies the bank account number for which the payment file was created.
Bank Account Name
Specifies the name of the bank account for which the payment file was created.
Type
Shows what type of payment file it is.
Possible values:
pain - SEPA payment order file (ISO pain format)
dtazv - Foreign trade payment file (DTAZV format)
OpenField
Specifies whether the payment status entry has been completed or not.
Note
If the payment status entry has already been completed, the job queue to retrieve the status will no longer take this entry into account.
Pending
Specifies whether the payment status entry is in pending status or not.
Note
If the payment status entry is set to pending, the job queue to retrieve the status will consider this entry.
Cancelled
Specifies whether the payment status entry is cancelled or not.
Note
If the payment status entry has been cancelled, the job queue to retrieve the status will no longer consider this entry.
Order Id. Fin. Institute
Shows the Order number assigned by the financial institution to the file.
This element is only available if the file possesses one of the following status values:
FIN_UPLOAD_SUCCEEDED
FIN_VEU_FORWARDED
FIN_VEU_CANCELED
FIN_ACCEPTED
FIN_CONFIRMED
FIN_PARTIALLY_ACCEPTED
FIN_REJECTED
Last Sync on
Shows the Date when the payment file was saved in konfipay.
Last Sync at
Shows the Time when the payment file was saved in konfipay.
Reason Code
Shows the ISO reason code that further describes the processing status of the file within the financial institution.
This element is only available if the file possesses one of the following status values:
FIN_VEU_FORWARDED
FIN_VEU_CANCELED
FIN_ACCEPTED
FIN_PARTIALLY_ACCEPTED
FIN_REJECTED
Uploaded Fin. Inst. on
Shows the date of the successful transmission of the file to the financial institution.
This element is only available if the file possesses one of the following status values:
FIN_UPLOAD_SUCCEEDED
FIN_VEU_FORWARDED
FIN_VEU_CANCELED
FIN_ACCEPTED
FIN_CONFIRMED
FIN_PARTIALLY_ACCEPTED
FIN_REJECTED
Uploaded Fin. Inst. at
Shows the time of the successful transmission of the file to the financial institution.
This element is only available if the file possesses one of the following status values:
FIN_UPLOAD_SUCCEEDED
FIN_VEU_FORWARDED
FIN_VEU_CANCELED
FIN_ACCEPTED
FIN_CONFIRMED
FIN_PARTIALLY_ACCEPTED
FIN_REJECTED
Error Code
Shows the error code for clear identification of the error that has occurred.
Structure of the error codes: ERR-{Category}-{Number}
ERR - Fixed prefix for all error codes
{Category} - Category of the error
{Number} - Number of the error
The number is unique within its category.
For more information, see Appendix, Possible Error messages konfipay.
Error Message
Show the textual description of the error.
Error Message on
Shows the date of the occurrence of the error.
Error Message at
Shows the time of the occurrence of the error.
Clearing Entry No.
Shows the entry number of the related clearing entry.
Entry No.
Specifies the entry number assigned to the NAVAX konfipay Connector Payment File Status entry.
Page Payment Status Entry Card
On the page Payment Status Entry Card, more detailed data about the selected Payment Status Entry can be viewed.
General, Fields
Clearing Entry No.
Shows the entry number of the related clearing entry.
Type
Shows what type of payment file it is.
Possible values:
pain - SEPA payment order file (ISO pain format)
dtazv - Foreign trade payment file (DTAZV format)
Bank Account No.
Specifies the bank account number for which the payment file was created.
Bank Account Name
Specifies the name of the bank account for which the payment file was created.
Processing Status, Fields
OpenField
Specifies whether the payment status entry has been completed or not.
Note
If the payment status entry has already been completed, the job queue to retrieve the status will no longer take this entry into account.
Pending
Specifies whether the payment status entry is in pending status or not.
Note
If the payment status entry is set to pending, the job queue to retrieve the status will consider this entry.
Cancelled
Specifies whether the payment status entry is cancelled or not.
Note
If the payment status entry has been cancelled, the job queue to retrieve the status will no longer consider this entry.
Status
Shows the processing status of the file.
Status values with the prefix KON specify the status of the file within konfipay.
Status values with the prefix FIN represent the status of the file within the financial institution.
Last Sync on
Shows the Date when the payment file was saved in konfipay.
Last Sync at
Shows the Time when the payment file was saved in konfipay.
Information, Fields
Order Id. Fin. Institute
Shows the Order number assigned by the financial institution to the file.
This element is only available if the file possesses one of the following status values:
FIN_UPLOAD_SUCCEEDED
FIN_VEU_FORWARDED
FIN_VEU_CANCELED
FIN_ACCEPTED
FIN_CONFIRMED
FIN_PARTIALLY_ACCEPTED
FIN_REJECTED
Reason Code
Shows the ISO reason code that further describes the processing status of the file within the financial institution.
This element is only available if the file possesses one of the following status values:
FIN_VEU_FORWARDED
FIN_VEU_CANCELED
FIN_ACCEPTED
FIN_PARTIALLY_ACCEPTED
FIN_REJECTED
Additional Information
Shows additional information about the status of file within the financial institution as free text.
Uploaded Fin. Inst. on
Shows the date of the successful transmission of the file to the financial institution.
This element is only available if the file possesses one of the following status values:
FIN_UPLOAD_SUCCEEDED
FIN_VEU_FORWARDED
FIN_VEU_CANCELED
FIN_ACCEPTED
FIN_CONFIRMED
FIN_PARTIALLY_ACCEPTED
FIN_REJECTED
Uploaded Fin. Inst. at
Shows the time of the successful transmission of the file to the financial institution.
This element is only available if the file possesses one of the following status values:
FIN_UPLOAD_SUCCEEDED
FIN_VEU_FORWARDED
FIN_VEU_CANCELED
FIN_ACCEPTED
FIN_CONFIRMED
FIN_PARTIALLY_ACCEPTED
FIN_REJECTED
Error, Fields
Error Code
Shows the error code for clear identification of the error that has occurred.
Structure of the error codes: ERR-{Category}-{Number}
ERR - Fixed prefix for all error codes
{Category} - Category of the error
{Number} - Number of the error
The number is unique within its category.
For more information, see Appendix, Possible Error messages konfipay.
Error Message
Show the textual description of the error.
Error Message on
Shows the date of the occurrence of the error.
Error Message at
Shows the time of the occurrence of the error.
Actions
Update Payment Status
This action is used to update the status of the selected data record.
Show Payment File
This action shows the payment file sent to konfipay.
Cancel Processing
This action can be used to cancel the processing of incorrectly sent payment files. This is possible as long as the payment file has not yet been validated by the financial institution or has already been accepted.
Docs / NAVAX Payment / Archive Imports
On this page you can see the overview of the imported bank files. For each of the imported files a Import line is created, these in turn can have several transaction lines and remittance info lines.
Depending on the imported file format, different fields are populated or used.
For more information, see Appendix, Data Structure.
Note
As long as a row has not been posted yet, you can delete it in the journal or reconciliation at any time. Click Transfer if you want to retransfer the deleted line.
In the NCP Imports window you can perform the following actions:
Import a payment file into Dynamics 365 Business Central and transfer it to a journal.
For more information, see Tasks, Imports, Import Payment File.
Shows you if an archived import file already exists.
No. of Data
Shows the number of imported data entries.
No. of Data without Bank Allocation
Shows the amount of data without bank assignment.
Note
If the bank allocation does not match during import, the bank allocation can be entered manually.
To do this, open the NCP Imports Data either by clicking in the field or by selecting the action Navigate > Data.
Bank Account No.
If the NCP Imports data all have the same bank account, the bank account number is displayed here. If the accounts are different, no value is displayed.
Note
If a bank account is detected when importing a payment file, the system first checks whether fixed account allocations exist.
Bank Account Name
If the NCP Imports data all have the same bank account, the bank account name is displayed here. If the accounts are different, no value is displayed.
Bank Account IBAN
If the NCP Imports data all have the same bank account, the bank account name is displayed here. If the accounts are different, no value is displayed.
No. of Transactions
Shows the number of imported transactions.
Open Journal Lines
Shows if data has been transferred to an general journal and if there are open general journal lines.
Note
Depending on the setting used in the NCP Imports Setup, under the respective file format setting, this field may or may not be displayed.
Shows when the file was created (File info: CreDtTm).
Message Time
Shows when the file was created (File info: CreDtTm).
Message Recipient Name
Shows the name of the recipient of the file (file info: MsgRcpt Nm).
Additional Info.
Shows additional information (file info: AddtlInf).
Entry No.
Specifies the number of the entry that was assigned to it when it was created from the specified number series.
Actions, Process
Import
Click Import to import the file provided by your bank. As long as there are no journal lines or reconciliations for the imported entry, the line can be deleted at any time.
Click on Import if you want to re-import the deleted data.
For more information, see Tasks, Imports, Working with Payment Imports.
Export Archived Import File
Starts the download of the archived import file.
Actions, Transfer
Transfer
With this option, entries from the NCP Imports can be transferred to a journal. During the transfer, a corresponding entry is created for each NCP Imports transaction in the Journal or in the Bank Account Reconciliation. If the field Trans. Charges is set to Yes in the NCP Imports Setup, an entry is also created for the total charges per transaction. You can either transfer the entire imported file, or individual NCP Imports Data, or just individual NCP Imports Transactions.
For more information, see Tasks, Imports, Working with Payment Imports.
Actions, Report
Import List
This list shows information about the imported file.
Actions, Navigate
Data
Here the Data from the NCP Imports are listed. Each line in the NCP Imports window can contain several data lines, which in turn can contain several transactions. The transactions, in turn, can contain several remittance lines and charges.
Transactions
Here the Transactions from the NCP Imports are listed. Each line in the NCP Imports window can contain several data lines, which in turn can contain several transactions. The transactions, in turn, can contain several remittance lines and charges.
Open Reconciliations
Shows the list with Open Reconciliations if such exist. In the lines you can see the number of open reconciliations in the field Open Reconciliation Lines.
Note
This action is only available if the option Bank Acc. Reconciliation has been set up in the NCP Imports Setup, in the field camt.053 - Statement or MT940 - Account Statement.
Open Journal Lines
Opens the open journal lines. In the journal it is possible to clear and close open entries based on the imported data.
Note
This action is only available if the option General Journal has been set up in the NCP Imports Setup, in the field camt.053 - Statement or MT940 - Account Statement.
Posted Statement
In this overview, the posted statements are listed.
Note
This action is only available if the option Bank Acc. Reconciliation has been set in the NCP Imports Setup, in the fields camt.053 - Account Statement, camt.054 - Debit Credit Notification, MT940 - Account Statement or Custom.
Additional Info.
Opens the card with the additional information from the Group Header (GrpHdr) of the import.
Import Data
On this page you can see the overview of the data entries of the imported bank file. Depending on the imported file format, different fields are filled or used.
Note
As long as a row has not been posted yet, you can delete it in the journal or reconciliation at any time. Click on Transfer if you want to retransfer the deleted row.
Fields
Statement No.
Shows the bank statement number (file info: LglSeqNb).
The lookup function opens the NCP Imports Data Card page, this provides a better overview of the bank statement.
Statement Date
Shows the date of the bank statement (file info: CreDtTm).
Statement from
Shows the statement period (file info: FrToDt FrDtTm).
Statement to
Shows the statement period (file info: FrToDt FrDtTm).
Bank Account No.
The import tries to determine a bank account for each data row based on various criteria. If not all bank accounts were suggested automatically, select the bank account number manually. The next time you import a file with the same criteria, the bank account is suggested.
Bank Account Name
If the NCP Imports data all have the same bank account, the bank account name is displayed here. If the accounts are different, no value is displayed.
Bank Account IBAN
If the NCP Imports data all have the same bank account, the IBAN is displayed here. If the accounts are different, no value is displayed.
No. of Balances
Shows the number of imported balances in the bank statement.
The lookup function opens the NCPI Payment Import Balances page.
No. of Transactions
Specifies the number of imported transactions.
The Lookup function opens the NCPI Payment Import Transactions page.
Open Journal Lines
Shows that data has been transferred to a journal and that there are open journal lines.
The lookup function opens the corresponding journal.
Note
Depending on the setting used in the NCP Imports Setup, under the respective file format setting, this field may or may not be shown.
Shows if data has been transferred to a bank account reconciliation and open reconciliations exist.
The lookup function opens the corresponding reconciliation.
Note
Depending on the setting used in the NCP Imports Setup, under the respective file format setting, this field may or may not be shown.
Shows the IBAN or account number of the imported data (file info: Acct Id IBAN (Acct Id Othr Id)).
SWIFT-Code (Bank Branch No.)
Shows the SWIFT code or the bank branch code of the imported data (file info: Acct Svcr FinInstnId BIC (Acct Svcr FinInstnId Othr Id)).
ISO Bank Currency Code
Shows the ISO bank currency code of the imported data (file info: Acct Ccy).
Additional Information
Shows additional information of the bank statement (file info: AddtlInf).
The lookup function opens the NCP Imports Additional Information page.
Closing Booked last Statement
Shows the closing balance of the last booked account statement.
Sum Transaction Amount
Shows the total of the booking amounts from the imported bank file.
Closing Booked
Shows the current closing balance, reduced by the booking amounts from the imported bank file.
Entry No.
Shows the number assigned to the record. The application assigns a unique number to each record.
Import Entry No.
This field contains the number of the import.
Import Data, Actions
Suggest Bank Account
This function can help to suggest already used bank accounts.
Transfer
With this option, entries from the NCP Imports can be transferred to a journal. During the transfer, a corresponding entry is created for each NCP Imports Transaction in the Journal or in the Bank Account Reconciliation. If the field Trans. Charges is set to Yes in the NCP Imports Setup, an entry is also created for the total charges per transaction. You can either transfer the entire imported file, or individual NCP Imports Data, or just individual NCP Imports Transactions.
For more information, see Tasks, Imports, Working with Payment Imports.
Balances
The balances from the NCP Imports are listed here.
Transactions
The transactions from the NCP Imports are listed here. Each row in the NCP Imports window can contain multiple data rows, which in turn can contain multiple transactions. The transactions, in turn, can contain multiple payment remittance entries and expenses.
Additional Info.
Öffnet die Karte mit den Zusatzinformationen aus dem Group Header (GrpHdr) des Imports.
Open Reconciliations
This action opens the page Bank Account Reconciliations, where the transferred entries from import are listed, if any exist.
Posted Statements
This action opens the page Bank Account Statement that shows the posted statements that previously was imported and posted.
Import Balances
This page views the balances from the NCP Imports.
Import Balances, Fields
Type
Shows the type of balance (file info: Tp CdOrPrtry Cd).
Amount
Shows the amount (file info: Amt).
ISO Currency Code
Shows the ISO Currency Code of the balance (file info: Ccy)
Positive
Shows whether the balance is positive or negative (file info: CdtDbtInd).
Date
Shows the date of the balance (file info: Dt Dt).
Import Transactions
The Import Transactions page lists the transaction of the imported bank file.
Fields
External Account Holder
Shows the name of the account holder of the imported transaction (file info: RltdPties Dbtr Nm/RltdPties Cdtr Nm).
External Account Holder Address
Shows the address of the account holder of the imported transaction (file info: RltdPties Dbtr PstlAdr AdrLine/RltdPties Cdtr PstlAdr AdrLine).
External IBAN (Bank Account No.)
Shows the IBAN or account number of the imported transaction (file info: RltdPties DbtrAcct Id IBAN/RltdPties CdtrAcct Id IBAN (RltdPties DbtrAcct Id Othr Id/RltdPties CdtrAcct Id Othr Id)).
External SWIFT-Code (Bank Branch No.)
Shows the SWIFT code or bank branch no. of the imported transaction (file info: RltdAgts DbtrAgt FinInstnId BIC/RltdAgts CdtrAgt FinInstnId BIC (RltdAgts DbtrAgt FinInstnId Othr Id/RltdAgts CdtrAgt FinInstnId Othr Id)).
Order Amount
Shows the order amount of the imported transaction (file info: AmtDtls InstdAmt Amt).
Order ISO Currency Code
Shows the ISO currency code of the order amount of the imported transaction (file info: AmtDtls InstdAmt Ccy).
Currency Factor
Shows the currency factor of the imported transaction. When the transaction entry is transferred to an journal, the amount of the order is converted with the currency factor in case of foreign currency (file Info: Ccy/AmtDtls TxAmt CcyXchg XchgRate).
Positive
Shows if the imported transaction is positive or negative (file info: CdtDbtInd).
Reversal Posting
Specifies if the imported transaction is a chargeback (return-credit/direct debit and reversal) (file info: RvslInd).
Posting Status
Shows the posting status of the transaction (file info: Sts).
Posting Date
Shows the posting date of the imported transaction (file info: BookgDt Dt).
Note
Depending on the settings used in the NCP Imports Setup, under Transfer, this field is filled with the appropriate values
For more information, see Setup, Imports, Imports Setup.
Value Date
Shows the value date of the imported transaction (file info: ValDt Dt).
Note
Depending on the settings used in the NCP Imports Setup, under Transfer, this field is filled with the appropriate values
For more information, see Setup, Imports, Imports Setup.
Open Journal Line Exists
Shows if the data has been transferred to an journal and if there is an open journal line.
Journal Line Posted
Shows if the data has been transferred to an journal and the journal line row has been posted.
Open Recon. Line Exists
Shows if the data has been transferred to an reconciliation and if there is an open reconciliation line.
Posted Statement Lines Exists
Specifies if the data has been transferred to a bank account reconciliation and a posted statement line exists.
No. of Charges
Shows the number of charges.
Open Charge Journal Line Exists
Shows if the charges have been transferred to an journal and if there is an open journal line.
Open Charge Reconciliation Line Exists
Shows if the charges have been transferred to an reconciliation and if there is an open reconciliation line.
Posted Charge Journal Line Exists
Shows if the charges have been transferred to an journal and if the journal line has been posted.
Posted Charge Reconciliation Line Exists
Shows if the charges have been transferred to an reconciliation and if the reconciliation line has been posted.
No. of Remittance Info. Lines
Specifies the number of remittance information lines.
Remittance Info.
Shows a part of the remittance info (file info: RmtInf Ustrd).
Payment Reference
Shows the payment reference of the imported transaction (file info: RmtInf Strd CdtrRefInf Ref).
Transaction Reference (Sender Reference)
Shows the Transaction Reference (Client Reference) of the imported transaction (file info: Refs EndToEndId >>> [TransactionReference]).
Order Reference (Batch Control No.)
Specifies the order reference (payment info id) of the imported transaction (file info: Refs PmtInfId >>> [OrderReference]).
File Reference (Message Reference)
Displays the file reference (message reference) of the imported transaction. (file info: Refs MsgId >>> [FileReference]).
Transaction Code
Displays the transaction code (file info: BkTxCd Prtry Cd).
These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing.
For more information, see Setup, Imports, Imports Codes.
Transaction Code Description
Shows the transaction code Description of the corresponding import code.
For more information, see Setup, Imports, Imports Codes.
SWIFT Transaktion Code
Shows the SWIFT transaction code (file info: BkTxCd Prtry Cd).
These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing.
For more information, see Setup, Imports, Imports Codes.
SWIFT Transaction Code Description
Shows the SWIFT transaction code description of the corresponding import code.
For more information, see Setup, Imports, Imports Codes.
Primanota No.
Shows the primanota number of the imported transaction.
Additional Info.
Shows additional information about the imported transaction.
Return Reason Code
Shows the return reason code of the imported transaction (file info: RtrInf Rsn Cd).
These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing.
For more information, see Setup, Imports, Imports Codes.
Return Reason Description
Shows the Return Reason Description of the imported transaction.
These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing.
For more information, see Setup, Imports, Imports Codes.
Shows the check number of the imported transaction (file info: Refs ChqNb).
Entry No.
Shows the entry number assigned to the record. The application assigns a unique number to each record.
Data Entry No.
This field contains the entry number of the data record.
Import Entry No.
This field contains the entry number of the import.
Import Transactions, Actions
Transfer
Allows lines from the NCP Imports to be transferred to an journal. During the transfer, for each payment transaction import, a corresponding line is created in the journal or in the reconciliation. If the option Transfer Charges in the NCP Imports Setup is set to Yes, an entry is also created in the journal or in the reconciliation for the total charges by each transaction. You can either transfer the entire imported file, or individual NCP Imports Data, or just individual NCP Imports Transactions.
For more information, see Tasks, Imports, Working with Payment Imports.
Remittance Info.
Opens the overview of the Remittance Info lines for this Transaction. Each row in the NCP Imports window can contain several data entries, which in turn can contain several transactions. The transactions in turn can contain several remittance info. lines and charges.
Charges
Opens the overview of charges for this Transaction. Each row in the NCP Imports window can contain several data entries, which in turn can contain several transactions. The transactions in turn can contain several remittance info. lines and charges.
Additional Info.
Opens the overview with the Additional Information for the selected transaction. (Stm/Rpt/Ntfctn)
Import Charges
This page views the charges from the NCP Imports.
Import Charges, Fields
Code
Shows the code of the charges (file info: Tp Prtry Id).
Amount
Shows the amount (file info: Amt).
ISO Country Code
Shows the ISO Currency Code of the balance (file info: Ccy)
Positive
Shows whether the balance is positive or negative ( file info: CdtDbtInd).
Total Charges
Shows the total charges amount of the transaction.
Open Journal Line exist
Indicates that data has been transferred to a journal and that there is an open journal entry.
Posted Journal Line exist
Indicates that data has been transferred to a journal and the journal entry has been posted.
Open Reconciliation Line exist
Indicates that data has been transferred to a bank account reconciliation journal and there is an open journal entry.
Posted Reconciliation Line exist
Indicates that data has been transferred to a bank account reconciliation journal and the journal entry has been posted.
Import Remittance Infos
The remittance info. of the NCP Imports is viewed here.
Import Remittance Infos, Fields
Remittance Info.
Shows a part of the intended use.
Import Additional Infos
This page lists the additional information from the NCP Imports Data or NCP Imports Transactions.
Import Additional Infos, Fields
Additional Info.
Specifies the additional information from the NCP Imports.
An account transaction file is a file that contains all the transactions of a bank account, including the resulting balance. A special variant is the electronic account statement, where the account statement data, for example in online banking, is provided in file format.
With the konfipay Connector, it is possible to import account transaction files into your Business Central for further processing, once the setup is completed. The import creates the account turnover entries, which correspond to the listing of new account turnovers in the konfipay portal.
Important
The interface retrieves all account turnovers marked as New, and already retrieved turnovers are no longer imported.
Note
Account turnovers are historically provided by the respective EBICS data centers for a limited period of time. This period is usually between 2 and 4 weeks, depending on the data center.
Note
The obligation of credit institutions is derived from Article 248 § 8 of the German Civil Code (EGBGB), which states that the credit institution must immediately inform the account holder of the details of each executed payment transaction. Therefore, credit institutions must provide account statements to enable customers to control their transactions and have an overview of their account balance. Deviating from Article 248 § 8 EGBGB, the information about account turnovers can also be provided monthly (Article 248 § 10 EGBGB). This applies equally to loan or custody accounts.
Fields
Acc. Transaction Date
Shows the date when the account transaction was downloaded into konfipay.
Acc. Transaction Time
Shows the time when the account transaction was downloaded into konfipay.
Download Date
Shows the date when the account transaction was downloaded into Business Central.
Download Time
Shows the time when the account transaction was downloaded into Business Central.
Imported
Indicates whether the account transaction file was imported to NCPI Import.
Import Date
Shows the date when the account transaction file was imported.
Import Time
Shows the time when the account transaction file was imported.
Acknowledged
Specifies whether the account transaction entry has been confirmed in konfipay.
Acknowledge Date
Shows the date when the account transaction file was acknowledged.
Account Transaction available
Indicates whether or not the Account Turnover Document has been imported from konfipay to Dynamics 365 Business Central.
Bank Account Name
Specifies the name of the bank account to which this account transaction file is assigned.
rId
Specifies the rId, this is a unique identifier and assigned by konfipay.
URL
Specifies the URL that applies to the import of the Account Turnover Document from konfipay.
IBAN
Specifies the Bank Account No. to which this account transaction file is assigned.
Bank Account No.
Specifies the bank account no. to which this account transaction file is assigned.
Order Type (EBICS)
Specifies the Order Type (EBICS).
File Name
Specifies the file name of the Account Turnover Document.
Import User ID
Shows from which user the data was imported.
Acknowledged Time
Shows the time when the account transaction file was acknowledged.
Acknowledged User ID
Shows from which user the account transaction was acknowledged.
Download User ID
Shows from which user the data was downloaded.
Process, Actions
Transfer Account Transaction File
The action loads the account transaction File. If the Automatic Import after Download setting is enabled in NCP Imports Setup, the file is immediately imported into NCPI Import.
Acknowledge Account Transaction File
The action acknowledges the account transaction file. Acknowledged account transaction entries can only be deleted through the konfipay portal.
Delete Acknowledged Account Transaction Entry
The action allows you to delete acknowledged account transaction entries. Acknowledged account transaction entries can only be restored through the konfipay portal. You can delete either all or selected records.
Related, Actions
NCP Imports
In the NCP Imports window, you can import files, transfer data to journals or bank account reconciliations, and manage the associated journals and reconciliations. Different actions and fields are displayed, depending on the setup.
Tasks, Imports, Working with Payment Imports
In modern web development, web services play a central role by enabling communication and data exchange between different applications and systems. These interactions leave behind extensive log entries that provide valuable information for monitoring, troubleshooting, and optimizing the services. Therefore, a structured and well-documented table for web service log entries is essential to ensure the integrity and efficiency of the web services.
This documentation provides a comprehensive description of the table for konfipay Connector service log entries. It includes detailed information about each field in the table and their meanings. The goal of this documentation is to provide developers, system administrators, and other IT professionals with a clear understanding of the structure and function of the service log entries to ensure effective utilization and management.
The following table captures detailed information about each request and response, including timestamps, request and response headers, status codes, payload data, and possible error messages. By systematically capturing and analyzing this data, problems can be quickly identified, performance can be monitored, and security incidents can be traced.
Fields
Request Date
Specifies the date when the request was sent to konfipay API.
Request Time
Specifies the time when the request was sent to konfipay API.
Test Environment
Specifies whether the data has been sent to the konfipay Test Environment.
API Function
Shows the function that was called in konfipay.
Service Status
Shows the Web Service Call Status.
HTTP Status Code
Shows the Http status code of the web request.
HTTP Status Message
Show the Http Status message. An Http Status message is only shown when an error is sent back in the web response.
Archived Request Exists
Specifies whether data has been sent to the service and stored in the log.
Archived Response Exists
Specifies whether data was returned from the service and stored in the log.
API Endpoint
Shows the konfipay endpoint where the web request was sent.
Request Duration
Specifies the response time from the service.
URL
Shows the Url that was called in konfipay.
Note
By default, the field is hidden. To display it, click on Customize and add the field.
Clearing Entry No.
Displays the Entry No. of the Clearing Entry.
konfipay-rId
Shows the konfipay rId. This Id. is the unique identification assigned by konfipay.
Note
By default, the field is hidden. To display it, click on Customize and add the field.
User-ID
Specifies the ID of the user who created the entry.
Note
By default, the field is hidden. To display it, click on Customize and add the field.
User Name
Specifies the user name who created the entry.
Note
By default, the field is hidden. To display it, click on Customize and add the field.
HTTP Method
Shows the HTTP method that was used in the web request.
By default, the field is hidden. To display it, click on Customize and add the field.
Actions
Show Request/Response
View detailed information about what has been sent to and returned from the service. The information can be useful for technical support.
Docs / NAVAX Payment / Appendix Data Structure
Exports
The action Create Payment File in the Payment Journals creates a NCP Clearing Entries with status Created, which contains information about the file.
Furthermore, a NCP Payment Entry is created for each individual transaction.
Structure:
Each line in the NCP Imports window can contain multiple Data lines, which in turn can contain multiple Transactions. The transactions in turn may contain multiple Remittance Info Lines and Charges.
During the transfer, a corresponding line is created in the journal or reconciliation for each NCPI payment import transaction.
If the Trans. Charges field in the NCP Imports Setup is set to Yes, an entry will also be created in the journal or bank reconciliation for the total charges per transaction.
You can either transfer the entire imported file, or individual NCP Imports Data, or just individual NCP Imports Transactions.
Note
As long as a entry has not yet been posted, you can delete it from the journal or reconciliation at any time. Click Transfer if you want to re-transfer the deleted line.
By creating a payment file, an clearing entry is created. The created payment file is also saved there. If necessary, you can use this action to remove the archived payment files from the clearing entries.
Note
The files can no longer be exported after this action.
The period for deleting the data can be specified in the NCP Exports Setup in the field Delete Data Date Calculation.
Only data that is at least 6 months old can be deleted. If the field is empty, this minimum period is used.
Options
Delete Archived Files
Specifies whether the archived files should be deleted.
Imports
Importing a file creates an entry in the NAVAX Payment Imports. The imported file is also saved there. With this action, the archived import files can be removed from the NCP Imports if necessary.
Note
The period for deleting the data can be specified in the NCP Imports Setup in the field Delete Data Date Calculation.
Only data that is at least 6 months old can be deleted. If the field is empty, the minimum period is used.
Options
Delete Archived Files
Specifies, whether the archived data should be deleted.
Docs / NAVAX Payment / Appendix QR-Code Document Data
Payments with QR Code generates a standardized QR Code, also called Girocode or EPC QR Code, this QR Code created by NCP Pay with Code can then be placed on your invoices.
On the NCP QR Code Document Data page, the history of all documents for which a Pay with Code QR code has been created (sales invoices, service invoices) is shown.
Fields
Document Type
Shows the Document Type of the Document for which the QR Code Document Data entry was created.
The following options are available:
Sales Invoice
Service Invoice
Document No.
Shows the Document No. of the document associated with this QR Code Document Data entry.
IBAN
Shows the IBAN of the recipient with which the QR Code Document Data entry was created.
SWIFT/BIC
Shows the SWIFT/BIC of the recipient used to create the QR Code Document Data entry (required in version 001; optional in version 002 within the EEA).
Receiver Name
Shows the receiver's name that was used when creating the QR Code Document Data entry.
Reference Text
Shows the Reference Text that was used when the QR Code Document Data entry was created.
Amount
Shows the Amount that was used to create the QR Code Document Data entry.
Currency Code
Shows the Currency that was used when creating the QR Code Document Data entry.
Purpose Code
Shows the Purpose Code that was used when creating the QR Code Document Data entry (max. four-digit code analogous to the text key according to DTA method, optional).
The purpose code corresponds to the text key known from the DTA procedure in order to be able to classify transfers and direct debits automatically. Payers and payees, as well as the payment service providers involved in payment processing, can use a purpose code to automatically identify payments (e.g., salary payments) and use the information, for example, for the automated calculation of account maintenance fees or the granting of overdraft facilities. Regular payments, such as salaries or capital-forming payments, should therefore always be made using a purpose code.
For more information, see Purpose-SEPA-Codes
QR-Code Id.
Shows the unique Id. that was generated when the QR Code Document Data entry was created.
QR-Code Size"
Shows the QR Code Size of the QR Code Document Data entry.
The following values are available for selection:
Small
Medium
Large
Version
Shows the Version of the QR Code Document Data entry.
If Version 001 is selected, the BIC must be specified. With Version 002 the BIC is optional to specify or to leave blank.
Function
Shows the Function that was used to create the QR Code Document Data entry.
The function is defined by the key value: SCT - SEPA Credit Transfer
Display
Shows the Display of the QR Code Document Data entry. This Introduction will be displayed to the user after the code has been captured and will provide a brief textual explanation of what they are about to initiate. This text is not reflected in the data transferred in the payment transaction.
Text
Shows the Message of the QR Code Document Data entry. This Message will be displayed to the user after the code has been captured and will provide a brief textual explanation of what they are about to initiate. This text is not reflected in the data transferred in the payment transaction.
Data
Displays the data used to generate the QR code. Click the field to display the formatted text in a new window.
QR-Code
Shows the generated QR Code of the QR Code Document Data Entry.
Actions
Show Document
Opens the page for the selected document.
Docs / NAVAX Payment / Appendix konfipay Bank Account List
On the konfipay Bank Account List page, all bank accounts available for synchronization in konfipay are displayed. This page opens when you click the Import Bank Accounts button on the Bank Account Setup page.
This overview serves as a central hub to conveniently display and manage the online balances of your bank accounts. You can use this page to quickly and easily access information about your account balances, ensuring you always have a clear view of your finances.
By selecting one or more records and confirming with OK, an existing bank account will be updated with the data from the selected entry. If a bank account does not yet exist, it will be created automatically.
konfipay supports virtually every EBICS-capable financial institution, with only a few exceptions. This ensures broad compatibility and flexibility, allowing you to seamlessly synchronize and manage nearly all your bank accounts.
Fields
The table contains the following fields and columns
Bank Account exist
Shows whether a bank account with the same data already exists in Business Central.
If you select one (or more) data record(s) and confirm with OK, an existing bank account will be updated with the data of the selected entry.
If the bank account does not yet exist, it will be newly created.
Name
Displays the name of the bank account. This name corresponds to the name used to create the bank account in konfipay.
IBAN
Shows the IBAN of the bank account.
SWIFT
Shows the Swift Code of the bank account.
Bank Account No.
Shows the Bank Account No. of the bank account.
Bank Branch No.
Shows the Bank Branch No. of the bank account.
Account Balance
Shows the account balance in konfipay.
The account balance is usually updated every 4 hours. konfipay offers you the opportunity to automate processes and procedures in bank communication.
Account Balance Date
Shows the account balance date from konfipay.
Active
Shows whether the bank account is active in konfipay or not.
Test
Shows whether the bank account is marked as a test bank account in konfipay or not.
Currency Code
Shows the currency code in which the bank account is managed in konfipay.
Note
By default, the field is hidden. To display it, click on Customize and add the field.
Agreement Document Link
Shows the link to the Agreement Document.
Note
By default, the field is hidden. To display it, click on Customize and add the field.
RID
Shows the RID. This RID is assigned by konfipay and is used to uniquely identify the bank accounts.
Note
By default, the field is hidden. To display it, click on Customize and add the field.
Actions
Open konfipay Bank Accounts
The action opens the konfipay Portal with the list of bank accounts. An appropriate permission is required to open this overview.
The NAVAX License Management page (in older versions "NAVAX License Overview" or "NCEX License Overview") displays the current license status of the NAVAX extensions.
Fields
Name
Specifies the name of the Extension.
License Status
Specifies the current license status of the Extension.
Serial No.
Specifies the serial number of the Extension.
Version
Specifies the currently installed version of the Extension.
Trial Version
A NAVAX extension can be tested or used free of charge for 30 days after installation. After that, the extension can only be used with a valid license.
Request License
The license can be requested or checked via the Current Status action. This opens a window.
The following example shows the NAVAX extension Excel Report Builder.
Fill in the fields in the window and then click Send License Request.
Please note that the licensing process may take some time.
In the next few days you will receive an email with further information.
Note
For licensing, calling the online help and performing some actions, access to https://www.navax.app must be granted.
Public IP from www.navax.app for setting firewall access: 94.136.22.236, Port: TCP/443
Checking the connection to https://www.navax.app using PS: Test-NetConnection navax.app -port 443 (PS must be performed with the M-Tier service user)
CRL Servers In addition, the following CRL Servers must also be accessible for the certificate check: https://certificates.godaddy.com/* http://crl.godaddy.com/* or their IP: 192.124.249.36
Activate/Update License
As soon as the licensing has been completed, you will receive an email and the license can be activated via the Update License action.
The license is company independent. So it does not matter in which company the action is called.
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.
If the Automatic License Renewal is enabled, the Update License action is called automatically before the license expires. Note that the setting is only active after the license has been activated via the action.
This action can be used to open the Microsoft AppSource ratings page for the extension.
We would be very happy if you submit your rating and let us know about your experience with the Extension.
Docs / NAVAX Payment / Appendix Information for Developers
Auf der folgenden Seite sind Events aufgelistet die Ihnen dabei helfen sollen, Integrationen in NCPE Zahlungsverkehr Export und NCPI Zahlungsverker Import einzubinden.
Tabelle - NCPE Zahlungsdatei Einrichtung
OnAfterCreateRemitInfoText
The event "OnAfterCreateRemitInfoText" is used to add custom logic and modify the texts when creating the remittance information. It allows developers to integrate their own code and work with custom values or fields. This event can be used to perform additional actions or validations during the creation process of the remittance information.
By using this event, developers have the flexibility to customize the behavior of the remittance information creation process according to their specific requirements.
Executed before finding the entries. This event is implemented with the IsHandled pattern and can override the entry finding process.
OnBeforeCalcVendLedgEntryStep2
Executed before calculating the entries. This event is implemented with the IsHandled pattern and can override the entry calculation process.
OnBeforeCalcCustLedgEntryStep2
Executed before calculating the entries. This event is implemented with the IsHandled pattern and can override the entry calculation process.
Codeunit - NCPE Install
Die Events werden bei der Installation von NCPE Zahlungsverkehr ausgeführt. Sie Helfen dabei die Erstellung der für die Ausführung notwendigen Parameter einzugreifen.
OnBeforeInitLanguageRecords
This event is executed before the initialization of the NCP language setup. It provides an opportunity for developers to perform any necessary actions or modifications before the language setup is initialized.
OnAfterInitLanguageRecords
This event is executed after the initialization of the NCP language setup. It allows developers to perform additional actions or modifications once the language setup is complete.
OnAfterInitSEPACountriesList
This event is executed after the initialization of the SEPA countries/regions. It provides developers with the ability to perform any required actions or modifications related to the SEPA countries/regions setup.
Report - NCPE Zahlungsdatei erstellen
OnBeforeVendorRemittanceInfoInsert
Das Event wwird nach der Erstellung der Verwendungszwecke ausgeführt
OnBeforeCustomerRemittanceInfoInsert
Das Event wwird nach der Erstellung der Verwendungszwecke ausgeführt
OnBeforeEmployeeRemittanceInfoInsert
Das Event wwird nach der Erstellung der Verwendungszwecke ausgeführt
OnAfterCreateVendorRemittanceInfo
Das Event wwird nach der Erstellung der Verwendungszwecke ausgeführt
OnAfterCreateCustomerRemittanceInfo
Das Event wwird nach der Erstellung der Verwendungszwecke ausgeführt
OnAfterCreateEmployeeRemittanceInfo
Das Event wwird nach der Erstellung der Verwendungszwecke ausgeführt
OnAfterGetNCPESetup
Wird am Anfang der Erstellung einer Zahlungsdatei ausgeführt
OnGenJournalLineCheck
Passiert vor der Prüfung der Buch.-Blatt Zeilenilen
OnBeforeLoopWriteXMLLine
Mit dem Em Event kann die Erstellung derhema Seilen Zeilen übersteuert werdenteuert werden.
OnBeforeWriteXMLLineToOutStream
Wird aufgerufen bevor die XML Datei erstellt wirder.
Report - NCPE Zahlungsvorschlag - Kreditoren
OnBeforeOnPreReport
Executed at the beginning of the proposal.
OnAfterPreReport
n. a.
OnAfterIncludeVendor
Executed before collecting vendor ledger entries.
OnAfterGetVendLedgEntries
Executed at the end of the GetVendLedgerEntries function.
For the use of konfipay Online Payment Services to communicate with the bank, access to https://portal.konfipay.de must be granted.
Public IP of portal.konfipay.de and dzbank.konfipay.de for firewall whitelisting:
Inbound: 20.61.2.93, Port: TCP/443
Outbound: 20.107.20.80, Port: TCP/443
Depending on the konfipay instance, the outgoing IP address for the connection to bank data centers may vary.
Public IP of portal.konfipay.ch for firewall whitelisting:
Inbound: 164.128.146.116, Port: TCP/443
Outbound: 164.128.146.116, Port: TCP/443
Depending on the konfipay instance, the outgoing IP address for the connection to bank data centers may vary.
Checking the connection to https://portal.konfipay.de, https://dzbank.konfipay.de or https://portal.konfipay.ch using PS:
Test-NetConnection [konfipay.de/konfipay.ch] -port 443
(PS must be performed with the M-Tier service user)
https://www.navax.app
For licensing, calling the online help and performing some actions, access to https://www.navax.app must be granted.
Public IP from www.navax.app for setting firewall access: 94.136.22.236, Port: TCP/443
Checking the connection to https://www.navax.app using PS: Test-NetConnection navax.app -port 443 (PS must be performed with the M-Tier service user)
CRL Servers In addition, the following CRL Servers must also be accessible for the certificate check: https://certificates.godaddy.com/* http://crl.godaddy.com/* or their IP: 192.124.249.36
https://qr01.navax.com:8080
To create the QR Codes via the CreateQRCodeRedSoft function, access to https://qr01.navax.com:8080 must be granted.
Checking the connection to https://qr01.navax.com:8080 using PS: Test-NetConnection qr01.navax.com -port 8080 (PS must be performed with the M-Tier service user)
Docs / NAVAX Payment / Appendix Possible Error messages konfipay
Error messages occasionally occur due to a faulty file structure or more often due to missing bank authorizations. More rarely, connection interruptions or general transmission errors to the bank server are the cause. konfipay contains a sophisticated warning and notification system for this purpose.
How errors are identified
konfipay has an error detection function that checks the submitted payment file for formal errors and thus ensures that this file does not reach the bank in the first place. A finely tuned duplicate check by konfipay also avoids potential duplicate submissions.
Below you will find a list of error codes that can occur during synchronization with the konfipay Online Payment Services API. Errors can be read via the konfipay Service Log Entries.
Structure of the error codes
ERR-{Category}-{Number}ERR - Festes Präfix für alle Fehlercodes
{Category} - Kategorie des Fehlers
{Number} - Nummer des Fehlers. Die Nummer ist innerhalb ihrer Kategorie eindeutig.
List of all error codes and error messages with explanation
ERR-01-XXXX - Category: Invalid string parameter
ERR-01-0001
RIdNotFound
There is no resource for the given RId.
ERR-01-0002
MsgIdNotFound
There is no resource for the given message identification.
ERR-01-0003
AmbiguousMsgId
The given message identification is ambiguous.
ERR-01-0004
InvalidStartDate
The start date was not recognized as valid date.
ERR-01-0005
InvalidEndDate
The end date was not recognized as valid date.
ERR-01-0006
InvalidPeriod
The given period is not valid (the start date and end date have to be chronological).
ERR-01-0007
InvalidDate
The date was not recognized as valid date.
ERR-01-0008
TransactionIdNotFound
There is no resource for the given transaction id.
ERR-01-0009
InvalidTransactionId
The given transaction id is invalid (empty or mor than 19 characters).
ERR-01-0010
AmbiguousTransactionId
The given transaction id is ambiguous.
ERR-01-0011
EMailAddressOrMerchantIdNotFound
There is no resource for the given email or merchant id.
ERR-01-0012
MissingParameter
A required parameter is not set.
ERR-01-0013
BankNotFound
The requested bank was not found.
ERR-01-0014
InvalidGateway
The requested gateway is not supported. Only "SRZ", "EBICS" or a valid rId are allowed.
ERR-01-0015
UnsupportedApiVersion
The API version is not supported for the requested resource.
ERR-01-0016
InvalidQueryStringValue
The query string parameter contains an invalid value.
ERR-02-XXXX - Category: Content validation failed
ERR-02-0000
ontentValidationFailed
The validation of the content failed. More information about the exact reason can be found in the error details.
ERR-02-0001
InvalidRId
The given RId is invalid (empty or not 36 characters long).
ERR-02-0002
InvalidXmlCharacter
The file contains invalid characters according to the DFÜ agreement.
ERR-02-0003
MissingXmlNamespace
The XML document does not contain a valid XML namespace
ERR-02-0004
InvalidXmlNamespacePrefix
The XML namespace prefix is invalid.
ERR-02-0005
PainVersionNotSupported
The specified pain version is not supported by konfipay.
ERR-02-0006
PainVersionReleaseDateNotReached
The pain version specified in the XML document is not (yet) valid.
ERR-02-0007
SchemaValidationError
The validation of the XML document against the XML schema failed.
ERR-02-0008
InitPartyIbanChecksumValidationFailed
The IBAN checksum of the ordering party account is invalid.
ERR-02-0009
OtherPartyIbanChecksumValidationFailed
The IBAN checksum of a beneficiary/payee account is invalid.
ERR-02-0010
InvalidIbanIsoCountryCode
The ISO country code contained in the IBAN is invalid or not supported.
ERR-02-0011
TransactionLimitExceeded
The maximum number of transactions allowed per payment order was exceeded.
ERR-02-0012
LocalInstrumentMashup
The document contains more than one payment method.
ERR-02-0013
InvalidServiceLevel
The specified service level is invalid (urgent payments are not allowed).
ERR-02-0014
InvalidExecutionDate
The execution date is too far in the future/past.
ERR-02-0015
InvalidInitiatingPartyIban
The bank account is not assigned to the user account or is inactive.
ERR-02-0016
IbanBicMismatch
The bank code of the IBAN does not match the BIC of the financial institution.
ERR-02-0017
ControlSumMismatch
The specified checksum in the header or a payment does not match the content.
ERR-02-0018
NumberOfTransactionsMismatch
The specified number of transactions in the header or a payment does not match the content.
ERR-02-0019
InvalidOtherPartyCountry
The beneficiary/payer bank account is not located in a SEPA participating country.
ERR-02-0020
InvalidBankAccountIban
The checksum of the IBAN of the bank account is invalid.
ERR-02-0021
InvalidBankAccountAdditionalInformation
The content exceeds the maximum length of 500 characters.
ERR-02-0022
InvalidCreditorId
The structure of the creditor identification is invalid.
ERR-02-0023
MissingRefundIdentifier
No identifier was specified for the transaction (transaction id or RId).
ERR-02-0024
InvalidRefundMemo
The memo specified for the refund is invalid (max. 255 characters).
ERR-02-0025
InvalidRefundType
The specified refund type is invalid. Possible refund types: Full
Partial
td>
ERR-02-0026
MissingRefundAmount
The amount to be refunded is required but not specified. The amount is required if refundType specified with Partial.
ERR-02-0027
InvalidRefundAmountValue
The value of the amount to be refunded is invalid.
ERR-02-0028
InvalidRefundAmountCurrency
The currency of the amount to be refunded is invalid.
ERR-02-0029
DtazvValidationFailed
The validation of the DTAZV file has failed.
ERR-02-0030
IbanValidationFailed
The validation of the IBAN has failed.
ERR-02-0031
InvalidBlz
The bank code is invalid.
ERR-02-0032
ContainerVersionNotSupported
The container version specified in the XML document is not supported.
ERR-02-0033
CamtVersionNotSupported
The camt version specified in the XML document is not supported.
ERR-02-0034
InvalidValue
A field in the transferred Json or XML document has an invalid value.
ERR-02-0035
OtherPartyAddressRequired
For payment orders whose counter account is not located in an EU participating country and with an amount > 1000€, it is mandatory to provide the address.
ERR-02-0036
DeprecatedLocalInstrument
The file contains the unsupported direct debit type "COR1". Only "CORE" and "B2B" are supported. "COR1" can be automatically converted to "CORE" using the API settings.
ERR-02-0037
InvalidLocalInstrument
The file contains an invalid value for this payment type in the 'LocalInstrument' field.
ERR-02-0038
PaymentMessageIsNotUnique
The Message ID of the payment file needs to be unique. This is an optional check that can be deactivated in the API settings.
ERR-03-XXXX - Category: Content not readable
ERR-03-0001
NoContentReceived
No content was transferred.
ERR-03-0002
InvalidContentType
The specified content type of the transferred content is invalid.
ERR-03-0003
InvalidFileStructure
The structure of the transferred file is syntactically invalid.
ERR-03-0004
InvalidXmlDocument
The transferred content does not correspond to a well-formed XML document.
ERR-03-0005
InvalidLoginCredentials
The syntactical structure of the login information is invalid.
ERR-03-0006
InvalidBankAccount
The syntactical structure of the bank account information is invalid.
ERR-03-0007
InvalidRefund
The syntactical structure of the refund information is invalid.
ERR-03-0008
ContentNotReadable
The transferred Text, Json or XML file does not have the expected structure.
ERR-04-XXXX - Category: Prerequisites not met
ERR-04-0001
MissingScope
The API key used for authentication does not have the necessary permissions to access the requested resource.
ERR-04-0002
SrzMappingFailed
The determination of the service data center for submitting the payment file failed.
ERR-04-0003
EbicsContactMappingFailed
No completely initialized EBICS contact for the transmission of the payment file was found.
ERR-04-0004
MissingEbicsOrderType
The EBICS contact does not have the required order type for the payment type.
ERR-04-0005
InvalidEbicsContact
The EBICS contact for the transmission of the payment file is not completely initialized or not configured to send payments.
ERR-04-0006
InvalidPaymentStatus
The status of the payment is already set to "executed". A new execution is only possible if the parameter force set to true
ERR-04-0007
BankAccountIbanAlreadyExists
A bank account with the specified IBAN already exists.
ERR-04-0008
InactiveBankAccount
The bank account is deactivated in konfipay.
ERR-04-0009
UnknownBankAccount
No bank account was found for the given IBAN.
ERR-04-0010
AmbiguousRefundIdentifier
The identifier for the refund transaction is not ambiguous.
ERR-04-0011
DuplicateFound
The file was identified as a duplicate.
ERR-04-0012
IndividualRestriction
The payment file cannot be accepted due to an individual restriction of the financial institution.
ERR-04-0013
ClientBlocked
The client application was blocked by konfipay. More information about the exact reason can be found in the error details.
ERR-04-0014
InsufficientPermissions
The client is not authorized to perform the requested operation. More information about the exact reason can be found in the error details.
ERR-05-XXXX - Category: Processing error
ERR-05-0000
ProcessingError
An error has occurred while processing the request. More information about the exact reason can be found in the error details.
ERR-05-0001
EbicsError
An error has occurred while performing the EBICS action.
ERR-05-0002
PayPalError
An error has occurred while performing the PayPal action.
ERR-05-0003
PayPalUnspecifiedError
During the execution of the PayPal action an error occurred that was not specified by PayPal.
Docs / NAVAX Payment / Appendix Release Notes
Would you like to know what has changed in the extension? Below you'll find an overview of the new features and changes made in the updates.
Would you like to know what has changed in the extension? Below you'll find an overview of the new features and changes made in the updates.
Version 21.2.2.3
as of Business Central 21 2024/10/28
Modifications
Order of the fields SWIFT Code and IBAN changed on the Vendor/Customer Bank Account List and Vendor/Customer Bank Account Card pages.
Corrections
When using the Business Central standard functionality Apply Entries with NAVAX Payment Exports installed, a permission error occurred if the user was not assigned the NCPE permission.
Fixed an error in the calculation of the discount tolerance.
If the discount tolerance was not activated in the General Ledger Setup (no discount tolerance period specified or 0D set) and the following constellations occurred:
Discount date and discount tolerance date are the same both discount and discount tolerance were posted, leaving the payment entry with an open balance.
Discount tolerance date is after the discount date discount date has passed and discount tolerance date applies - the discount tolerance was posted with the amount of the discount, even though the discount tolerance amount = 0 was entered in the entry.
In the vendor payment suggestion, the bank accounts were not filled if the Preferred Bank Account field was filled in the entry.
In the vendor payment suggestion, entries were not suggested because the filter on the Exported to Payment File field or the value was set incorrectly.
After executing a payment suggestion, an incorrect message was displayed at the end. The message was confusing as it stated that there could still be suggestions with other currencies.
When applying vendor/customer ledger entries, an error message occurred due to missing permissions if the user was not assigned the permission set NCPE, NAVAX Payment Exports.
Version 21.2.2.1
as of Business Central 22 2024/10/01
Improvements
The action Show Payment File has been added to the page NCP Exports Payment File - Summary.
For more information, see Tasks, Exports, Payment File Summary.
Modifications
When using direct debit mandates for multiple bank accounts, it is now ensured that the specific values of the respective mandate are used in the payment suggestion instead of adopting the values of the master mandate.
Version 21.2.2.0
as of Business Central 21 2024/09/27
Improvements
The setup of the placeholder character for the SEPA Direct Debit Mandate ID Separator has been added to the NCP Exports setup.
For more information, see Setup, Exports, SEPA-Direct Debit-Mandates.
When using master mandates, the values of the master mandate are now entered or exported in the payment suggestion and in the create payment file function.
Actions for creating and canceling payment files as well as displaying the payment statistics have been added to the three-dot menus in the journal lines.
XML Schema SDD - AT - Rulebook 2023 - Version 4 has been added to the download.
Modifications
Removal of obsolete code parts.
Corrections
When using the function Renumber Document Numbers, it could happen that numbers were assigned twice if lines with the status Payment File Status Created were already present in the journal lines.
Correction in the XML Schema SDD - AT - Rulebook 2023 - Version 2 of the node <ReqdColltnDt>.
If the main bank account of a customer/vendor was changed via the journal lines, the field Preferred Bank Account Code on the customer/vendor was not updated. This led to incorrectly filled bank accounts and payment methods in the Payment Suggestion.
When exporting payment files, the field Exported in Payment File in the journal lines and the customer/vendor entries was not set correctly. An entry was marked as exported even though there was still an open balance.
Version 21.2.1.1
as of Business Central 21 2024/09/13
Modifications
The functionality for employee payments has been removed from NCP Payment Exports.
When creating a payment file, only the part of the direct debit mandate ID that is before the underscore (“_”) is now exported. This additional functionality allows the same direct debit mandate ID to be used for multiple customers.
Corrections
The journal line check in the payment suggestions has been revised. Now, all journals are automatically checked, and already suggested or balanced entries are listed in an overview. The option Check Other Journal Batches has been removed.
The document type in the payment suggestion list was not translated into the respective user language for lines of a overpayment.
In the payment suggestion list, the incorrect amount was printed in case of overpayment.
Version 21.2.1.0
as of Business Central 21 2024/08/22
New Product Name
The NCPE Payments Export extension has been renamed to NAVAX Payment Exports.
Improvements
Menu structure in the accountant role center tidied up.
Modifications
The logo of the extension has been changed.
Corrections
The payment suggestions ignored entries with document type Refund when the option Check Other Journal Batches was activated.
In the Payment Suggestion List, a line of type Payment was printed if a suggested document was within the Discount Tolerance.
If a bank account was specified in the NCP Preferred Bank Account Code field on a purchase invoice, it was not included in the entries when posting.
Correction of the text af the error message that occurred when checking the payment status in a ledger entry line that had already been exported or sent.
Version 21.2.0.4
as of Business Central 21 2024/08/01
Improvements
Redesign of the menu structure in the payment journal pages and cash receipt journal pages.
Modifications
If a value was entered in the Creditor/Customer Entry in the Recipient Bank Account field, it was previously ignored in the payment suggestion. The logic of bank account determination in the payment suggestion has now been revised: If a value is present in the Recipient Bank Account field, it will be used. Additionally, the bank account determination for debtor entries has been expanded to consider a direct debit mandate ID selected in the documents, which overrides everything else. If neither applies, the bank account will be searched based on the External Bank Account Search option in the NCPE Payments Export Setup.
Removal of obsolete code parts.
User experience improvements.
Corrections
After creating a payment file, before the NCPE Payment File - Summary page was opened, a message with an additional placeholder appeared.
If the option Check Other Ledger Sheet Names was activated during the payment proposal, it led to an error message if the Payment File Status for an entry in another ledger sheet was already set to File Created
Version 21.2.0.3
as of Business Central 21 2024/07/23
Corrections
During the installation of NCP Payment Base, an entry was mistakenly created in the license management. This error has been fixed, and an update routine has been created to delete the entry.
Version 21.2.0.2
as of Business Central 21 2024/07/05
Modifications
The customer and vendor bank account cards have been revised so that the fields IBAN and SWIFT Code are no longer displayed as mandatory.
The check in the payment and cash receipt journal has been revised. For non-SEPA transfers, the fields IBAN and SWIFT Code are no longer required, which correctly reflects the status.
Corrections
Under certain constellations, there were data locks in the Payment Journal page, which prevented further work.
Version 21.2.0.1
as of Business Central 21 2024/07/03
Corrections
The option Check Other Journal Batches in the NCPE Suggest Customer Payments or NCPE Suggest Vendor Payments was not taken into account.
When creating a direct debit or payment suggestion with the option Incl. Debtors with Credit Balance - Total or Incl. Creditors with Credit Balance - Total, some creditors/debtors were not taken into account even though they did not have a credit balance.
Version 21.2.0.0
as of Business Central 21 2024/06/21
Important
For On-Premises an update of the License or the following granules is required:
1001710 NCPE Payments Export by NAVAX
Improvements
Preparation for integration of konfipay Connector
Change in the payment method field in the ledger entries. Now only the available payment methods are displayed in the respective ledger entry.
The download of bank codes has been improved. Previously, it was necessary to maintain the URLs for downloading the bank codes before the download could be initiated.
This has been simplified by automatically starting the download as soon as the bank code download is triggered.
The download of bank codes now occurs in JSON format to improve download performance.
New option "Summary after creation" added to the NCPE setup.
For more information, see Setup, Exports, Exports Setup.
For creditor/customer bank accounts, the SWIFT code field has been expanded with a lookup to the SWIFT Codes table.
New option "Yes - Structured" added to recipient address in the XML schemas. This is required to comply with the new specification of the SEPA schemas implementing the ISO20022 standard.
Functionality to display the payment file in the clearing entries added.
The customer payment suggestion in the payment journal page has been renamed to Customer Direct Debit suggestion.
The payment file status field in the ledger entry lines is no longer displayed in bold and red as it caused confusion, if a line needs to be checked, it is now displayed in yellow.
Corrections
When downloading bank codes from multiple sources, the source was not indicated in the notifications or error messages. This has now been corrected as it is very helpful for analysis to know which source caused an event.
Some tooltips have been corrected.
Filters have been applied to the debtor payment suggestion for creditor entries.
Revision of the update or display of the payment status in the payment ledger entries.
There was an error during posting or preview posting in the Cash Receipt Journals when a Refund was present in the lines.
Version 21.1.7.2
as of Business Central 21 2024/04/11
Modifications
Download URLs for the Bank Codes have been updated.
Corrections
In the payment and cash receipt journals, the field Payment File Status showed Check if no SWIFT Code was specified on the customer/vendor bank account, even though the XML schema used, which was specified on the bank account, had Dom. IBAN Only enabled.
In the SEPA region, specifying the SWIFT Code is generally not necessary.
Version 21.1.7.1
as of Business Central 21 2024/02/19
Note
This version is also available as a downgrade version for Business Central 20 and 19.
Corrections
The function Consider Payment Discount Tolerance considered the discount tolerance date but did not reduce the amount in the ledger entry by the discount.
Version 21.1.7.0
as of Business Central 21 2024/02/12
Important
For On-Premises an update of the License or the following granules is required:
1001710 NCPE Payments Export by NAVAX
Improvements
The logic behind the Payment File Status field has been improved in the Gen. Journal Line table. The settings and parameters of the bank account are now also taken into account.
On the pages Payment Journal and Cash Receipt Journals the info box Payment File Error has been added. This info box shows the errors per journal line that would prevent the payment file from being exported.
In the NCPE Payments XML Schemas the Extended Character Sets have been extended for all XML schemas, the characters äüöÄÜÖß have been added since most banks accept these characters in the payment files.
In NCPE Suggest Vendor Payments and NCPE Suggest Customer Payments, the options Consider Payment Discount Tolerance have been added. Previously, the value of the Pmt. Discount Date field from the entry was taken into account.
For more information, see Tasks, Exports, Make Payment Suggestions.
New option Without Reductions added to the reports NCPE Suggest Vendor Payments and NCPE Suggest Customer Payments. The indicator is used to ensure that entries that would reduce the amount (credit memos, reductions) are not included in the payment suggestion.
For more information, see Tasks, Exports, Make Payment Suggestions.
Modifications
Calling up the pages Bank Account Setup and Pay with QR-Code from the role center has been changed. Previously, the pages were opened in view mode, so editing had to be activated on the pages before settings or changes could be applied.
In the payment suggestions, refunds were suggested although the option Summarize per Vendor/Customer was activated, so an error occurred when creating the payment file.
After calculating the payment suggestion, vendors/customers which had a credit balance in total (e.g. an invoice has already been posted but not yet due in this payment suggestion) were incorrectly included in the suggestion and written as refunds in the journal, which blocked the creation of a payment file.
In the NCPE Payments Export Setup an incorrect report was specified as Pmt. Notification Report ID, this has been corrected and an upgrade routine has been created to correct the report ID. The initial value has also been corrected.
Error in the creation of the QR code when the function Pay with QR-Code was activated. If no default bank account was set up for payments with QR code, the process was canceled after selecting the bank account to be used for QR code creation.
Due to the installation of the extension, the totals were not always printed on the A4 documents when using the RDLC report layouts.
If the option Summarize Per Vendor/Customer has been selected in the payment suggestion, the dimensions have not been transferred consistently to the journal lines.
In the assisted setup, the name of the field Creditor Identifier (CI) was previously County.
Version 21.1.6.5
as of Business Central 21 2023/11/17
Improvements
Improvement of user experience - actions in the Payment- and Cash Receipt Journal pages have been reorganized.
Improvement for developers: The propagateDependencies option is now set.
Modifications
Update of the NCP Payments Base extension.
Version 21.1.6.4
as of Business Central 21 2023/09/25
Corrections
When creating a Purchase Invoice with a Payment Method linked to a G/L account to automatically apply the invoice immediately with a payment during the posting process, the vendor ledger entries of the invoice have been posted with balance 0 but are incorrectly posted with Open=YES.
Version 21.1.6.3
as of Business Central 21Important Update 2023/08/07
Improvements
It is now possible to block collective transactions at vendor level. If the Collective Transaction Not Allowed option is activated for a vendor, no collective transactions will be created for the vendor in the Payment Journal.
Corrections
Error correction of the collective transactions functionality. In report 70322082 NCPE Create Payment File, the variable AllowCollectiveTransactions could be changed via an event. Setting it to false had an impact on Collective Transactions in conjunction with Payment Reference or One-Time Transfers.
Version 21.1.6.2
as of Business Central 21Important Update 2023/06/26
Corrections
In the report Payment Suggestion List, the payment discount is shown twice because the payment discount tolerance was calculated incorrectly although a payment discount was already granted.
Obsolete events have been revised. The OnUpdateTempPaymentBufferFromCustomerLedgerEntry and OnBeforeUpdateGnlJnlLineDimensionsFromTempPaymentBuffer events in the NCPE Suggest Customer Payments report are available again.
When importing data (SEPA schemes, bank codes), the number of overwritten data records was not displayed correctly.
Version 21.1.6.1
as of Business Central 21Important Update 2023/06/15
Corrections
Payment discount tolerance was drawn incorrectly although a discount was to be granted if the Block Payment Tolerance value was changed on the customer/vendor.
GUI improvements in Cash Receipt and Payment Journals concerning the Payment File Status.
The import function Initialize SEPA Countries has been redesigned. Previously, there was a query for changes to the NCP SEPA field. This is not necessary as it is a field of the NCP Payments app and can therefore be overwritten.
The value of the field Payment File Status was determined incorrectly when the function Summarize per Customer/Vendor was selected in the payment suggestion.
Version 21.1.6.0
as of Business Central 21 2023/06/07
Important
For On-Premises an update of the License or the following granules is required:
1001710 NCPE Payments Export by NAVAX
Improvements
On the NCPE Payments XML Schema or NCPE Payments XML Schemas page a new action Allowed Character Set has been added. With this action you can configure the allowed characters which are valid for the purpose in the payment file. This is necessary if your bank allows a different character set than the standard of the SEPA scheme.
A new field Umlaut Conversion has been added to the NCPE Payments XML Schema table. This can be used to control whether or not umlauts should be converted for usage purposes. The conversion converts e.g.: an Ä to an Ae.
New field Pmt. Notification Report ID added in the NCPE Export Setup. With this, a possibility was created to define own report layouts for the payment notifications.
New fields Payment Notification Report ID, Clearing List Report ID, SEPA Mandate Report ID, Zlg. Default List Report ID and their captions have been added to the NCPE Export Setup. Herewith a possibility was created to deposit own report layouts for the printouts.
.
When updating and reinstalling, the NCP SEPA indicator in the Countries/Regions table were updated each time, this has now been disabled - so installation should be faster.
Modifications
Some actions have been renamed and rearranged in the payment journals.
The action Initialize NCP SEPA Countries on the page Countries/Regions has been redesigned. The function now creates a record if it does not exist. If an entry exists, the record will be updated.
Corrections
Actions and fields of NCPE Payments Export and NCPI Payments Import have been moved. Before it was not possible to use Business Central standard for e.g.: Payment File Export if NCPI Payment Import was installed. The same applies to NCPE Payments Export.
The payment file status field was not updated after creating a payment file. The error has been fixed.
Actions in the payment journals were cleaned up.
The captions in the NCPE Initial Setup Wizard were not translated into German.
In the NCPE Initial Setup Wizard, the link to the NCP Payment Language Setup was incorrect, the Languages page was opened instead of this page.
The action Initialize NCP SEPA Countries on the page Countries/Regions has been renamed to Initialize SEPA Countries.
Version 21.1.5.0
as of Business Central 21 2023/03/27
Improvements
The Check Other Journal Batches option has been added to the payment suggestions. If this option is enabled, entries that are already in other journals will not be taken into account and will be skipped. This prevents the journal lines from being edited more than once.
Payment and cash receipt journals have been improved. It is now easier to see if journal lines are ready to be exported to a payment file or if values are still missing. With the newly added Payment File Status field, you can see at first glance whether a line is ready for payment file export. If one or more errors occur in the line, an overview with the errors can be opened using DrillDown.
The Preferred Bank Account Code field on Accounts Payable or Accounts Receivable is now filled with the bank account that is marked as Main Bank Account. If you change the value for Preferred Bank Account Code, the Main Bank Account flag on the bank account will be automatically adjusted.
When creating a purchase document, the Preferred Bank Account Code field will be prefilled if a bank account code has been specified on the vendor. The bank account that is stored on the purchase document will then be taken into account in the payment suggestion and written in the journal line.
The External Bank Account Code field has been removed from the accounts payable, accounts receivable and journal. entries. Instead of the External Bank Account Code, the Recipient Bank Account field from standard is now used. An upgrade routine to convert to the new field is run during installation to prevent data loss.
The field Mandat ID was removed from the journal lines because there is the field Direct Debit Mandate ID in the standard and this can also be used. An upgrade routine has also been created to upgrade the field during installation.
Bankcodes Download URL's updated and provided as download.
Corrections
Layout der Zahlungsvorschlagsliste korrigiert. Es wurde eine zusätzliche Seite ausgegeben da die Seitenränder nicht korrekt waren.
Version 21.1.4.0
as of Business Central 21 2022/11/30
Business Central Update
Improvements
Tooltips on the XML Schema Lines page have been improved so that the description of the columns is now more understandable. This should make editing the schemas easier.
Actions structure has been improved. The new action groups introduced with Business Central have been integrated into the current version of NCPE Payments Export and the menu structure has been improved.
Corrections
The Incl. Vendors with Credit or Incl. Customers with Credit functions in the payment suggestion reports did not work properly.
When opening the NCPE Initial Setup Wizard for the first time, an error occurred stating that the record does not exist.
The NCPE Initial Setup Wizard was created several times in the GuidedExperience, which caused the NCPE Payment Setup and the Setup Wizard are shown more than once.
An error in the NCPE Mail Management codeunit has been fixed. This prevented the automatic update of Business Central when NCPE Payments Export was installed.
Version 20.1.3.2
as of Business Central 20Important Update 2022/09/06
Corrections
Error in payment suggestions, creditor and debtor payment suggestion created wrong applications and entries.
The calculation of the payment tolerance when executing the payment suggestion incorrectly calculated the discount, which caused the wrong suggestion to be written in the journal.
Missing options in the payment suggestion reports have been readded.
Version 20.1.3.1
as of Business Central 20Important Update 2022/08/25
Corrections
When posting Sales Documents, a message appears that a customer entry could not be found if there is no NCP Pay with QR Code setup.
Version 20.1.3.0
as of Business Central 20 2022/08/12
Business Central Update
Corrections
The table relation of the External bank Account Code field in the Vendor Ledger Entry table has been corrected.
Improvements
The possibility to select a layout has been added to the report NCPE Payment Suggestion List. It is now possible to decide via the Report Layout Selection page whether the payment suggestion list should be printed in portrait or landscape format.
The Execution Date used in the payment proposals can now be pre-configured in the NCPE setup as Date Formula.
For Non SEPA transfers, address data for the receiving bank is also required in many countries, this has now been added to the XML Schemas so that it can be included in the schemas.
For OnPrem installations, events have been created, providing a way when creating SEPA XML files to allow a default location without download with query.
The Payment Notification Texts have been extended by a text editor, so now texts copied from e.g. Word can be pasted into the text editor.
On the page Countries/Regions the action NCP Initialize SEPA countries was added to enable the subsequent automatic setup of the SEPA countries. Use this action if the SEPA column has no values. Normally all SEPA countries are set up automatically during the installation of NCPE Payments Export, but in some constellations it is still necessary to set them up again automatically.
A new function has been integrated in NCP, this allows to add a QR Code to invoices for the functionality Pay with QR-Code.
In NCPE Setup an action has been added which allows to update the bank code URL's. The action starts the download of the URL's from www.navax.app, the data is continuously updated so that the latest URL's can always be fetched.
Progress indicators built into all relevant functions. These include the payment suggestions and the payment file creation.
The fields, Incl. Customers with neg. Balance and Incl. Vendors with pos. Balance, in the NCPE Setup, have been renamed to Incl. Customers with Credit and Incl. Vendors with Credit, for better understanding.
.
Necessary code updates for the new Business Central release.
Version 19.1.2.0
as of Business Central 19Important Update 2022/03/31
Improvements
New fields, Incl. Customers with neg. Balance and Incl. Vendors with pos. Balance, added in the NCPE setup. These are used to exclude debtors/creditors with credit balance in the payment suggestion.
The recipient of the e-mail is now entered in the payment entry after sending a payment notification. This is possible since an update from Microsoft.
Payment Notification layout improved.
Corrections
In the payment suggestion for certain constellations there was still an error message: "Currency" does not exist. Identified fields and values: Code = ''. This has been fixed.
Translation of the Document Type column in the Payment Suggestion List report has been corrected and layout has been changed for a better overview.
Error message during payment suggestion: Too many key fields were specified, therefore "SEPA Direct Debit Mandate" could not be retrieved. The number of fields in the primary key is 1. The function call has been changed.
Error in function call of the payment notification report corrected. It happened that the payment notification numbers are different than the ones in the e-mails to the customers..
Version 19.1.1.0
as of Business Central 19 2022/02/25
Business Central Update
Improvements
NCP bank codes are also inserted on the employee page.
Deprecated email features (SMTP Mail) are removed from NCPE Payments Export as they will soon be unavailable in Business Central, instead the advanced email features are used.
Modifications
Bank Codes Download URL's updated.
Actions and fields related to licensing have been removed from NCPE Payments Export as they have all been added centrally in the NCEX Extension Base extension.
Corrections
When updating the exchange rate, an error occurred regarding the currency with code '', this was fixed and an upgrade routine was created. Added the new field ISO LCY Code in the NCPE Payments Export Setup, this field is now used instead of the record in the currency table and should be filled before use, this does not apply to new installations. For new installations the field will be automatically filled with EUR if in the General Ledger Setup in the LCY Code field the value EUR or EURO has been specified.
For more information, see Setup, Payments Export Setup.
When creating payment advices for customers who had not specified a language code, the error message "Invalid language code specified: 0." appeared.
The error in the payment suggestion has been corrected, it prevented the external bank account code from being correctly assigned in the journal.
The Payment Suggestion List has been edited to show longer descriptions, previously the lines were truncated.
Version 18.1.0.0
as of Business Central 18 2021/08/10
Corrections
Fixed an error when sending notification emails via the new email features.
Introduced the new onboarding feature of Dynamics 365 Business Central to all pages where it makes sense.
Some Events added for extensibility.
The new Email feature from Dynamics 365 Business Central is now used to send the Payment Notification emails.
Modifications
Code requirements for Dynamics 365 Business Central version 18 implemented.
Permission sets converted to the new permission objects.
Bank Codes Download URL's updated.
Changed UI of the Assisted Setup.
Changed the behavior how the UI shows messages to the user - we now showing Notifications instead of message boxes to the user.
Corrections
The menus in the Payment and the Cash Receipt Journals was broken and now these are fixed.
The Payment Type field in Payment and Cash Receipt Journal was not filled correctly. Now the field will be filled as expected.
Keys renamed in several tables.
The address checks in the One Time Transfer page now working correct.
Version 17.0.0.0
as of Business Central 17 2020/12/01
Business Central Update
Improvements
Installation routine (new installation) now creates the required standard entries in the tables: Languages, Countries/Regions, SEPA Mandate Text Lines and Payment File Setup.
For more information, see Export Einrichtung, Zahlungsverkehr Export Einrichtungsassistent.
Modifications
Captions of some fields corrected.
Code requirements for Dynamics 365 Business Central version 17 implemented.
Functions that are no longer needed are marked as obsolete - they will be deleted in a future release.
Bank Codes Download URL's updated.
In the Assisted Setup on the SMTP Mail Setup page a button has been added to access the standard SMTP settings. Now you can change the email settings without leaving the wizard.
The Overview of Available XML Schemas in the NCPE Payments Bank Account Setup now only views the relevant schemas according to the country code assigned to the bank account.
Text of the AssisstEdit message boxes for the fields "File name" and "Remittance" has been made more readable.
Error in the XML Schema card where the fields IBAN Only possible, IBAN or Account Number possible, Address possible, Charges possible and Urgent Payment possible were not filled correctly (the options were filled incorrectly according to the available schema).
For more information, see Export Einrichtung, Zahlungsverkehr XML Schemata.
Display error when AssisstEdit the "File Name" field in the "Payment File" section of the NCPE Export Setup page.
Would you like to know what has changed in the extension? Below you'll find an overview of the new features and changes made in the updates.
Version 21.2.1.0
as of Business Central 21 2024/09/05
New Product Name
The NCPI Payments Import extension has been renamed to NAVAX Payment Imports.
Improvements
Menu structure in the accountant role center tidied up.
A new feature has been added that displays a message and overview when the automatic application skips entries because they already exist in other journal pages. This helps users avoid duplicate entries and maintain an overview of their transactions.
In the Payment Journal and Cash Receipt Journal pages, the Apply Suggested Application - line action has been integrated in the "Show more options" (three dots ⋮) menu.
In the Apply Vendor Entries and Apply Customer Entries pages, the fields NCP Imports Payment Reference, NCP Imports Remittance Info., and NCP Imports Additional Information have been added. Additionally, the Import Transaction Card action has been added. This facilitates manual follow-up of reconciliation suggestions.
Modifications
The logo of the extension has been changed.
Version 21.2.0.2
as of Business Central 21 2024/08/01
Improvements
Redesign of the menu structure in the payment journal pages and cash receipt journal pages.
Version 21.2.0.1
as of Business Central 21 2024/07/23
Corrections
During the installation of NCP Payment Base, an entry was mistakenly created in the license management. This error has been fixed, and an update routine has been created to delete the entry.
Version 21.2.0.0
as of Business Central 21 2024/06/21
Important
For On-Premises an update of the License or the following granules is required:
1001730 NCPI Payments Import by NAVAX
Improvements
Preparation for integration of konfipay Connector.
The download of bank codes now occurs in JSON format to improve download performance.
For creditor/customer bank accounts, the SWIFT code field has been expanded with a lookup to the SWIFT Codes table.
When downloading bank codes from multiple sources, the source was not indicated in the notifications or error messages. This has now been corrected as it is very helpful for analysis to know which source caused an event.
Some tooltips have been corrected.
Version 21.1.7.4
as of Business Central 21Important Update 2024/06/06
Corrections
Error message when executing the Application Suggestion, "The Length of the string is 23 but it must be less than or equal to 20 characters. Value: @**********" the error has been fixed.
Version 21.1.7.3
as of Business Central 21Important Update 2024/05/24
Corrections
Error message when performing the Application Suggestion if a corresponding entry was searched for using the payment reference in the Creditor/Debtor No.
Version 21.1.7.2
as of Business Central 21 2024/05/06
Corrections
A correction has been made to the automatic application logic. Entries or accounts were not suggested correctly.
The Import Suggest Application in the journal entries previously had problems with applying entries that included payment discounts. As a result, these items were not applied correctly or could not be found properly. To be able to reconcile the entries, it was necessary to set up the application tolerance amount in the NCPI Payments Import Setup to be higher than the payment discount.
Version 21.1.7.1
as of Business Central 21 2024/04/17
Corrections
Error message when performing the Application Suggestion if a corresponding entry was found for an entry due to the payment reference.
Obsolete actions on the NCPI Payments Import Details page have been hidden.
Version 21.1.7.0
as of Business Central 21 2024/03/12
Note
This version is also available as a downgrade version for Business Central 20 and 19.
Improvements
The automatic application can now be set up so that separators in the External Document No. field are taken into account. Previously, the automatic application was not possible if the structure of the External Document No. contained a special character (separator).
Example:
External Document No: 123456_DIVISION, but the purpose of the payment only imported 123456.
The matching logic has been improved and now provides even more results.
The Bank Account Setup menu has been added to the setup wizard.
On the NCPI Import page, the Open Reconciliations and Posted Statements actions have been removed from the Data menu. This only applies if the import option in the NCPI Setup has been set to Bank Account Reconciliation.
The function Keep Account Allocations did not work in certain constellations, the error has been fixed.
The setup wizard has not set the status correctly in the Assisted Setup overview page.
In the setup wizard, the values of the fields Source Code from Import, Source Code from Bank Acc. Reconciliation and Fixed Account Allocations Exist were not shown correctly or were not calculated if they were already configured.
In the Cash Receipt Journals, a 0 was shown in the Direct Debit Type field if the line was not of type direct debit.
Version 21.1.6.2
as of Business Central 21 2023/11/17
Improvements
Improvement of user experience - actions in the Payment and Cash Receipt Journal pages have been reorganized.
Improvement for developers: The propagateDependencies option is now set.
Modifications
Update of the NCP Payments Base extension.
Version 21.1.6.1
as of Business Central 21 2023/11/07
Improvements
Added new option Keep Account Allocations in the NCPI Payments Import Setup. If the option is enabled, account numbers will be suggested during automatic matching even if no matching documents are found to application.
Version 21.1.6.0
as of Business Central 21 2023/06/07
Important
For On-Premises an update of the License or the following granules is required:
1001730 NCPI Payments Import by NAVAX
Business Central Update
Modifications
Some actions have been renamed and rearranged in the payment journals.
Corrections
Fixed error in automatic application with payment discount and/or payment discount tolerance.
Actions and fields of NCPE Payments Export and NCPI Payments Import have been moved. Before it was not possible to use Business Central standard for e.g.: Payment File Export if NCPI Payment Import was installed. The same applies to NCPE Payments Export.
Version 21.1.5.0
as of Business Central 21 2023/04/06
Improvements
The NCPI Import Fixed Account Allocations page can now be accessed via Tell me what you want to do?
In the Fixed Account Allocations it is now possible to assign Dimensions, these are automatically carried along when posting and written to the entries.
On the NCPI Import Data and NCPI Import Data Card pages 3 new fields have been added. Closing Booked last Statement, Transaction Amounts and Closing Booked. These fields are for better overview of account balances.
The automatic matching of customer payments now also searches for the External Document No. in the entries.
Modifications
The NCPI Import Data and NCPI Transactions pages have been redesigned to make it easier to work with NCPI Import. They now provide all the functions of a list page.
Navigate function implemented on the NCPI Import Transactions and NCPI Import Charges pages. This can be used to search for related entries, as in Business Central Standard.
On the NCPI Import Data Card page, the Bank Account field has been set to editable, if this could not be assigned automatically it is now also possible to change the bank account in the card.
Corrections
On the NCPI Import page the name of the action Transfer was corrected, here the translation into German was missing.
Tooltips and captions on some pages corrected and improved.
Version 21.1.4.0
as of Business Central 21 2022/12/21
Business Central Update
Improvements
Actions structure has been improved. The new action groups introduced with Business Central have been integrated into the current version of NCPI Payments Import and the menu structure has been improved.
A drop zone has been added to the NCPI Import page. Via the drop zone, single or multiple files can be uploaded via drag & drop.
Modifications
In the NCPI Payments Import Setup table, the field "Document No. Alloc. Accuracy" field has been replaced by the "Doc. No. Alloc. Accuracy". The object name was too long and might cause errors in future Business Central versions. When upgrading NCPI Payment Import to version 21.1.4.0, the change is performed automatically so no breaking change can happen.
Corrections
The fields SEPA Credit Transfer Scheme, NON-SEPA Credit Transfer Scheme, SEPA Direct Debit Scheme, Originator ID and Originator ID Issuer have been removed from the Bank Account Setup table. The fields will be used only in NCPE Payments Export and will be moved there.
The NCPI Initial Setup Wizard was created several times in the GuidedExperience, which caused the NCPI Payment Setup and the Setup Wizard to be shown several times.
Version 20.1.3.2
as of Business Central 20Important Update 2022/09/09
Corrections
Fixed an error in the automatic application suggestion, no automatic application suggestion was possible because it was interrupted with an error.
Version 20.1.3.1
as of Business Central 20Important Update 2022/08/25
Corrections
When posting Sales Documents, a message appears that a customer entry could not be found if there is no NCP Pay with QR Code setup.
Version 20.1.3.0
as of Business Central 20 2022/08/12
Business Central Update
Improvements
The bank statement import now automatically detects which file is being imported, the selection window by which the file type was to be selected is not necessary and is no longer displayed.
In the Import Suggest Application in the journals already correctly found customers or vendors were skipped although such were found based on the external bank account number. During the application search, a complex logic of priorities is used, where the item has the highest priority. This logic has now been improved in that debtors but also creditors are no longer skipped as soon as the external account number was found and also the search of information in purpose and the payment reference has been improved so that now an improved result comes out in the application suggestion.
A new function has been integrated in NCP, this allows to add a QR code to the invoice for the functionality Numbers with code.
Progress indicators built into all relevant functions. These include the import of files and the transfer of files.
The result of the automatic adjustment suggestion has been improved so that the automation level has been increased.
Corrections
Code corrections.
Version 19.1.2.0
as of Business Central 19Important Update 2022/03/31
Corrections
An error when importing a CAMT file if it contains reversal postings has been corrected.
Version 19.1.1.0
as of Business Central 19 2022/02/25
Business Central Update
Improvements
The MT940 import format has been added to NCPI Payments Import.
Modifications
Actions and fields related to licensing have been removed from NCPE Payments Export as they have all been added centrally in the NCEX Extension Base extension.
Corrections
When updating the exchange rate, an error occurred regarding the currency with code '', this was fixed and an upgrade routine was created.
Correction of the license check in all relevant functions.
Version 22.2.2.0
as of Business Central 22 2024/09/27
Modifications
NAVAX Payment Exports extension update.
Removal of obsolete code parts.
Version 22.1.1.0
as of Business Central 22 2024/08/23
Modifications
NAVAX Payment Exports extension update.
Version 22.1.0.2
as of Business Central 22 2024/08/01
Improvements
Redesign of the menu structure in the payment journal pages and cash receipt journal pages.
Version 22.1.0.1
as of Business Central 22 2024/07/23
Corrections
An entry in the license management was mistakenly created during the installation of NCPK konfipay Connector Base. This issue has been resolved and an update routine has been created to delete the entry.
Would you like to know what has changed in the extension? Below you'll find an overview of the new features and changes made in the updates.
Version 22.1.1.0
as of Business Central 22 2024/09/05
Modifications
NAVAX Payment Imports extension update.
Version 22.1.0.1
as of Business Central 22 2024/07/23
Corrections
An entry in the license management was mistakenly created during the installation of NCPK konfipay Connector Base. This issue has been resolved and an update routine has been created to delete the entry.