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 Report
Specifies 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 - Statement
Indicates 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 Notification
Specifies 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.
Custom
Specifies 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.
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 Date
Specifies 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 Date
Indicates 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. Description
Specifies 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. Amount
Specifies 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. Charges
Specifies if the expenses should also be transferred to the General Journal or to the Bank Account Reconciliation.
Source Code from Import
Shows 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. Reconciliation
Shows 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. Accuracy
This 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 Exists
Indicates that fixed allocations to accounts exist.
Note
This indicator is set automatically if allocations exist.
Specifies 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.
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 Amount
Specifies 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.
