☰ Contents
  Support|  Feedback|  Print|  Share


Payments Import Setup


2021/06/30
Before NCPI Payments Import (NCPI Payments Import) can be used, its basic functionality must be set up. In the window NCPI Payments Import Setup the general settings and defaults are defined.

Note

The import must be set up separately for each company.

Note

You can skip individual steps at any time and complete the configuration at a later time in the NCPE Payments Export Setup.

Fields, Page Import Settings

In the area Import you define which files are allowed for import and where the data should be transferred to.
camt.052 - Account ReportSpecifies if and where the camt.052 - Account Report files can be imported and transferred The following options are available:
  • empty: no import possible, in the import selection dialog the option, camt.52 - Account Report, does not appear
  • Import Only: it is possible to import a camt.52 file, but not to transfer it to an journal or bank account reconciliation
camt.53 - StatementIndicates whether, and if so, where the camt.053 - Statement files can be imported and transferred. The following options are available:
  • empty: no import possible, in the import selection dialog the option, camt.53 - Statement, does not appear.
  • Import Only: it is possible to import a camt.53 file, but not to transfer it to an journal or to the bank account reconciliation.
  • General Journal: it is possible to import a camt.53 file and transfer the imported lines to a General Journal.
  • Bank Acc. Reconciliation: the import of a camt.53 file is possible and the imported lines can be transferred to the bank account reconciliation
camt.54 - Debit Credit NotificationSpecifies if and where the camt.054 - return data files can be imported and transferred. The following options are available:
  • empty: no import possible, in the import selection dialog the option, camt.54 - Debit Credit Notification, does not appear.
  • Import Only: it is possible to import a camt.54 file, but not to transfer it to an journal or to the bank account reconciliation.
  • General Journal: it is possible to import a camt.54 file and transfer the imported lines to a General Journal.
CustomSpecifies if and where the Custom Files can be imported and transferred. The following options are available:
  • empty: no import possible, in the import selection dialog the option, Benutzerdefiniert, does not appear.
  • General Journal: the import of a custom file is possible and the imported lines can be transferred to a General Journal.
For more information, see Setup, Custom Formats.
Custom Formats ExistsShows if custom formats are available.
Standard Import FileSpecifies which file type should be pre-selected during import.

Note

If no value is selected and the field remains empty, no value is preselected.

Fields, Page Transfer Settings

The section Transfer determines the field values in the Journal or the Bank Account Reconciliation. In addition, you can specify here whether Charges should also be transferred or considered.
Trans. Posting DateSpecifies the value with which the entry date is to be filled when it is transferred to an general journal or to the bank account reconciliation. The following options are available:
  • Posting Date/Value Date (Import)
  • Value Date/Posting Date (Import)
  • Posting Date (Import)
  • Value Date (Import)
  • Workdate
Trans. Document DateIndicates if and with what value the document date should be filled when it is transferred to an General Journal or to the Bank Account Reconciliation. The following options are available:
  • Posting Date/Value Date (Import)
  • Value Date/Posting Date (Import)
  • Posting Date (Import)
  • Value Date (Import)
  • Arbeitsdatum
Trans. Document No.Specifies if the document number is to be filled in, and if so, with what value when it is transferred to an General Journal or to the Bank Account Reconciliation. The following options are available:
  • Statement No.
Trans. External Document No.Specifies if the External Document No. should be filled, and if so, with which value when it is transferred to an General Journal or to the Bank Account Reconciliation. The following options are available:
  • Statement No.
Trans. DescriptionSpecifies if the description is to be filled in, and if so, with which value when it is transferred to an General Journal or to the Bank Account Reconciliation. The following options are available:
  • Remittance Info.
  • Transaction Description
  • External Account Holder
Trans. AmountSpecifies if the amount should be filled up with a value when it is transferred to an General Journal or to the Bank Account Reconciliation. The following options are available:
  • Order Amount/Transaction Amount: Initial amount, if available, otherwise transaction amount
  • Transaction Amount
Trans. ChargesSpecifies if the expenses should also be transferred to the General Journal or to the Bank Account Reconciliation.
Source Code from ImportShows the settings in the source code setup. You can click on the AssistEdit button and select an source code in the Trans. Payment Import to Gen. Jnl page.
Source Code from Bank Acc. ReconciliationShows the settings in the origin code setup.

Fields, Page Matching/Application Settings

The setting in the section Matching/Application determine the behavior of the matching or application suggestion. For more information, see Tasks, Applying Open Entries.
Document No. Alloc. AccuracyThis can have an impact on automatic assignment of the customer ledger entry. The following options are available:
  • Sharp (Identical Value) The system searches for the exact value of the document number of the customer ledger entry.
  • Fuzzy (Incl. values without special characters) The system first searches for the exact value of the customer ledger entry document number. If nothing is found, the system then searches for the document number without special characters.
Fixed Account Allocations ExistsIndicates that fixed allocations to accounts exist.

Note

This indicator is set automatically if allocations exist.
For more information, see Import Setup, Fixed Account Allocations.
Show Analysis WindowSpecifies whether a window containing detailed information about the matching should pop up. If you close the window with OK, the suggestion is copied to the journal line or the bank account reconciliation.

Note

Use this indicator for information purposes only. To perform a application, this indicator must be deactivated.
For more information, see Import Allocation Analysis.
Matching Date Tolerance (Days)If you specify a value here, the automatic bank account reconciliation lines will only suggest bank account entries for which the posting date does not differ further from the transaction date.
Check Application AmountSpecifies whether the action Import Suggest Application in the journal should only suggest open journal lines where the remaining amount matches the amount from the import. With the fields Application Tolerance % and Max. Application Tolerance Amount you can specify a tolerance for this check.
Application Tolerance %Tolerance for the application in percent. The amount of the open entry can differ from the imported amount by the percentage in the field Application Tolerance %, but at most by the amount in the field Max. Application Tolerance Amount.

Seite Import Codes Download

The payments import codes are references to various types of transactions. Depending on the imported file format, different code fields are filled in.\nBy default, the table of import codes is empty. You can import the latest import codes via download or import codes from a file. Using the action Download import codes... the codes and their description can be downloaded or updated. For more information, see Import Setup, Import Codes.

Finish setup

If you click on Finish the settings will be saved in the table NCPE Payments Export Setup.
☰ Contents
Next Topic: Payments Import Setup
  Support|  Feedback|  Print|  Share
DE|EN Imprint
<>