Creating OPplus Pmt. Setup Data

Before you can use the Pmt. Import module, it is necessary to specify the initial settings.

To create the initial settings:

  • Select Create Setup Data. Through these initial settings, specific setup fields are filled, among others, with default values as well as the general journals that are used by this module.

Tip

The setup data is created only the first time you select this function thus ensuring that any existing configuration data is not overwritten.

Pmt. Import Tab

Pmt. Import Tab

Tip

Please note that the paths are not available in the SaaS (cloud) solution. To be able to use the functionalities of the output/storage paths in the file import, file export, and CSV ports in an On Prem installation, you must install the "OPplus On Prem Extension".

Auto Accounting I Tab

 Auto Accounting I Tab

Auto Accounting II Tab

Auto Accounting II Tab

Auto Application Tab

The following fields are relevant if the system has made an account assignment. This is only about finding an application.

Auto Application Tab

Auto Application – Example Scenarios for Document No. Offset/Length

Example Scenarios

You can use these fields to specify a certain starting point as well as length for customer document numbers, customer external document numbers, vendor document numbers and vendor external document numbers. These values have an impact on how the system will search for open entries and application in the purpose text.
In the “Offset” field, you can use positive as well as negative integers.
In the “Length” field, you can use only positive integers.

Examples The following examples will show you how the various setups interact.

Positive Value in “Offset“ and “Length” = 0: This example is Pmt. Import on the document number “GB-12345678“. The first 3 digits should be skipped as they do not represent the significant part of the document number but the identification code of the subsidiary. Accordingly, in the setup you will enter “Offset” = 4.

SetupValue
Offset4
Length0
Impact
Doc. No. in purpose text12345678
Doc. No. for applicationGB-12345678

For the application only the search string “12345678“ will be used.

Negative Value in “Offset“ and “Length” = 0: This example is Pmt. Import on the document number “12345678-GB“.The last 3 digits should be skipped as they do not represent the significant part of the document number but the identification code of the subsidiary.

It is possible to enter a negative value in the field “Offset”. For this example “-4”. Using the negative value, the document number is read backwards (from right to left) = “BG-87654321”. Starting point is the 4 but read backwards from the 4th position on.

SetupValue
Offset-4
Length0
Impact
Doc. No. in purpose text12345678
Doc. No. for application12345678-GB

For the application only the search string “12345678“will be used.

Usage of “Length“: It is not possible to specify ONLY a length. If you want to use a fixed length starting with the first position, then you have to enter a 1 in the field “Offset”.

For example you have a document number with 8 digits and at the end a location code for subsidiaries with various lengths e. g. “12345678-ABC-01“.

In the setup you set “Offset” = 1 and “Length” = 8.

SetupValue
Offset1
Length8
Impact
Doc. No. in purpose text12345678
Doc. No. for application12345678-ABC-01

For the application the search string “12345678“ (the first 8 digits) will be used.

Positive Value in “Offset“ and “Length”: Furthermore, there is the possibility to have a prefix at the beginning followed by a document number of fixed length as well as a suffix. For example you have the document number “ABCD-12345678-001“. The first five digits belong to the prefix followed by an eight-digit document number and a four-digit suffix. In the setup you would have to set “Offset” = 6 and “Length” = 8.

SetupValue
Offset6
Length8
Impact
Doc. No. in purpose text12345678
Doc. No. for applicationABCD-12345678-001

For the application the search string “12345678“will be used.

Negative Value in “Offset“ with “Length”: In this example we have a prefix with an unknown length and a three-digit suffix at the end. The length of the document number is 8. In this case, you have to set “Offset” = -4 and “Length” = 8.

Example 1 document number: “111-12345678-GB“

SetupValue
Offset-4
Length8
Impact
Doc. No. in purpose text12345678
Doc. No. for application111-12345678-GB

Example 2 document number: “99999-12345678-GB“

SetupValue
Offset-4
Length8
Impact
Doc. No. in purpose text12345678
Doc. No. for application99999-12345678-GB

In both cases, the document number “12345678“will be used for application.
The string will be rotated by OPplus “BG-87654321-111“ and read from the fourth digit onwards -> 87654321 and subsequently used in the original order -> 12345678. The string will be rotated by OPplus “BG-87654321-99999“ and read from the 4th digit onwards -> 87654321 and subsequently used in the original order -> 12345678.

Backup for values that are too short: The minimum length which will be used as search string by OPplus is four. If a search string will end up too short due to the settings in “Offset” and/or “Length” then the document number will be used as it is stated in the purpose text.

Example 1 - Document number is stated with 9 digits in the purpose text

SetupValue
Offset7
Length0
Impact
Doc. No. in purpose text123456789
Doc. No. for application123456789 - As only 3 digits would remain, the document number will be used as stated.

Example 2 - Document number is stated with 8 digits in the purpose text

SetupValue
Offset-5
Length6
Impact
Doc. No. in purpose text12345678
Doc. No. for application12345678 - As only 4 digits would remain and the length is set to 6 digits, the document number will be used as stated.

Example 3 - Document number is stated with 9 digits in the purpose text

SetupValue
Offset5
Length3
Impact
Doc. No. in purpose text123456789
Doc. No. for application123456789 - As only 5 digits would remain and the length is set to 3 digits, the document number will be used as stated.

Texts tab

Texts tab

To set up texts, you can use the following wildcard characters:

SetupValue
%1document number of the applied entry
%2application amount
%3payment discount amount
%4payment discount %
%5account number
%6account name
%7external document number
%8external document number if filled, otherwise BC-internal document number
%9regarding vendors the external document number if filled, otherwise BC-internal document number; regarding customers always the BC-internal document number
%10document type (1 character)