| Docs Help
  AppSource  
Docs  /  NCP Payments  /  Archive

Import


2024/06/21 • 21 min. to read
On this page you can see the overview of the imported bank files. For each of the imported files a Import line is created, these in turn can have several transaction lines and remittance info lines. Depending on the imported file format, different fields are populated or used. For more information, see Appendix, Data Structure.

Note

As long as a row has not been posted yet, you can delete it in the journal or reconciliation at any time. Click Transfer if you want to retransfer the deleted line.
In the NCPI Payments Import window you can perform the following actions:

Fields
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 Payments Import Data either by clicking in the field or by selecting the action Navigate > Data.
Bank Account No. If the payments import 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 payments import 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 payments import 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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be displayed.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be displayed.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be displayed.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be displayed.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be displayed.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be displayed.
For more information, see the Business Central online help, at Working with General Journals.
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.

Actions, Process

  • Import

    Click Import to import the file provided by your bank. As long as there are no journal lines or reconciliations for the imported entry, the line can be deleted at any time. Click on Import if you want to re-import the deleted data. For more information, see Tasks, Import, Working with Payments Import.

  • Export Archived Import File

    Starts the download of the archived import file.

Actions, Transfer

  • Transfer

    With this option, entries from the payments import can be transferred to a journal. During the transfer, a corresponding entry is created for each payments import transaction in the Journal or in the Bank Account Reconciliation. If the field Trans. Charges is set to Yes in the Payments Import Setup, an entry is also created for the total charges per transaction. You can either transfer the entire imported file, or individual Payments Import Data, or just individual Payments Import Transactions. For more information, see Tasks, Import, Working with Payments Import.

Actions, Report

  • Import List

    This list shows information about the imported file.

Actions, Navigate

  • Data

    Here the Data from the Payments Import are listed. Each line in the Payments Import window can contain several data lines, which in turn can contain several transactions. The transactions, in turn, can contain several remittance lines and charges.

  • Transactions

    Here the Transactions from the Payments Import are listed. Each line in the Payments Import window can contain several data lines, which in turn can contain several transactions. The transactions, in turn, can contain several remittance lines and charges.

  • Open Reconciliations

    Shows the list with Open Reconciliations if such exist. In the lines you can see the number of open reconciliations in the field Open Reconciliation Lines.

    Note

    This action is only available if the option Bank Acc. Reconciliation has been set up in the Payments Import Setup, in the field camt.053 - Statement or MT940 - Account Statement.

  • Open Journal Lines

    Opens the open journal lines. In the journal it is possible to clear and close open entries based on the imported data.

    Note

    This action is only available if the option General Journal has been set up in the Payments Import Setup, in the field camt.053 - Statement or MT940 - Account Statement.

  • Posted Statement

    In this overview, the posted statements are listed.

    Note

    This action is only available if the option Bank Acc. Reconciliation has been set in the Payments Import Setup, in the fields camt.053 - Account Statement, camt.054 - Debit Credit Notification, MT940 - Account Statement or Custom.

  • Additional Info.

    Opens the card with the additional information from the Group Header (GrpHdr) of the import.

Import Data

On this page you can see the overview of the data entries of the imported bank file. Depending on the imported file format, different fields are filled or used.

Note

As long as a row has not been posted yet, you can delete it in the journal or reconciliation at any time. Click on Transfer if you want to retransfer the deleted row.

Fields
Statement No. Shows the bank statement number (file info: LglSeqNb). The lookup function opens the NCPI Payments Import 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 payments import 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 payments import 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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be shown.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be shown.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be shown.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be shown.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be shown.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Setup, under the respective file format setting, this field may or may not be shown.
For more information, see the Business Central online help, at Working with General Journals.
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 NCPI Payments Import Additional Information page.
Closing Booked last Statement Shows the closing balance of the last booked account statement.
Sum Transaction Amount Shows the total of the booking amounts from the imported bank file.
Closing Booked Shows the current closing balance, reduced by the booking amounts from the imported bank file.
Entry No. Shows the number assigned to the record. The application assigns a unique number to each record.
Import Entry No. This field contains the number of the import.

Import Data, Actions

  • Suggest Bank Account

    This function can help to suggest already used bank accounts.

  • Transfer

    With this option, entries from the payments import can be transferred to a journal. During the transfer, a corresponding entry is created for each payments import transaction in the Journal or in the Bank Account Reconciliation. If the field Trans. Charges is set to Yes in the Payments Import Setup, an entry is also created for the total charges per transaction. You can either transfer the entire imported file, or individual Payments Import Data, or just individual Payments Import Transactions. For more information, see Tasks, Import, Working with Payments Import.

  • Balances

    The balances from the payments import are listed here.

  • Transactions

    The transactions from the payments import are listed here. Each row in the Payments Import window can contain multiple data rows, which in turn can contain multiple transactions. The transactions, in turn, can contain multiple payment remittance entries and expenses.

  • Additional Info.

    Öffnet die Karte mit den Zusatzinformationen aus dem Group Header (GrpHdr) des Imports.

  • Open Reconciliations

    This action opens the page Bank Account Reconciliations, where the transferred entries from import are listed, if any exist.

  • Posted Statements

    This action opens the page Bank Account Statement that shows the posted statements that previously was imported and posted.

Import Balances

This page views the balances from the payments import.

Import Balances, Fields
Type Shows the type of balance (file info: Tp CdOrPrtry Cd).
Amount Shows the amount (file info: Amt).
ISO Currency Code Shows the ISO Currency Code of the balance (file info: Ccy)
Positive Shows whether the balance is positive or negative (file info: CdtDbtInd).
Date Shows the date of the balance (file info: Dt Dt).

Import Transactions

The Import Transactions page lists the transaction of the imported bank file.

Fields
External Account Holder Shows the name of the account holder of the imported transaction (file info: RltdPties Dbtr Nm/RltdPties Cdtr Nm).
External Account Holder Address Shows the address of the account holder of the imported transaction (file info: RltdPties Dbtr PstlAdr AdrLine/RltdPties Cdtr PstlAdr AdrLine).
External IBAN (Bank Account No.) Shows the IBAN or account number of the imported transaction (file info: RltdPties DbtrAcct Id IBAN/RltdPties CdtrAcct Id IBAN (RltdPties DbtrAcct Id Othr Id/RltdPties CdtrAcct Id Othr Id)).
External SWIFT-Code (Bank Branch No.) Shows the SWIFT code or bank branch no. of the imported transaction (file info: RltdAgts DbtrAgt FinInstnId BIC/RltdAgts CdtrAgt FinInstnId BIC (RltdAgts DbtrAgt FinInstnId Othr Id/RltdAgts CdtrAgt FinInstnId Othr Id)).
Order Amount Shows the order amount of the imported transaction (file info: AmtDtls InstdAmt Amt).
Order ISO Currency Code Shows the ISO currency code of the order amount of the imported transaction (file info: AmtDtls InstdAmt Ccy).
Currency Factor Shows the currency factor of the imported transaction. When the transaction entry is transferred to an journal, the amount of the order is converted with the currency factor in case of foreign currency (file Info: Ccy/AmtDtls TxAmt CcyXchg XchgRate).
Positive Shows if the imported transaction is positive or negative (file info: CdtDbtInd).
Reversal Posting Specifies if the imported transaction is a chargeback (return-credit/direct debit and reversal) (file info: RvslInd).
Posting Status Shows the posting status of the transaction (file info: Sts).
Posting Date Shows the posting date of the imported transaction (file info: BookgDt Dt).

Note

Depending on the settings used in the NCPI Payments Import Setup, under Transfer, this field is filled with the appropriate values For more information, see Setup, Import, Payments Import Setup.
Value Date Shows the value date of the imported transaction (file info: ValDt Dt).

Note

Depending on the settings used in the NCPI Payments Import Setup, under Transfer, this field is filled with the appropriate values For more information, see Setup, Import, Payments Import 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, Import, Importcodes.
Transaction Code Description Shows the transaction code Description of the corresponding import code. For more information, see Setup, Import, Importcodes.
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, Import, Importcodes.
SWIFT Transaction Code Description Shows the SWIFT transaction code description of the corresponding import code. For more information, see Setup, Import, Importcodes.
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, Import, Importcodes.
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, Import, Importcodes.
Mandate ID Displays the Mandate ID of the imported transaction (file info: Refs MndtId). For more information, see Setup, Export, 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.

Import Transactions, Actions

  • Transfer

    Allows lines from the payments import to be transferred to an journal. During the transfer, for each payment transaction import, a corresponding line is created in the journal or in the reconciliation. If the option Transfer Charges in the NCPI Payments Import Setup is set to Yes, an entry is also created in the journal or in the reconciliation for the total charges by each transaction. You can either transfer the entire imported file, or individual NCPI Payments Import Data, or just individual NCPI Payments Import Transactions. For more information, see Tasks, Import, Working with Payments Import.

  • Remittance Info.

    Opens the overview of the Remittance Info lines for this Transaction. Each row in the Payments Import window can contain several data entries, which in turn can contain several transactions. The transactions in turn can contain several remittance info. lines and charges.

  • Charges

    Opens the overview of charges for this Transaction. Each row in the Payments Import window can contain several data entries, which in turn can contain several transactions. The transactions in turn can contain several remittance info. lines and charges.

  • Additional Info.

    Opens the overview with the Additional Information for the selected transaction. (Stm/Rpt/Ntfctn)

Import Charges

This page views the charges from the payments import.

Import Charges, Fields
Code Shows the code of the charges (file info: Tp Prtry Id).
Amount Shows the amount (file info: Amt).
ISO Country Code Shows the ISO Currency Code of the balance (file info: Ccy)
Positive Shows whether the balance is positive or negative ( file info: CdtDbtInd).
Total Charges Shows the total charges amount of the transaction.
Open Journal Line exist Indicates that data has been transferred to a journal and that there is an open journal entry.
Posted Journal Line exist Indicates that data has been transferred to a journal and the journal entry has been posted.
Open Reconciliation Line exist Indicates that data has been transferred to a bank account reconciliation journal and there is an open journal entry.
Posted Reconciliation Line exist Indicates that data has been transferred to a bank account reconciliation journal and the journal entry has been posted.

Import Remittance Infos

The remittance info. of the payments import is viewed here.

Import Remittance Infos, Fields
Remittance Info. Shows a part of the intended use.

Import Additional Infos

This page lists the additional information from the NCPI Payment Import Data or NCPI Payment Import Transactions.

Import Additional Infos, Fields
Additional Info. Specifies the additional information from the payments import.

See also



Submit feedback for

Next topic

In this topic

★ Featured App

DE|EN Imprint
<☰>