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 (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 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.