Configure a Line Item Matching Locator
Use the procedure in this topic to configure a Line Item Matching Locator.
The Line Item Matching Locator engine can enhance the extraction results by unassisted training, requiring no setup beyond standard configuration settings.
-
Open the
Table Locator
Properties.
The properties for the Table Locator are displayed.
-
Select the
Settings tab, configure the following settings.
Setting
Description
General group
Table model
The table model defines the columns the Line Item Matching Locator returns as output. Select a table model from the list. If necessary you can change an existing table model or create a new table model by selecting the Table Models button. (Default: none)
The extracted results are returned by using the content pattern in database mapping and assigning them to the known global columns of the table model. To use the Line Item Matching Locator matching mechanism, all global columns that you want to match needs to be included in the table model. If the table model does not contain at least one of these columns, a warning is displayed.
Amount formatter
Select an amount formatter from the list that formats any amount columns in the output table. (Default: Default amount formatter)
Use the
Formatting button to open the
Project Settings -
Formatting tab so you can add or modify your formatters.
Percentage formatter
Select an percentage formatter from the list that formats any percentage values in the output table. (Default: none)
Use the
Formatting button to open the
Project Settings -
Formatting tab so you can add or modify your formatters.
Tax Rates for Supported Countries group
Countries
This group enables you to select one or more countries and their tax rates. You can also add or configure countries by selecting the Countries button.
Purchase Orders group
Purchase order number locator
Select a locator from the list that finds the purchase order number on a document. This setting is mandatory in order to use this locator method.
The algorithm searches line items in the database that match the input locator alternatives. This list shows only those locators that are defined above the current Line Item Matching Locator in the list of locators for this class. (Default: None)
Minimum confidence
Set a minimum input confidence to restrict what the Purchase order number locator finds. (Default: 70)
Formatter
Select a formatter from the list to format the results of the locator used for the purchase order number. This is especially useful if you need to delete additional blanks from the recognition results in order to have a format comparable to the one used in the database. (Default: None)
Select
Formatter properties to edit the selected formatter.
Use the
Formatting button to open the
Project Settings -
Formatting tab so you can add or modify your formatters.
Vendor ID locator
Select a locator from the list that returns the vendor ID that restricts the possible results of the database search and compensates for errors in the purchase order number extraction. The Input Locator list provides a list of the locators that are defined above the current Line Item Matching Locator. (Default: None)
Minimum confidence
Set a minimum confidence to restrict what the Vendor ID locator finds. (Default: 70)
If your project from an earlier version of Tungsten TotalAgility already makes use of the Vendor ID locator, the value for this setting is set to 0 instead of 70 percent. This means that all Vendor IDs that are returned by the Vendor ID Locator are considered valid.
Execute purchase order discovery
Includes additional purchase order records from the database that belong to the same Vendor. Clear this setting if you want to disable purchase order discovery and use the purchase order number values from the Purchase order number locator or the Vendor ID locator only. (Default: Selected)
Maximum purchase orders used
Set a maximum number of purchase order numbers used for extraction. This setting limits the total number of purchase order numbers found by the input locator and any discovered purchase order numbers. (Default: 20)
Amount Settings group
Over unit price difference
Enter a percent value to set a tolerance for the unit price so a higher value on a document is found when it does not match a record in the database. (Default: 1%)
If the unit price for an item in the database is 10.50 and a document for that same item has a value of 10.60, the item on this document should be returned using the default value for this setting. For the best results, do not use a value greater than 3% for this setting. Higher values may return unwanted results.
Under unit price difference
Enter a percent value to set a tolerance for the unit price so a lower value on a document is found when it does not match a record in the database. (Default: 1%)
If the unit price for an item in the database is 10.50 and a document for that same item has a value of 10.40, the item on this document should be returned using the default value for this setting. For the best results, do not use a value greater than 3% for this setting. Higher values may return unwanted results.
-
On the
Database tab, use the following settings to retrieve data from the purchase order database and to
define the type of content for the database fields.
Setting
Description
Purchase order database
Select a database from the list or add a database from the project settings by selecting
Databases. You can configure the purchase order database, but for a database search
you can use an existing
relational database only. (Default: none)
Define purchase order database columns
This table lists the purchase order database mappings. To retrieve data from the purchase order database, you need to define the type of content for the database fields.
To check whether the entry of a purchase order database column is the same as the content of the corresponding column printed on the invoice, define an additional custom column in the table model. For example, you can check the result from "Description", that is extracted from the invoice, against the result of the "PODescription" database entry.
When testing the locator, the results retrieved from the database are displayed for these columns.
The listed definitions for Purchase Order Number, Quantity, Unit Price, Total Price, Description, Purchase Order Item Number, Vendor ID, Article Code, and Supplier Article Code need to be mapped to a corresponding database columns. This mapping step is essential for Line Item Matching Locator performance.
When testing the locator, extraction results available from the invoice are displayed for these columns.
Map table model columns to purchase order database
The "Table Model Columns" list displays the names of all columns defined within the selected table model, except the columns listed above in the "Define purchase order database columns". You can map these additional columns to columns from the purchase order database, that are not necessarily printed on the invoice. For example, a BudgetCode field can be mapped even though it does not are displayed on the document. Data that is present on the document can be used to determine the BudgetCode field listed in the database.
If you want to check whether the entry of a purchase order database column is the same as the content of the corresponding column printed on the invoice, you can define an additional custom column in the table model. For example, you can check the result from Description that is extracted from the invoice, against the result of PODescription, that is a database entry.
When testing the locator, the results retrieved from the database are displayed for these columns.
-
On the
Online Learning tab, configure the following settings.
Setting
Description
Automatically generate training data
Runs online learning during processing. (Default: Cleared)
Number of documents required to repeat incremental learning
This setting is available only when Automatically generate training data is selected.
Set the threshold number of documents collected before training begins. The files used for incremental training are kept until they are used by the permanent training step. Available only when the "Automatically generate training data" setting is selected. (Default: 100)
Number of documents required to repeat permanent learning
This setting is available only when Automatically generate training data is selected.
Set the threshold number of training documents collected before the information is transformed into a permanent model file. The higher the number of documents specified, the higher the accuracy as well as memory consumption. All training documents that are saved for permanent learning are then deleted from the collection path. Available only when the "Automatically generate training data" setting is selected. (Default: 1000)
Maximum number of training documents to be gathered
This setting is available only when Automatically generate training data is selected.
Set the threshold number of documents trained before the system ceases training. Available only when the "Automatically generate training data" setting is selected. (Default: 10000)
Use training data
Uses the trained data during extraction. (Default: Cleared)
-
Select the
Disambiguation tab.
Here, you can select some of the columns in the purchase order database to help reduce false potential purchase order matches. The information for each field is displayed in the following columns.
Setting
Description
Meaning
The description or name of the purchase order field.
Use For Disambiguation
Selected fields are used for disambiguation to help improve the results of the Line Item Matching Locator.
Use the Up and Down buttons to organize the preference of the purchase order fields. The top entry has this highest preference.