Docs  /  NCP Payments  /  Archive

Import Data

2024/04/18 • 6 min. to read

In this topic

• Fields
• Actions
• See also

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.

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

Actions

• Suggest Bank Account

  This function can help to suggest already used bank accounts. For more information, see Setup, 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 Import Tasks, Working with Payments Import - Transfer.

• 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.

• Additional Info.

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

• 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.

See also

• Tasks, Import, Working with Payments Import
• Archive, Import Balances
• Archive, Import Transactions
• Archive, Import Additional Infos
• Appendix, Payments Import - Data Structure