Note
SEPA Direct Debit is only possible for customers.Name | Description |
---|---|
NCPE | NAVAX Payment Exports You need these permissions to use the NAVAX Payment Exports. For more information, see Tasks, Exports, Working with Payment Exports. |
NCPE, SETUP | NAVAX Payment Exp. Setup You need these permissions to set up the NAVAX Payment Exports. For more information, see Setup, Exports, Exports Setup. |
NCPI | NAVAX Payment Imports You need these permissions to use the NAVAX Payment Imports. For more information, see Tasks, Imports, Working with Payment Imports. |
NCPI, SETUP | NAVAX Payment Imp. Setup You need these permissions to set up the NAVAX Payment Imports. For more information, see Setup, Imports, Imports Setup. |
Name | Description |
---|---|
NCPEK | NAVAX konfipay Connector Export You need these permissions to use the NAVAX konfipay Connector Export. For more information, see Tasks, Exports, Working with Payment Exports. |
NCPEK, SETUP | NAVAX konfipay Con. Exp. Setup You need these permissions to set up the NAVAX konfipay Connector Export. For more information, see Setup, konfipay Connector, konfipay Connector Setup. |
NCPIK | NAVAX konfipay Connector Import You need these permissions to use the NAVAX konfipay Connector Import. For more information, see Tasks, Imports, Working with Payment Imports. |
NCPIK, SETUP | NAVAX konfipay Con. Imp. Setup You need these permissions to set up the NAVAX konfipay Connector Import. For more information, see Setup, konfipay Connector, konfipay Connector Setup. |
Note
The Country/Region Code field must be specified for the bank account to be used in payment processing.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. |
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.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. |
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. |
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 |
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. |
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:
|
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. |
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. |
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.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. |
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 |
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:Note
Please note that an online connection is established when downloading the bank codes.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:Note
Please note that older versions of NCP Payment Export cannot be imported with the exported files in JSON format.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. |
SEPA Mandates | Displays the number of SEPA mandates associated with this bank account.
For more information, see Setup, Exports, SEPA-Direct Debit-Mandates.
Note This field is only displayed on a debtor bank account. |
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. |
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:
Tip
Important Note that there is a maximum of 35 characters for the payment reference. |
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.Note
You can skip individual steps at any time and complete the configuration at a later time in the NCP Exports 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. |
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.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. |
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. |
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-MailLCY 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. |
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. |
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. |
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:
|
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:
|
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.
Tip
|
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. |
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. |
EZB Bank Codes URL | Specifies the URL for the download of the bankcodes from European Central Bank |
OENB Bank Codes URL | Specifies the URL for the download of the bankcodes from European Central Bank. |
DBB Bank Codes URL | Specifies the URL for the download of the bankcodes from German National Bank. |
Delete Data Date Calculation | 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. |
Note
The files can no longer be exported.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 | The field Batch Booking determines how the transactions are booked by the bank.
By default, this field remains empty, and the indicator ( Note Only if there is a corresponding agreement with the bank for single bookings, each transaction will be displayed individually on the client's account statement when specifying No. Otherwise, or by default, it is always a batch booking (default/pre-agreed: Yes). |
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:
|
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. |
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:
|
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. |
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.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. |
Note
SEPA direct debits can only be executed for documents with the currency EURO.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. |
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.camt.052 - Account Report | Specifies if and where the camt.052 - Account Report files can be imported and transferred
The following options are available:
|
camt.53 - Statement | Indicates whether, and if so, where the camt.053 - Statement files can be imported and transferred.
The following options are available:
|
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:
|
Custom | Specifies if and where the Custom Files can be imported and transferred.
The following options are available:
|
Custom Formats Exists | Shows if custom formats are available. |
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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. |
Document No. Alloc. Accuracy | This can have an impact on automatic assignment of the customer ledger entry.
The following options are available:
|
Fixed Account Allocations Exists | Indicates that fixed allocations to accounts exist.
Note This indicator is set automatically if allocations exist. |
Keep Account Allocations | 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. |
Matching Date Tolerance (Days) | 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. |
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. |
camt.052 - Account Report | Specifies if and where the camt.052 - Account Report files can be imported and transferred
The following options are available:
|
camt.53 - Statement | Indicates whether, and if so, where the camt.053 - Statement files can be imported and transferred.
The following options are available:
|
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:
|
MT940 - Statement | Specifies if and where the MT940 - Statement data files can be imported and transferred.
The following options are available:
|
Custom | Specifies if and where the Custom Files can be imported and transferred.
The following options are available:
|
Custom Formats Exists | Shows if custom formats are available. |
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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. |
Document No. Alloc. Accuracy |
This can have an impact on automatic application of the customer ledger entry.
The following options are available:
|
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. |
Keep 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. |
Matching Date Tolerance (Days) | 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. |
Delete Data Date Calculation | 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. |
Note
The files can no longer be exported.Note
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. |
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. |
Type | Specifies the type of the code.
The following options are available:
|
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. |
The Download action can be used to download or update the codes.
With the action Download - Save as the codes can be downloaded and saved. No changes in the database will be made.
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.
With the Export action, the codes can be exported to a file. This exported file can be used for import into other databases.
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:
|
Account Type | Specify the account type for the assignment.
The following options are available:
|
Account No. | Select the account no. from your chart of accounts to be used for the mapping. |
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. |
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. |
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. |
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. |
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. |
Note
Please note that when using konfipay, additional costs may apply.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.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. |
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 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
Note This field is only available if the indicator Summarize per Vendor or Summarize per Customer is set. |
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:
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.
|
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 |
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.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. |
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:
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:
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.
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:
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. |
Payment Status | 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. |
Note
Document Numbers that have been used in other suggestions are not renumbered.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. |
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. |
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. |
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.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.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.Tip
Files can also be imported over the Dropzone for Bank Files by Drag & Drop. For more information, see Import Tasks, Import Payment File.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.Note
You define the possible file types in the NCP Imports SetupNote
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.Note
It is also possible to click on the Dropzone. In this case a file selector appears where you can select a single file.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.Note
This only applies to those lines for which the Applied indicator is not setNote
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.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.Important
You can delete a line at any time if it has not yet been posted.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.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. |
Create and post the missing entry. For information on a quick way to initiate this, see unter To create missing ledger entries to match bank transactions with in Business Central Online Help. |
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. |
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. |
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. |
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.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.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.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. |
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. |
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. |
Important
Use this indicator for information purposes only (analysis). To perform and post a application, this indicator must be deactivated.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. | Shows the account number. |
Account Name | Shoes the account name. |
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. |
Ext. Account Info found in | Shows where a account no. was found based on the information of the transaction. |
Account Rating | Shows the rating for the search for the amount. |
Rating | Shows the total rating for the assignment. |
Include Lines without Deviation | Specifies if also lines without deviation should be printed in the report. |
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. |
NCP No. of Payment Entries | Number of payment entries relating to this bank account ledger entry are listet here. |
Status | Shows the status for the Clearing Entry.
Options:
|
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. |
Status | Shows the status for the payment entry.
Options:
|
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:
|
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. |
Mandate ID | Shows which settings for the mandate id were used to create the payment file. For more information, see Setup, Exports, SEPA-Direct Debit-Mandates. |
Date of Mandate | Shows which settings for the mandate were used to create the payment file. For more information, see Setup, Exports, SEPA-Direct Debit-Mandates. |
Payment Reference | Shows the payment reference of the transaction. |
Charges | 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. |
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. |
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.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:
|
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:
|
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:
|
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:
|
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:
|
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 Information for Developers, 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. |
Clearing Entry No. | Shows the entry number of the related clearing entry. |
Type | Shows what type of payment file it is.
Possible values:
|
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. |
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. |
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:
|
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:
|
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:
|
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:
|
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 Information for Developers, 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. |
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.Import Date | Shows when the data was imported. |
Import Time | Shows when the data was imported. |
Import User ID | Shows from which user the data was imported. |
File Format | Shows the file format of the imported file. |
Imported File | Shows the name of the imported file. |
Archived Import File Exists | 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. |
Posted Journal Lines | Shows if data has been transferred to an general journal and general journal lines have been posted.
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. |
Open Reconciliations | Shows if data has been transferred to an reconciliation and if there are open reconciliation 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. |
Posted Reconciliation Lines | Shows if data has been transferred to an reconciliation and reconciliation lines have been posted.
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. |
Posted Statements | Shows if data has been transferred to a bank account reconciliation and posted statements are available.
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. |
Posted Statement Lines | Shows if data has been transferred to a bank account reconciliation and if there are posted statement 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. |
Message Date | 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. |
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.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.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.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.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. |
Posted Journal Lines | Shows if data has been transferred to a journal and journal lines have been posted.
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. |
Open Reconciliation Lines | 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. |
Posted Reconciliation Lines | Shows if data has been transferred to a bank account reconciliation and if there are posted reconciliation 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 shown. |
Posted Statements | Shows if data has been transferred to a bank account reconciliation and posted statements exist.
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. |
Posted Statement Lines | Shows if data has been transferred to a bank account reconciliation and posted statement lines exist.
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. |
IBAN (Bank Account No.) | 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. |
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). |
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. |
Mandate ID | Displays the Mandate ID of the imported transaction (file info: Refs MndtId). For more information, see Setup, Exports, SEPA-Direct Debit-Mandates. |
Check No. | 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. |
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. |
Remittance Info. | Shows a part of the intended use. |
Additional Info. | Specifies the additional information from the NCP Imports. |
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.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. |
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. |
[IntegrationEvent(false, false)]
local procedure OnAfterCreateRemitInfoText(NCPPaymentRemittanceEntry: Record "NCP Payment Remittance Entry"; GenJournalLine: Record "Gen. Journal Line"; var TempRmtInfo: Text[140])
begin
end;
Type | Name | Description |
---|---|---|
Record "NCP Payment Remittance Entry" | NCPPaymentRemittanceEntry | The payment remittance entry that contains the information from imported file. |
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the payment remittance entry. |
Text[140] | TempRmtInfo | [Pass by Reference] The generated remittance text that can be customized. This text is the result of the function. |
[IntegrationEvent(false, false)]
local procedure OnBeforeCalcVendLedgEntryStep1CheckOldVendLedgerEntry(GenJournalLine: Record "Gen. Journal Line"; var TempOldVendorLedgerEntry: Record "Vendor Ledger Entry" temporary)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the vendor ledger entry. |
Record "Vendor Ledger Entry" temporary | TempOldVendorLedgerEntry | [Temporary][Pass by Reference] The old vendor ledger entry that is used to calculate the new vendor ledger entry. |
[IntegrationEvent(false, false)]
local procedure OnBeforeCalcVendLedgEntryStep1OnBeforeFindVendLedgerEntry(var GenJournalLine: Record "Gen. Journal Line"; var ApplyingDate: Date; var TempOldVendorLedgerEntry: Record "Vendor Ledger Entry" temporary; var Result: Boolean; var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | [Pass by Reference] The general journal line that is used to create the vendor ledger entry. |
Date | ApplyingDate | [Pass by Reference] The applying date that is used to calculate the vendor ledger entry. |
Record "Vendor Ledger Entry" temporary | TempOldVendorLedgerEntry | [Temporary][Pass by Reference] The old vendor ledger entry that is used to calculate the new vendor ledger entry. |
Boolean | Result | [Pass by Reference] The result of the function that determines if the vendor ledger entry is found. |
Boolean | IsHandled | [Pass by Reference] Indicates if the vendor ledger entry is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnBeforeCalcVendLedgEntryStep2(var GenJournalLine: Record "Gen. Journal Line"; var AmountToApply: Decimal; var PmtTolAmtToBeApplied: Decimal; var RemainingAmount: Decimal; var LineAmount: Decimal; var LineDiscount: Decimal; var AppliedAmount: Decimal; var TempOldVendorLedgerEntry: Record "Vendor Ledger Entry" temporary; var OldVendorLedgerEntry: Record "Vendor Ledger Entry" temporary; Vendor: Record Vendor; var Completed: Boolean; var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | [Pass by Reference] The general journal line that is used to create the vendor ledger entry. |
Decimal | AmountToApply | [Pass by Reference] The amount that is applied to the vendor ledger entry. |
Decimal | PmtTolAmtToBeApplied | [Pass by Reference] The payment tolerance amount that is applied to the vendor ledger entry. |
Decimal | RemainingAmount | [Pass by Reference] The remaining amount that is applied to the vendor ledger entry. |
Decimal | LineAmount | [Pass by Reference] The line amount that is applied to the vendor ledger entry. |
Decimal | LineDiscount | [Pass by Reference] The line discount that is applied to the vendor ledger entry. |
Decimal | AppliedAmount | [Pass by Reference] The applied amount that is applied to the vendor ledger entry. |
Record "Vendor Ledger Entry" temporary | TempOldVendorLedgerEntry | [Temporary][Pass by Reference] The old vendor ledger entry that is used to calculate the new vendor ledger entry. |
Record "Vendor Ledger Entry" temporary | OldVendorLedgerEntry | [Temporary][Pass by Reference] The vendor ledger entry that is used to calculate the new vendor ledger entry. |
Record Vendor | Vendor | The vendor that is used to create the vendor ledger entry. |
Boolean | Completed | [Pass by Reference] Indicates if the calculation is completed. |
Boolean | IsHandled | [Pass by Reference] Indicates if the vendor ledger entry is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnBeforeCalcCustLedgEntryStep1CheckOldCustLedgerEntry(GenJournalLine: Record "Gen. Journal Line"; var TempOldCustLedgerEntry: Record "Cust. Ledger Entry" temporary)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the customer ledger entry. |
Record "Cust. Ledger Entry" temporary | TempOldCustLedgerEntry | [Temporary][Pass by Reference] The old customer ledger entry that is used to calculate the new customer ledger entry. |
[IntegrationEvent(false, false)]
local procedure OnBeforeCalcCustLedgEntryStep1OnBeforeFindCustLedgerEntry(var GenJournalLine: Record "Gen. Journal Line"; var ApplyingDate: Date; var TempOldCustLedgerEntry: Record "Cust. Ledger Entry" temporary; var Result: Boolean; var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | [Pass by Reference] The general journal line that is used to create the customer ledger entry. |
Date | ApplyingDate | [Pass by Reference] The applying date that is used to calculate the customer ledger entry. |
Record "Cust. Ledger Entry" temporary | TempOldCustLedgerEntry | [Temporary][Pass by Reference] The old customer ledger entry that is used to calculate the new customer ledger entry. |
Boolean | Result | [Pass by Reference] The result of the function that determines if the customer ledger entry is found. |
Boolean | IsHandled | [Pass by Reference] Indicates if the customer ledger entry is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnBeforeCalcCustLedgEntryStep2(var GenJournalLine: Record "Gen. Journal Line"; var AmountToApply: Decimal; var PmtTolAmtToBeApplied: Decimal; var RemainingAmount: Decimal; var LineAmount: Decimal; var LineDiscount: Decimal; var AppliedAmount: Decimal; var OldCustLedgerEntry: Record "Cust. Ledger Entry" temporary; Customer: Record Customer; var Completed: Boolean; var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | [Pass by Reference] The general journal line that is used to create the customer ledger entry. |
Decimal | AmountToApply | [Pass by Reference] The amount that is applied to the customer ledger entry. |
Decimal | PmtTolAmtToBeApplied | [Pass by Reference] The payment tolerance amount that is applied to the customer ledger entry. |
Decimal | RemainingAmount | [Pass by Reference] The remaining amount that is applied to the customer ledger entry. |
Decimal | LineAmount | [Pass by Reference] The line amount that is applied to the customer ledger entry. |
Decimal | LineDiscount | [Pass by Reference] The line discount that is applied to the customer ledger entry. |
Decimal | AppliedAmount | [Pass by Reference] The applied amount that is applied to the customer ledger entry. |
Record "Cust. Ledger Entry" temporary | OldCustLedgerEntry | [Temporary][Pass by Reference] The old customer ledger entry that is used to calculate the new customer ledger entry. |
Record Customer | Customer | The customer that is used to create the customer ledger entry. |
Boolean | Completed | [Pass by Reference] Indicates if the calculation is completed. |
Boolean | IsHandled | [Pass by Reference] Indicates if the customer ledger entry is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnBeforeInitLanguageRecords(var NCPLanguageSetup: Record "NCP Language Setup"; var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "NCP Language Setup" | NCPLanguageSetup | [Pass by Reference] The NCP language setup that is used to initialize the language records. |
Boolean | IsHandled | [Pass by Reference] Indicates if the language records are handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnAfterInitLanguageRecords(var NCPLanguageSetup: Record "NCP Language Setup")
begin
end;
Type | Name | Description |
---|---|---|
Record "NCP Language Setup" | NCPLanguageSetup | [Pass by Reference] The NCP language setup that is used to initialize the language records. |
[IntegrationEvent(false, false)]
local procedure OnAfterInitSEPACountries(var TempCountryRegion: Record "Country/Region")
begin
end;
Type | Name | Description |
---|---|---|
Record "Country/Region" | TempCountryRegion | The country/region that is used to initialize the SEPA countries/regions. |
[IntegrationEvent(false, false)]
local procedure OnBeforeOnPreReportEvent(Vendor: Record Vendor; VendorLedgerEntry: Record "Vendor Ledger Entry")
begin
end;
Type | Name | Description |
---|---|---|
Record Vendor | Vendor | The vendor that is used to create the payment suggestion. |
Record "Vendor Ledger Entry" | VendorLedgerEntry | The vendor ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnAfterPreReport(var Vendor: Record Vendor; var VendorLedgerEntry: Record "Vendor Ledger Entry")
begin
end;
Type | Name | Description |
---|---|---|
Record Vendor | Vendor | [Pass by Reference] The vendor that is used to create the payment suggestion. |
Record "Vendor Ledger Entry" | VendorLedgerEntry | [Pass by Reference] The vendor ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnAfterIncludeVendor(Vendor: Record Vendor; VendorBalance: Decimal; var Result: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record Vendor | Vendor | The vendor that is used to create the payment suggestion. |
Decimal | VendorBalance | The balance of the vendor that is used to create the payment suggestion. |
Boolean | Result | [Pass by Reference] The result of the function that determines if the vendor is included in the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnGetVendLedgEntriesOnBeforeLoop(var VendorLedgerEntry: Record "Vendor Ledger Entry"; PostingDate: Date; LastDueDateToPayReq: Date; Future: Boolean; var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Vendor Ledger Entry" | VendorLedgerEntry | The vendor ledger entry that is used to create the payment suggestion. |
Date | PostingDate | The posting date that is used to create the payment suggestion. |
Date | LastDueDateToPayReq | The last due date that is used to create the payment suggestion. |
Boolean | Future | Indicates if the vendor ledger entry is in the future. |
Boolean | IsHandled | [Pass by Reference] Indicates if the vendor ledger entry is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnBeforeHandledVendLedgEntry(VendorLedgerEntry: Record "Vendor Ledger Entry"; LocGenJournalLine: Record "Gen. Journal Line"; HandledEntry: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Vendor Ledger Entry" | VendorLedgerEntry | The vendor ledger entry that is used to create the payment suggestion. |
Record "Gen. Journal Line" | LocGenJournalLine | The general journal line that is used to create the vendor ledger entry. |
Boolean | HandledEntry | [Pass by Reference] Indicates if the vendor ledger entry is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnAfterGetVendLedgEntries(var VendorLedgerEntry: Record "Vendor Ledger Entry"; Vendor: Record Vendor; PostingDate: Date; LastDueDateToPayReq: Date; UsePriority: Boolean; UseDueDateAsPostingDate: Boolean; DueDateOffset: DateFormula; Positive: Boolean; Future: Boolean; PayableVendorLedgerEntry: Record "Payable Vendor Ledger Entry"; NextEntryNo: Integer)
begin
end;
Type | Name | Description |
---|---|---|
Record "Vendor Ledger Entry" | VendorLedgerEntry | The vendor ledger entry that is used to create the payment suggestion. |
Record Vendor | Vendor | The vendor that is used to create the payment suggestion. |
Date | PostingDate | The posting date that is used to create the payment suggestion. |
Date | LastDueDateToPayReq | The last due date that is used to create the payment suggestion. |
Boolean | UsePriority | Indicates if the priority is used to create the payment suggestion. |
Boolean | UseDueDateAsPostingDate | Indicates if the due date is used as the posting date to create the payment suggestion. |
DateFormula | DueDateOffset | The due date offset that is used to create the payment suggestion. |
Boolean | Positive | Indicates if the vendor ledger entry is positive. |
Boolean | Future | Indicates if the vendor ledger entry is in the future. |
Record "Payable Vendor Ledger Entry" | PayableVendorLedgerEntry | The payable vendor ledger entry that is used to create the payment suggestion. |
Integer | NextEntryNo | The next entry number that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnBeforeLoopPayableVendorLedgerEntry(var PayableVendorLedgerEntry: Record "Payable Vendor Ledger Entry"; var SummarizePerVend: Boolean);
begin
end;
Type | Name | Description |
---|---|---|
Record "Payable Vendor Ledger Entry" | PayableVendorLedgerEntry | The payable vendor ledger entry that is used to create the payment suggestion. |
Boolean | SummarizePerVend | [Pass by Reference] Indicates if the vendor ledger entries are summarized per vendor. |
[IntegrationEvent(false, false)]
local procedure OnBeforePayableVendorLedgerEntryLoop(var PayableVendorLedgerEntry: Record "Payable Vendor Ledger Entry"; var OriginalAmountAvailable: Decimal; var AmountAvailable: Decimal; var StopPayments: Boolean; Future: Boolean; Vendor: Record Vendor; SummarizePerVendor: Boolean; var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Payable Vendor Ledger Entry" | PayableVendorLedgerEntry | The payable vendor ledger entry that is used to create the payment suggestion. |
Decimal | OriginalAmountAvailable | [Pass by Reference] The original amount that is available for payment. |
Decimal | AmountAvailable | [Pass by Reference] The amount that is available for payment. |
Boolean | StopPayments | [Pass by Reference] Indicates if the payments are stopped. |
Boolean | Future | Indicates if the vendor ledger entry is in the future. |
Record Vendor | Vendor | The vendor that is used to create the payment suggestion. |
Boolean | SummarizePerVendor | Indicates if the vendor ledger entries are summarized per vendor. |
Boolean | IsHandled | [Pass by Reference] Indicates if the vendor ledger entry is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
procedure OnCopyPayVendorLedgerEntryFromVendorLedgerEntry(var PayableVendorLedgerEntry: Record "Payable Vendor Ledger Entry"; VendorLedgerEntry: Record "Vendor Ledger Entry");
begin
end;
Type | Name | Description |
---|---|---|
Record "Payable Vendor Ledger Entry" | PayableVendorLedgerEntry | The payable vendor ledger entry that is used to create the payment suggestion. |
Record "Vendor Ledger Entry" | VendorLedgerEntry | The vendor ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnUpdateTempNCPEPaymentBufferFromVendorLedgerEntry(var TempNCPEPaymentBuffer: Record "NCPE Payment Buffer" temporary; VendorLedgerEntry: Record "Vendor Ledger Entry")
begin
end;
Type | Name | Description |
---|---|---|
Record "NCPE Payment Buffer" temporary | TempNCPEPaymentBuffer | [Temporary] The temporary buffer that is used to create the payment suggestion. |
Record "Vendor Ledger Entry" | VendorLedgerEntry | The vendor ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnAfterLoopPayableVendorLedgerEntry(var Vendor: Record Vendor; var CurrencyBalance: Decimal; GlobalLastDueDateToPay: Date; PostingDate: Date; UsePaymentDisc: Boolean; LastPmtDiscDateToPay: Date; NCPPaymentType: Option)
begin
end;
Type | Name | Description |
---|---|---|
Record Vendor | Vendor | [Pass by Reference] The vendor that is used to create the payment suggestion. |
Decimal | CurrencyBalance | [Pass by Reference] The currency balance that is used to create the payment suggestion. |
Date | GlobalLastDueDateToPay | The global last due date that is used to create the payment suggestion. |
Date | PostingDate | The posting date that is used to create the payment suggestion. |
Boolean | UsePaymentDisc | Indicates if the payment discount is used to create the payment suggestion. |
Date | LastPmtDiscDateToPay | The last payment discount date that is used to create the payment suggestion. |
Option | NCPPaymentType | The payment type that is used to create the payment suggestion. |
[IntegrationEvent(true, false)]
local procedure OnAfterOnPostVendorDataItem(var Vendor: Record Vendor;
GenJournalLine: Record "Gen. Journal Line";
GenJournalBatch: Record "Gen. Journal Batch";
GenJournalTemplate: Record "Gen. Journal Template";
BankPmtType: Enum "Bank Payment Type";
NCPEPmtType: Option;
PostingDate: Date;
LastDueDateToPay: Date;
UsePaymentDisc: Boolean;
LastPmtDiscDateToPay: Date;
GenJournalLineInserted: Boolean;
LastLineNo: Integer;
NextDocNo: Code[20];
var Dialog: Dialog;
BalAccountType: Enum "Gen. Journal Account Type";
BalAccountNo: Code[20])
begin
end;
Type | Name | Description |
---|---|---|
Record Vendor | Vendor | [Pass by Reference] The vendor that is used to create the payment suggestion. |
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the vendor ledger entry. |
Record "Gen. Journal Batch" | GenJournalBatch | The general journal batch that is used to create the vendor ledger entry. |
Record "Gen. Journal Template" | GenJournalTemplate | The general journal template that is used to create the vendor ledger entry. |
Enum "Bank Payment Type" | BankPmtType | The bank payment type that is used to create the payment suggestion. |
Option | NCPEPmtType | The NCPE payment type that is used to create the payment suggestion. |
Date | PostingDate | The posting date that is used to create the payment suggestion. |
Date | LastDueDateToPay | The last due date that is used to create the payment suggestion. |
Boolean | UsePaymentDisc | Indicates if the payment discount is used to create the payment suggestion. |
Date | LastPmtDiscDateToPay | The last payment discount date that is used to create the payment suggestion. |
Boolean | GenJournalLineInserted | [Pass by Reference] Indicates if the general journal line is inserted. |
Integer | LastLineNo | The last line number that is used to create the payment suggestion. |
Code[20] | NextDocNo | The next document number that is used to create the payment suggestion. |
Dialog | Dialog | [Pass by Reference] The dialog that is used to create the payment suggestion. |
Enum "Gen. Journal Account Type" | BalAccountType | The general journal account type that is used to create the payment suggestion. |
Code[20] | BalAccountNo | The general journal account number that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnBeforeCheckBalance(Vendor: Record Vendor; Result: Boolean; IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record Vendor | Vendor | The vendor that is used to create the payment suggestion. |
Boolean | Result | [Pass by Reference] The result of the function that determines if the balance is checked. |
Boolean | IsHandled | [Pass by Reference] Indicates if the balance is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnBeforeNCPEGetExternalBankAccount(var GenJournalLine: Record "Gen. Journal Line";
TempNCPEPaymentBuffer: Record "NCPE Payment Buffer";
NCPEPmtType: Option " ","Direct Debit Suggestion","Credit Transfer Suggestion","Non-SEPA Credit Transfer",,"SEPA Credit Transfer","SEPA Direct Debit";
CountryRegion: Record "Country/Region";
NCPBankAccountSetup: Record "NCP Bank Account Setup";
NCPESetup: Record "NCPE Setup";
ExternalBankAccountCode: Code[20];
IsHandled: Boolean);
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the payment suggestion. |
Record "NCPE Payment Buffer" | TempNCPEPaymentBuffer | The temporary buffer that is used to create the payment suggestion. |
Option | NCPEPmtType | The NCPE payment type that is used to create the payment suggestion. |
Record "Country/Region" | CountryRegion | The country/region that is used to create the payment suggestion. |
Record "NCP Bank Account Setup" | NCPBankAccountSetup | The NCP bank account setup that is used to create the payment suggestion. |
Record "NCPE Setup" | NCPESetup | The NCPE setup that is used to create the payment suggestion. |
Code[20] | ExternalBankAccountCode | The external bank account code that is used to create the payment suggestion. |
Boolean | IsHandled | [Pass by Reference] Indicates if the external bank account is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnBeforeUpdateGnlJnlLineDimensionsFromTempNCPEPaymentBuffer(var GenJournalLine: Record "Gen. Journal Line"; TempNCPEPaymentBuffer: Record "NCPE Payment Buffer" temporary; SummarizePerVend: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the payment suggestion. |
Record "NCPE Payment Buffer" temporary | TempNCPEPaymentBuffer | [Temporary] The temporary buffer that is used to create the payment suggestion. |
Boolean | SummarizePerVend | Indicates if the vendor ledger entries are summarized per vendor. |
[IntegrationEvent(false, false)]
local procedure OnMakeGenJnlLinesOnBeforeTempNCPEPaymentBufferInsertNonSummarize(var TempNCPEPaymentBuffer: Record "NCPE Payment Buffer" temporary; VendorLedgerEntry: Record "Vendor Ledger Entry"; SummarizePerVend: Boolean; NextDocNo: Code[20])
begin
end;
Type | Name | Description |
---|---|---|
Record "NCPE Payment Buffer" temporary | TempNCPEPaymentBuffer | [Temporary] The temporary buffer that is used to create the payment suggestion. |
Record "Vendor Ledger Entry" | VendorLedgerEntry | The vendor ledger entry that is used to create the payment suggestion. |
Boolean | SummarizePerVend | Indicates if the vendor ledger entries are summarized per vendor. |
Code[20] | NextDocNo | The next document number that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnMakeGenJnlLinesOnBeforeUpdateTempNCPEPaymentBufferAmounts(var TempNCPEPaymentBuffer: Record "NCPE Payment Buffer" temporary; VendorLedgerEntry: Record "Vendor Ledger Entry"; SummarizePerVend: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "NCPE Payment Buffer" temporary | TempNCPEPaymentBuffer | [Temporary] The temporary buffer that is used to create the payment suggestion. |
Record "Vendor Ledger Entry" | VendorLedgerEntry | The vendor ledger entry that is used to create the payment suggestion. |
Boolean | SummarizePerVend | Indicates if the vendor ledger entries are summarized per vendor. |
[IntegrationEvent(false, false)]
local procedure OnBeforeOnPreReportEvent(Customer: Record Customer; CustLedgerEntry: Record "Cust. Ledger Entry")
begin
end;
Type | Name | Description |
---|---|---|
Record Customer | Customer | The customer that is used to create the payment suggestion. |
Record "Cust. Ledger Entry" | CustLedgerEntry | The customer ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnAfterIncludeCustomer(Customer: Record Customer; CustomerBalance: Decimal; var Result: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record Customer | Customer | The customer that is used to create the payment suggestion. |
Decimal | CustomerBalance | The balance of the customer that is used to create the payment suggestion. |
Boolean | Result | [Pass by Reference] The result of the function that determines if the customer is included in the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnGetCustLedgEntriesOnBeforeLoop(var CustLedgerEntry: Record "Cust. Ledger Entry"; PostingDate: Date; LastDueDateToPayReq: Date; Future: Boolean; var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Cust. Ledger Entry" | CustLedgerEntry | The customer ledger entry that is used to create the payment suggestion. |
Date | PostingDate | The posting date that is used to create the payment suggestion. |
Date | LastDueDateToPayReq | The last due date that is used to create the payment suggestion. |
Boolean | Future | Indicates if the customer ledger entry is in the future. |
Boolean | IsHandled | [Pass by Reference] Indicates if the customer ledger entry is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnAfterGetCustLedgEntries(var CustLedgerEntry: Record "Cust. Ledger Entry";
Customer: Record Customer;
PostingDate: Date;
LastDueDateToPayReq: Date;
UsePriority: Boolean;
UseDueDateAsPostingDate: Boolean;
DueDateOffset: DateFormula;
Positive: Boolean;
Future: Boolean;
PayableCustLedgerEntry: Record "NCPE Payable Cust. Ledg. Entry";
NextEntryNo: Integer)
begin
end;
Type | Name | Description |
---|---|---|
Record "Cust. Ledger Entry" | CustLedgerEntry | The customer ledger entry that is used to create the payment suggestion. |
Record Customer | Customer | The customer that is used to create the payment suggestion. |
Date | PostingDate | The posting date that is used to create the payment suggestion. |
Date | LastDueDateToPayReq | The last due date that is used to create the payment suggestion. |
Boolean | UsePriority | Indicates if the priority is used to create the payment suggestion. |
Boolean | UseDueDateAsPostingDate | Indicates if the due date is used as the posting date to create the payment suggestion. |
DateFormula | DueDateOffset | The due date offset that is used to create the payment suggestion. |
Boolean | Positive | Indicates if the customer ledger entry is positive. |
Boolean | Future | Indicates if the customer ledger entry is in the future. |
Record "NCPE Payable Cust. Ledg. Entry" | PayableCustLedgerEntry | The payable customer ledger entry that is used to create the payment suggestion. |
Integer | NextEntryNo | The next entry number that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnBeforePayableCustomerLedgerEntryLoop(var NCPEPayableCustLedgEntry: Record "NCPE Payable Cust. Ledg. Entry";
var OriginalAmountAvailable: Decimal;
var AmountAvailable: Decimal;
var StopPayments: Boolean;
Future: Boolean;
Customer: Record Customer;
SummarizePerCust: Boolean;
var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "NCPE Payable Cust. Ledg. Entry" | NCPEPayableCustLedgEntry | The payable customer ledger entry that is used to create the payment suggestion. |
Decimal | OriginalAmountAvailable | [Pass by Reference] The original amount that is available for payment. |
Decimal | AmountAvailable | [Pass by Reference] The amount that is available for payment. |
Boolean | StopPayments | [Pass by Reference] Indicates if the payments are stopped. |
Boolean | Future | Indicates if the customer ledger entry is in the future. |
Record Customer | Customer | The customer that is used to create the payment suggestion. |
Boolean | SummarizePerCust | Indicates if the customer ledger entries are summarized per customer. |
Boolean | IsHandled | [Pass by Reference] Indicates if the customer ledger entry is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
procedure OnCopyPayableCustLedgerEntryFromCustLedgerEntry(var NCPEPayableCustLedgEntry: Record "NCPE Payable Cust. Ledg. Entry"; CustLedgerEntry: Record "Cust. Ledger Entry");
begin
end;
Type | Name | Description |
---|---|---|
Record "NCPE Payable Cust. Ledg. Entry" | NCPEPayableCustLedgEntry | The payable customer ledger entry that is used to create the payment suggestion. |
Record "Cust. Ledger Entry" | CustLedgerEntry | The customer ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnBeforeCheckBalance(Customer: Record Customer; Result: Boolean; IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record Customer | Customer | The customer that is used to create the payment suggestion. |
Boolean | Result | [Pass by Reference] The result of the function that determines if the balance is checked. |
Boolean | IsHandled | [Pass by Reference] Indicates if the balance is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnBeforeUpdateGnlJnlLineDimensionsFromTempNCPEPaymentBuffer(var GenJournalLine: Record "Gen. Journal Line"; NCPEPaymentBuffer: Record "NCPE Payment Buffer" temporary; SummarizePerCust: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the payment suggestion. |
Record "NCPE Payment Buffer" temporary | NCPEPaymentBuffer | [Temporary] The temporary buffer that is used to create the payment suggestion. |
Boolean | SummarizePerCust | Indicates if the customer ledger entries are summarized per customer. |
[IntegrationEvent(false, false)]
local procedure OnUpdateTempNCPEPaymentBufferFromCustomerLedgerEntry(var NCPEPaymentBuffer: Record "NCPE Payment Buffer" temporary; CustLedgerEntry: Record "Cust. Ledger Entry")
begin
end;
Type | Name | Description |
---|---|---|
Record "NCPE Payment Buffer" temporary | NCPEPaymentBuffer | [Temporary] The temporary buffer that is used to create the payment suggestion. |
Record "Cust. Ledger Entry" | CustLedgerEntry | The customer ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnBeforeVendorRemittanceInfoInsert(var NCPPaymentRemittanceEntry: Record "NCP Payment Remittance Entry"; OldVendorLedgerEntry: Record "Vendor Ledger Entry")
begin
end;
Type | Name | Description |
---|---|---|
Record "NCP Payment Remittance Entry" | NCPPaymentRemittanceEntry | The NCPE payment remittance entry that is used to create the payment suggestion. |
Record "Vendor Ledger Entry" | OldVendorLedgerEntry | The old vendor ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnBeforeCustomerRemittanceInfoInsert(var NCPPaymentRemittanceEntry: Record "NCP Payment Remittance Entry"; OldCustLedgerEntry: Record "Cust. Ledger Entry")
begin
end;
Type | Name | Description |
---|---|---|
Record "NCP Payment Remittance Entry" | NCPPaymentRemittanceEntry | The NCPE payment remittance entry that is used to create the payment suggestion. |
Record "Cust. Ledger Entry" | OldCustLedgerEntry | The old customer ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnAfterCreateVendorRemittanceInfo(GenJournalLine: Record "Gen. Journal Line"; var NCPPaymentRemittanceEntry: Record "NCP Payment Remittance Entry"; OldVendorLedgerEntry: Record "Vendor Ledger Entry"; NoOfRmtInfoTextLines: Integer; RmtInfLength: Integer)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the payment suggestion. |
Record "NCP Payment Remittance Entry" | NCPPaymentRemittanceEntry | The NCPE payment remittance entry that is used to create the payment suggestion. |
Record "Vendor Ledger Entry" | OldVendorLedgerEntry | The old vendor ledger entry that is used to create the payment suggestion. |
Integer | NoOfRmtInfoTextLines | The number of remittance information text lines that are used to create the payment suggestion. |
Integer | RmtInfLength | The length of the remittance information that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnAfterCreateCustomerRemittanceInfo(GenJournalLine: Record "Gen. Journal Line"; var NCPPaymentRemittanceEntry: Record "NCP Payment Remittance Entry"; OldCustLedgerEntry: Record "Cust. Ledger Entry")
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the payment suggestion. |
Record "NCP Payment Remittance Entry" | NCPPaymentRemittanceEntry | The NCPE payment remittance entry that is used to create the payment suggestion. |
Record "Cust. Ledger Entry" | OldCustLedgerEntry | The old customer ledger entry that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnGenJournalLineCheck(GenJournalLine: Record "Gen. Journal Line")
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnBeforeLoopWriteXMLLine(var TempNCPEXmlSchemaLine: Record "NCPE XML Schema Line" temporary; var GenJournalLine: Record "Gen. Journal Line"; Type: Option Header,OrderHeader,Line,OrderFooter,Footer; var IsHandled: Boolean)
begin
end;
Type | Name | Description |
---|---|---|
Record "NCPE XML Schema Line" temporary | TempNCPEXmlSchemaLine | [Temporary] The temporary XML schema line that is used to create the payment suggestion. |
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the payment suggestion. |
Option | Type | The type of the XML schema line that is used to create the payment suggestion. |
Boolean | IsHandled | [Pass by Reference] Indicates if the XML schema line is handled by custom code. The standard behavior will be skipped. |
[IntegrationEvent(false, false)]
local procedure OnBeforeWriteXMLLineToOutStream(var TempNCPEXMLSchemaLine: Record "NCPE XML Schema Line" temporary; var GenJournalLine: Record "Gen. Journal Line"; TXT: Text)
begin
end;
Type | Name | Description |
---|---|---|
Record "NCPE XML Schema Line" temporary | TempNCPEXMLSchemaLine | [Temporary] The temporary XML schema line that is used to create the payment suggestion. |
Record "Gen. Journal Line" | GenJournalLine | The general journal line that is used to create the payment suggestion. |
Text | TXT | The text that is used to create the payment suggestion. |
[IntegrationEvent(false, false)]
local procedure OnAfterPaymentFileCreatedOnBeforeShowSummary(var SendingGenJournalLine: Record "Gen. Journal Line"; var NCPClearingEntry: Record "NCP Clearing Entry"; var AutoSend: Boolean; var ProgressDialog: Dialog)
begin
end;
Type | Name | Description |
---|---|---|
Record "Gen. Journal Line" | SendingGenJournalLine | The sending general journal line that is used to create the payment suggestion. |
Record "NCP Clearing Entry" | NCPClearingEntry | The NCPE clearing entry that is used to create the payment suggestion. |
Boolean | AutoSend | [Pass by Reference] Indicates if the payment file is sent automatically. |
Dialog | ProgressDialog | The progress dialog that is used to create the payment suggestion. |
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. |
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.Note
Delete Archived Files | Specifies whether the archived files should be deleted. |
Note
Delete Archived Files | Specifies, whether the archived data should be deleted. |
Document Type | Shows the Document Type of the Document for which the QR Code Document Data entry was created.
The following options are available:
|
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:
|
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. |
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. |
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. |
Note
For licensing, calling the online help and performing some actions, access to https://www.navax.app must be granted.Note
Important
For On-Premises an update of the License or the following granules is required:Note
This version is also available as a downgrade version for Business Central 20 and 19.Important
For On-Premises an update of the License or the following granules is required:Important
For On-Premises an update of the License or the following granules is required:Important
For On-Premises an update of the License or the following granules is required:Note
This version is also available as a downgrade version for Business Central 20 and 19.Important
For On-Premises an update of the License or the following granules is required: