BP number definition

This function defines the business partner (BP) number that is used with the Invoice number as the main criteria for matching imported bank statements to invoices.

Typically, these non-structured numbers are in the bank statement file as part of the reason for the payment. Therefore, for an efficient search during import and matching, you need to define the structure of these numbers so that the process can recognize parts of the payment reason as a BP number.

(missing or bad snippet)

Prerequisites

Refer to the documentation on Implementation.

Actions

Select Create to define a new BP number or select the Edit to modify an existing number.

Click Create to define a new BP number or click the Edit icon to modify an existing number.

Company (field CPY)

Enter a company for this definition.

Site (field FCY)

Enter the site if this definition applies to a single site for this company.

File format (field FILFMT)

Enter or select an existing file format defined in the Bank import format function (BSIFILFMT).

Description (field DES)

Enter a description (optional).

Lines grid

Prefix (field PFX)

Enter the BP number prefix for this BP.

You can create several lines for different prefixes if needed.

Examples:

If all customer numbers start with “D,” (i.e., D001001, D001002, etc.) and all supplier numbers start with “C,” (i.e., C00302”), create two lines, one for each prefix.

If all BP numbers are numeric with different ranges for customers, suppliers, etc., create one line for the starting number of each number range: Consider a customer range of 100000-299999 and supplier ranges of 700000-799999 and 900000-999999. This results in 3 different lines with the following prefixes: 1, 7, and 9.

From number length (field LENINVSTR)

Enter a range for the possible total length of the number including the prefix.

Examples:

If BP numbers have a constant length of 7, (i.e., D001001), enter 7 for the number range.

If the length varies between 7 and 8, enter 7 to 8 as the number range.

A search key is created for each possible length and used during the searching and matching process. Large ranges can increase the time required for the automatic matching process.

To number length (field LENINVENT)

Enter a range for the possible total length of the number including the prefix.

A search key is created for each possible length and used during the searching and matching process.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

The only error messages are the generic ones.