☰ Contents
  Support|  Feedback|  Print|  Share


Import Data


2021/06/30
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. 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 on Transfer if you want to retransfer the deleted row.

Fields

Statement No.Displays the statement number (file info: LglSeqNb).
Statement DateDisplays the statement date (file info: CreDtTm).
Statement fromShows the statement period (file info: FrToDt FrDtTm).
Statement toShows 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 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 IBAN is displayed here. If the accounts are different, no value is displayed.
No. of BalancesShows the number of imported balances.
No. of TransactionsSpecifies the number of imported transactions. For more information, see History, Import Transactions.
Open Journal LinesShows that data has been transferred to a journal and that there are open 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 shown.
For more information, see the Business Central online help, at Working with General Journals
Posted Journal LinesShows 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 LinesShows if data has been transferred to a bank account reconciliation and open reconciliations 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 Reconciliation LinesShows 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 StatementsShows 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 LinesShows 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 CodeShows the ISO bank currency code of the imported data (file info: Acct Ccy).
Additional InformationShows additional information (file info: AddtlInf). For more information, see History, Import Additional Info.
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.

Actions, Process

  • Suggest Bank Account

    This function can help to suggest already used bank accounts. For more information, see Setup, Bank Accounts.

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, Navigate

  • Balances

    The balances from the payments import are listed here. For more information, see History, Import Balances.
  • 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 remittance entries and expenses. For more information, see History, Import Transactions.
  • Open Reconciliations

    This action opens the page Bank Account Reconciliations, where the transfered 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.
  • Additional Info.

    Öffnet die Karte mit den Zusatzinformationen aus dem Group Header (GrpHdr) des Imports. For more information, see Historie, Import Zusatzinformationen.
  • Card

    Opens the card for the selected record. For more information, see Import Data Card.
☰ Contents
Next Topic: Import Balances
  Support|  Feedback|  Print|  Share
DE|EN Imprint
<>