GL Code Determination

Automatic GL code determination for Non-PO invoices is an optional step that tries to identify GL codes by learning from GL code assignments that have been applied to this vendor for previous invoices.

When working with the AP Agility Workflow integration, whenever a user manually enters a GL code, Kofax AP Agility populates a table with these assignments during coding. For organizations working without the AP Agility Workflow integration, you need to provide a table with historic assignments.

Any changes made to these settings are applied to new documents only. Documents that are already in-progress use the settings that were in-place when their processing began.

The following settings are available.

Enable GL Code Determination

If selected, GL code determination is used for Non-PO invoices. This determination happens during the validation phase and if possible, GL codes are assigned to individual lines automatically. (Default: Cleared)

This means that if there is no valid or confident GL codes for a Non-PO invoice, that invoices is routed to the AP Agility Workflow Coding activity. If however, all lines of a Non-PO invoice have confident GL codes, the invoice is routed to the Approval activity.

Extraction

This list has three settings to determine how close the GL code must be to match the extracted value. (Default: Standard mode) (Mandatory)

The options are as follows.

Value

Description

Standard mode

Fuzzy matches with a high confidence are accepted only. Fuzzy matches with a lower confidence are suggested, but flagged as non-confident.

Accuracy mode

Matches with a high confidence are accepted only.

Exact mode

Exact matches are accepted only.

This setting is available when the Enable GL Code Determination setting is selected above.

Database Connection Name

Select the database connection name that specifies the GL code database connection string from the list. (Default: AP Agility)

This setting is available only when the Validate From setting is set to Custom Database.

This setting and all of its dependent settings are not available in the Kofax hosted multi-tenant Azure environment.

DB Schema

Enter the name of a schema to filter the list of database tables available for the selected Database Connection Name.

If this field is left blank, all database tables that you have permission to access, are displayed.

This setting is available when the Enable GL Code Determination setting is selected above.

DB Table Name

Select the name of the database table that contains GL code data. The list is populated based on the selected Database Connection Name and if used, the specified schema. If the selected table has columns that match the settings below, they are populated automatically. (Mandatory)

This setting is available when the Enable GL Code Determination setting is selected above.

Use Vendor Partition

If selected, the GL code database lookup uses a vendor partition. Vendor partitions are set against the organization in the Settings > Organizations. (Default: Selected)

This setting is available when the Enable GL Code Determination setting is selected above.

DB Partition Column

Select the Vendor Partition ID from the list. Partitions are specified in the Settings > Invoice Processing > Global Settings > Partition Settings > Vendor Partition tab. (Mandatory)

This setting is available when the Enable GL Code Determination and the Use Vendor Partition settings are selected above.

DB Vendor ID

Select the name of the database column that holds the vendor ID for the given GL code. This must be set to the internal vendor ID that the ERP system uses. (Mandatory)

This setting is available when the Enable GL Code Determination setting is selected above.

DB Material NO

Select the name of the column in the database table that holds the line item material number.

This setting is available when the Enable GL Code Determination setting is selected above.

DB Description

Select the name of the column in the database table that holds the line item description. (Mandatory)

This setting is available when the Enable GL Code Determination setting is selected above.

DB GL Code

Select the name in the column in the database table that holds the GL code. (Mandatory)

This setting is available when the Enable GL Code Determination setting is selected above.

DB Site ID

Select the name of the column that contains the Site ID for a vendor.

The following buttons are available.

Save

Save your changes for the selected capture profile.

Reload

Discards any changes and reloads the form to its previously saved state.