| Docs NCP
  AppSource  
Docs  /  NCP Payments  /  Archive

Import


2023/06/07 • 7 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, Payments Import - 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 DateShows when the data was imported.
Import TimeShows when the data was imported.
Import User IDShows from which user the data was imported.
File FormatShows the file format of the imported file.
Imported FileShows the name of the imported file.
Archived Import File ExistsShows you if an archived import file already exists.
No. of DataShows the number of imported data entries. For more information, see History, Import Data.
No. of Data without Bank AllocationShows 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 NameIf 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 IBANIf 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 TransactionsShows the number of imported transactions. For more information, see History, Import Transactions.
Open Journal LinesShows 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 LinesShows 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 ReconciliationsShows 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 LinesShows 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 StatementsShows 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 LinesShows 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 DateShows when the file was created (File info: CreDtTm).
Message TimeShows when the file was created (File info: CreDtTm).
Message Recipient NameShows the name of the recipient of the file (file info: MsgRcpt Nm).
Additional Info.Shows additional information (file info: AddtlInf). For more information, see History, Import Additional Info..
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 Import Tasks, Working with Payments Import - Import Payment File.

  • 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 Import Tasks, Working with Payments Import - Transfer.

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. For more information, see History, Import Data.

  • 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. For more information, see History, Import Transactions.

  • 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. For more information, see History, Import Remittance Info.

See also



Submit feedback for
DE|EN Imprint
<☰>