Work with Cash Management schemes, Bank account details, Internal ref rules (FSR71501)

Options

Function keys

Seq no sequence/Rule sequence	Toggle between displaying records in Rule sequence or in Sequence number sequence.
Resequence	Resequence the internal reference rule.
Rtv ref rules	Retrieve pre-defined internal reference rules.

Selection fields

Scheme ID: Displays the selected scheme ID and description for the scheme.

Bank account number: Displays the bank account number.

Bank transaction cd: Displays the bank transaction codes, consisting of the Domain, Family and Sub family.

Settlement: Displays the settlement option defined on Work with Cash Management schemes/Bank account details level. If missing on that level, it is retrieved from the Work with Cash Management schemes/Bank accounts level. The settlement option is used when importing transactions to Work with open batches and controls the settlement rules between the payment and the found invoice/credit note. For more information see Work with settlement options.

Rule ID: This column displays the pre-defined rule ID.

Description: This column displays the description of the rule ID.

Active: This column denotes if the rule ID is active.

Seq no: This column displays the sequence number.

Work with Cash Management schemes, Bank account details, Internal ref rules (FSR71504)

Related topics

On this panel you enter new or maintain the internal reference rules for the applicable Rule ID for a Cash Management scheme.

Scheme ID: Displays the selected scheme ID and description for the scheme.

Bank account number: Displays the bank account number.

Bank transaction cd: Displays the bank transaction codes, consisting of the domain, family and sub family.

Settlement: Displays the settlement option defined on Work with Cash Management schemes/Bank account details level. If missing on that level, it is retrieved from the Work with Cash Management schemes/Bank accounts level. The settlement option is used when importing transactions to Work with open batches and controls the settlement rules between the payment and the found invoice/credit note. For more information see Work with settlement options.

Rule ID

Enter/Displays the rule ID. Integrator marks the reference records with a pre-defined internal reference rule. DC1 interprets and processes the reference record according to the set up for the internal reference rule.

Adding new Rule IDs requires modifications in the Integrator scripts.

Description: Enter/Displays the description of the rule ID.

Active: Set this flag to YES to activate the rule ID. Imported reference lines with an active Rule ID are processed/displayed in selected sequence order in Work with imported bank statements.

Sequence number: Enter/Displays the sequence number. The reference handling will be executed in sequential order.

Transfer ref error

A “reference in error” means that a reference has been found (is valid) according to the set up for correct length (between Min characters and calculated Max characters), Numeric char Y/N and valid according to the Validation program, if it exists, BUT the referred document in A/R is missing or found but it is settled or in wrong period).

This field controls if “references in error” will be transferred from Work with imported statements to Work with open batches. Valid entries in this field include:

Transfer reference error	Work with open batches
0	No transfer of valid references which either did not find the related A/R document, or found but it was settled or in wrong period.
1	Transfer valid references which found related A/R document but it was settled or in wrong period.
2	Transfer valid references which did not find the related A/R document.
3	Transfer. Combine 1 and 2.

Min characters

Enter/Displays the minimum number of characters from the reference string to be used when searching in A/R. If the found number of characters are less than the entered value the reference will be deemed invalid and will not be used.

Example Reference string: 12345 890.
Minimum characters = 5.
The system splits the data into two references (12345 and 890) but only the 12345 portion of the reference is valid to search in A/R.

Numeric characters

Set this field to YES if only numeric characters are to be allowed in the found reference number with a correct length (between Min characters and calculated Max characters) from the reference string. (The Max number of characters is pre-defined. For example the Bank reference number is 35 characters and Document type/number 15 characters.) The validation is done for the selected sequences: Document type/number, Debtor/document number, Document no and Netstore ID.

Set this field to NO if alphanumeric and numeric characters are to be allowed in found reference number.

Example Reference string: 12345 RF329991003002
Numeric characters = Y.
The system selects 12345 to search in A/R.

Add spec single char

In add mode, this field is initiated with the special characters /;:,.<>+- ‘

Leave as is, or enter the additional specific single characters. The entered characters plus a ‘ ‘ (blank char), which the system defaults, is used to separate references in the reference string.

In display mode, this field displays the additional specific single characters used to separate reference in a reference string.

Examples:
Reference string: 12345/89025;67510 89067. If this Add spec single char field is set to /; the system splits the data into four references (12345 and 89025 and 67510 and 89067).

Reference string: 12345/89025;67510. If this Add spec single char field is set to / the system splits the data into two references (12345 and 89025;67510).

Search reference seq

The search for an open document in A/R is controlled by the entered sequence number entered in the Bank reference no, Document type/number, Debtor/document no, Document number, Netstore ID and Extended search pgm fields. The system ends the search in A/R as soon as an open document with a period that is not after the period for the received payment has been found. If no document is found the Extended ref search field controls if an extended search will be performed. Currently, the system checks if the found reference is a debtor number or not.

Bank reference no: Enter the sequence number to search for an open document in A/R with a period that is not after the period for the received payment that has been found.

Document type/number: Enter the sequence number to search for an open document in A/R with a period that is not after the period for the received payment that has been found.

Debtor/document no: Enter the sequence number to search for an open document in A/R with a period that is not after the period for the received payment that has been found.

Document number: Enter the sequence number to search for an open document in A/R with a period that is not after the period for the received payment that has been found.

Netstore ID: This sequence is only applicable for a Cash Management Scheme of type 2 (Netstore/Teller Settlement Report), and cannot be combined with other sequences. Enter the sequence number to retrieve the open document in A/R.

Extended search pgm: If you have created your own program for searching in A/R, enter the sequence number to search in A/R.

Number of characters

Min bank ref number

Enter the minimum number of characters to be classified as a bank reference number.

Example Reference string:

12345 890

(This Min bank ref number field = 5 number of characters).

The system separates the data to 2 references (12345 and 890) but only the 12345 reference is valid to search in A/R.

Fixed document type

Enter a fixed number of characters to be classified as a document type.

Example Reference string:

FKI612345

(This Fixed document type field = 3 number of characters, and the Min document number field = 5 number of characters).

The system separates the reference to Document type FKI and document number 612345 to search in A/R.

Note: Using the Document type/number as your reference requires that the used document types have the same length. You also need to enter the number of minimum characters in the Min document number field.

Fixed debtor number

Enter a fixed number of characters to be classified as a debtor number.

Example Reference string:

100300612345

This Fixed debtor number field = 6 number of characters, and the Min document number field = 5 number of characters).

The system separates the reference to Debtor number 100300 and document number 612345 to search in A/R.

Note: Using the Debtor number/document number as your reference requires that used debtor numbers have the same length. You also need to enter the number of minimum characters in the Min document number field.

Min document number: Enter the minimum number of characters to be classified as a document number for an A/R payment. This field can be used in combination with the Fixed document type or Fixed debtor number fields or stand alone. For more information see the description of those fields above.

Min Netstore ID: This field is only applicable for a Cash Management Scheme of type 2 (Netstore/Teller Settlement Report). Enter the minimum number of characters to be classified as a transaction ID for an A/R payment from Netstore.

Extended search pgm: If you have created your own program for searching in A/R, enter the program name for the Extended search program. (To create an own Extended search program, copy skeleton program FKR417E.)

Extended ref search: Found references search in A/R for the referred invoice/credit note to settle according to the set up. If no A/R document to settle is found, this Extended ref search field controls whether an extended search will be performed or not. If you set this field to 0, no extended search will be performed. If you set this field to 1, the system checks if the found reference could be a debtor number or not.

Validation program: Enter the extended validation program. The program is called to validate the found reference before searching in A/R. The program is called for all sequences except for Bank reference number.