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 Kofax 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 Kofax AP Agility workflow integration, you need to provide a table with historic assignments.
You can configure GL code determination using the following settings.
- 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
This means that if there is no valid or confident GL codes for a non-PO invoice, that invoices is routed to the Coding activity. If however, all lines of a non-PO invoice have confident GL codes, the invoice is routed to the Approval activity.
This option is cleared by default.
- Extraction
-
This list has three options to determine how close the GL code must be to match the extracted value. 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.
This setting is mandatory.
The value for this option is set to Standard mode by default.
- Database Connection Name
-
Select the database connection name that specifies the GL code database connection string from the list.
This setting is available only when Validate From DB is selected above.
The value for this option is set to AP Agility by default.
Important This option and all of its dependent settings are not available in the Azure cloud 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.
This setting is available when the Enable GL Code Determination setting is selected above.
This setting is mandatory.
- Use Vendor Partition
-
If selected, the GL code database lookup uses a vendor partition. Vendor partitions are set against the organization in the .
This setting is available when the Enable GL Code Determination setting is selected above.
This option is selected by default.
- DB Partition Column
-
Select the Vendor Partition ID from the list. Partitions are specified in the Vendor Partition tab.
This setting is available when the Enable GL Code Determination and the Use Vendor Partition settings are selected above.
This setting is mandatory.
- 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.
This setting is available when the Enable GL Code Determination setting is selected above.
This setting is mandatory.
- 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.
This setting is available when the Enable GL Code Determination setting is selected above.
This setting is mandatory.
- DB GL Code
-
Select the name in the column in the database table that holds the GL code.
This setting is available when the Enable GL Code Determination setting is selected above.
This setting is mandatory.
- 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.