These settings enable you to configure the formatting and validation options available for the invoice number field. Several options are displayed or hidden depending on the selected settings. These are indicated below.

Remove Korean Invoice Number

If selected, the system blanks out any extracted invoice numbers for a Korean language document.

Skip For Utility Vendor

If selected and the vendor is identified as a utility vendor, then the invoice number is set to valid and an account number is required instead.

Utility Alias

This is a comma-separated list of values that identify a vendor as a utility vendor. This is compared against the "UtilityFlag" value found in the "Vendor.CSV" database.

This option is available only when Skip For Utility Vendor is selected above.

Accept Two Characters

If selected, the system does not automatically set a two-character invoice number to invalid on the server side.

If cleared, an extracted invoice number that is two characters or less is automatically marked as invalid, and the document is sent to Validation for confirmation.

Validate From DB

This indicates if the invoice number is validated against previous invoice numbers from the same vendor.

Important This option and all of its dependent settings are not available in the Azure cloud environment.

SQL Connection Group

The SQL connection group that specifies the invoice number history database connection string that is set in the Solution Configuration Manager > Global Settings > Database Connection Settings. If no connection group is specified, the system uses group 1.

This option is available only when Validate From DB is selected above.

DB Table Name

The name of the invoice number history database table.

This option is available only when Validate From DB is selected above.

Use Vendor Partition

If selected, a partition is used for the invoice number history check.

This functionality mirrors the vendor partition functionality. It is possible to hold all invoice number history data within a single database table, then use partitions to ensure segregation of client data.

For example, in an Invoice Processing Agility project, there are three clients; Client A, Client B, and Client C. Vendor partitions are used. Clients A & B use vendor partition 1, and Client C uses vendor partition 2.

A single invoice number history pooled between all clients may be used.

As a result, if this option is selected, the system uses the vendor partition ID specified in the Solution Configuration Manager > Client Settings > Client Settings. Also, if the invoice number history table is updated during export, the system updates the table that inserts the relevant vendor partition ID into the column that represents the partition. This is specified using the "Partition Column" setting below.

If this option is selected and no vendor partition is set in the Solution Configuration Manager > Client Settings > Client Settings, the system raises an error.

Note If an invoice number table with partitions is used, then all clients pointing to that table must use the partition. If this is not the case, then during the invoice number history update, the system can erase history data that belongs to another client if the vendor number is the same.

This option is available only when Validate From DB is selected above.

Partition Column

The name of the column that contains the partition ID in the invoice number history lookup table. This setting is not mandatory if "Use Vendor Partition" is cleared.

If vendor partitions are used and this column is blank, the system raises an error message and sends the document to Validation.

This option is available only when Validate From DB and Use Vendor Partition is selected above.

Vendor ID

The column in the database table that contains the vendor number. This setting is mandatory.

This option is available only when Validate From DB is selected above.

Rec ID

The column in the database table that contains the record ID.

This setting is mandatory if the invoice number history table is updated on export.

This option is available only when Validate From DB is selected above.

Invoice Number

The column in the database table that holds the invoice number. This setting is mandatory.

This option is available only when Validate From DB is selected above.

Document Type

The column in the database table that represents a document type of either invoice or credit. This setting is mandatory.

This option is available only when Validate From DB is selected above.

Invoice Alias

The value in the document column of the invoice number history database table that indicates an invoice. This setting is mandatory.

This option is available only when Validate From DB is selected above.

Credit Alias

The value in the document column of the invoice number history table that indicates a credit memo. This setting is mandatory.

This option is available only when Validate From DB is selected above.

Max Records

The maximum number of records that are considered when comparing an extracted invoice number to historic invoice numbers from the same vendor in the database. By default, this is set to "20" records per document type. Such as an INVOICE or CREDIT.

A vendor billing system can use different number ranges for invoices and credit notes. This means that if the Max Records is set to 20 and the vendor submits invoice and credit memos, the maximum number of records that the system maintains in the invoice number history table is actually 40 records.

This option is available only when Validate From DB is selected above.

No Of Hits

The number of hits required to validate the extracted invoice number format with the invoice number history database table. By default, this is set for two records.

This option is available only when Validate From DB is selected above.

Correct OCR Misreads

If selected, the system tries to repair two specific OCR issues if found in the extracted invoice number.

For example, if the number "1" is extracted and it should be the letter "I." Also, if the number "0" is mistaken for the letter "O." No other OCR issues are handled.

This option is available only when Validate From DB is selected above.

Check Sequencing

If selected and the vendor supplies numeric invoice numbers, then when compared against the vendor history, the system does not consider prior invoice numbers if they are ahead by more than 100.

This feature is available to add an additional validation layer to ensure that no old invoices are processed with an older Invoice Number than what is in the Invoice Number History. If selected, it means that an invoice cannot process straight through if it has an Invoice Number that is below the "Sequencing Limit."

So, if "0500" is extracted as the Invoice Number, and the Invoice History table contains "0605," then the 0500 Invoice Number is marked as invalid because it is below the Sequencing Limit. If the Invoice Number is 0507, the value is valid.

For example, invoice number 1500 is read from an invoice. In the history table, invoice numbers 1598, 1599, 1600 and 1601 are present.

This logic does not apply to processing documents that have an Invoice Number that is more than the sequencing limit. This features focuses only on older invoices.

The sequence limit in the above example is set to "100" and is configurable in the "Sequencing Limit" parameter below.

This option is available only when Validate From DB is selected above.

Sequencing Limit

If no sequence limit is specified and the sequencing limit is set to zero, then the system uses the default sequencing limit of 100.

This option is available only when Validate From DB and Check Sequencing are selected above.

Update DB At Export

If selected, the system updates the invoice number history table with a record for the current document during document export.

This option is available only when Validate From DB is selected above.

Invoice Number Confidence

The minimum confidence value that an extracted invoice number requires for a confident value. The number represents a percentage. For example, a value of "20" means an invoice number alternative must be "20%" confident in order to be accepted.

This check is carried out by the system if the invoice number history check is not in use.