Contents
  Support|  Feedback|  Print Page


Payments Import Setup


2020/11/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.

Fields, Import

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

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

License StatusDisplays the license status of the Extension.

Important

The trial version of an extension expires in 30 days. After that the functions of the extension can only be used with a valid license. Please note that the licensing process may take some time. The license can be requested or checked via the action What's New?. This opens a browser window. Click on Send License Request to send an E-Mail with your request. In the next few days you will receive an E-Mail with further information. As soon as the licensing has been completed, the license can be activated via the Update License action.

Note

The licence must be updated once a year via the Update License action. The update is only possible or necessary within the last 30 days before the license expires, or afterwards. Within the last 30 days before the license expires, notes are displayed.
Serial No.Specifies the serial number of the Extension.
VersionSpecifies the currently installed version of the Extension.
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

  • What's New?

    Via What's New? you have access to additional information, documents and resources of the Extension.
  • Update License

    Updates the License of the Extension or checks if it is up to date.
  • Version History

    Views the history, where you can see, which version of the Extension was installed.
  • Send Pmt. Notification Test Message

    This action, gives you the possibility, to test the settings of the payment notice e-mail functionality. If the function is called, the e-mail address to which the payment notice test message is to be sent must be specified in the field Test message to.
  • 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.
Contents
Next Topic: Customs Formats
  Support|  Feedback|  Print Page
DE|EN Imprint