| Docs Help
  AppSource  
Docs  /  NCP Payments  /  Setup  /  Import

Payments Import Setup


2024/03/12 • 9 min. to read
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.

Fields, General

LCY CodeShows the currency code for the local currency. This value has been stored in the General Ledger Setup.
ISO LCY CodeSpecifies the ISO LCY Code, this will be pre-filled with EUR when LCY Code is set to EUR or EURO in the General Ledger Setup and the field has not yet been configured.

Fields, Import

In the Import section, you define which files are allowed to be imported 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.
MT940 - StatementSpecifies if and where the MT940 - Statement data files can be imported and transferred. The following options are available:
  • empty: no import possible, in the import selection dialog the option, MT940 - Statement, does not appear.
  • Import Only: it is possible to import a MT940 file, but not to transfer it to an journal or to the bank account reconciliation.
  • General Journal: it is possible to import a MT940 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.

Fields, Transfer

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, Matching/Application

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 application 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. Use the AssistEdit function to navigate to the list of Fixed Account Allocations.
For more information, see Import Setup, Fixed Account Allocations.
Separators Ext. Document No.Shows the separators that will be used for automatic application in the journals for the external document no. field. The external document no. is then subdivided for the search to achieve a better result. If the field remains empty, the external document no. is used as entered for the search.
Keep Account AllocationsSpecifies that the account allocations are to be retained during automatic matching, even if no documents are found for matching.
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.

Setup, Actions

  • Bank Accounts

    In the window NCP Payments Bank Account Setup all bank accounts that are required for payment transactions are stored or managed. For more information, see General Setup, Bank Account Setup.
  • Import Codes

    Using this action, the window Payments Import Codes can be opened. When a file is imported, different code fields are filled, depending on the imported file format. Here you can enter a more detailed description for these code fields. Using the action Download the codes and their description can be downloaded or updated. For more information, see Import Setup, Import Codes.
  • Currencies

    By using the action the currencies can be set up.
  • Countries/Regions

    By using this action the countries/regions can be set up. For more information, see General Setup, Countries/Regions.

System, Fields

Delete Data Date CalculationThis allows you to specify the period for deleting the data via Payments Export - Delete Data. Only data that is at least 6 months old can be deleted. If the field is empty, the minimum period is used.
Last Date Archived Files deletedShows the date on which Payments Export - Delete Data were last executed.
Archived Files deleted untilSpecifies the date until which archived files were deleted from the clearing entries.

System, Actions

  • NAVAX License Management

    Opens the NAVAX License Management which displays the current license status of the NAVAX extensions. For more information, see Appendix, NAVAX License Management.
  • Delete Data

    By creating a payment file, an entry is made in the clearing entries. The created payment file is also saved there. If necessary, you can use this action to remove the archived payment files from the clearing items.

    Note

    The files can no longer be exported.
    For more information, see Appendix, Payments Import - Delete Data.

See also




Submit feedback for
DE|EN Imprint
<>