Contents
  Support|  Feedback|  Print Page


Import Data


2020/11/30
Each line in the window NCPI Payments Import can contain several Data lines, which in turn can contain several Transactions. The transactions, in turn, can contain several Remittance Entries and Charges. Depending on the imported file format, different fields are filled or used. During the transfer, for each NCPI Payments Import Transaction, a corresponding entry is created in the journal or in the Reconciliation. If the field Transf. Charges in the Payments Import Setup is set to Yes, a entry is also created in the 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.

Note

As long as a line has not been posted, it can be deleted at any time in the Journal or in the Reconciliation. Click on Transfer if you wish to transfer the deleted row again.
Structure:

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.
Contents
Next Topic: Import Balances
  Support|  Feedback|  Print Page
DE|EN Imprint