Line Item Matching: Extraction
Line Item Matching (LIM) is the feature that allows application users to match and verify the processed Invoices with their corresponding Purchase Orders on the Validation screen. For more information about the functionality, see Line item matching.
-
All changes done on the Validation screen are saved automatically. There is no pop-up message, and the user is routed directly to the LIM screen. Any changes done on RV screen are reflected on the LIM screen and vice versa.
-
LIM UI: the user can resize the columns both in the Invoice Table and PO Database Table as required. The defined width is saved, so when the user navigates to the LIM screen again, both tables appear as previously configured.
-
To define whether to display the Index Fields by name or description on the LIM screen, configure the field.display_property property in the application.properties file (<Ephesoft Transact Installation Directory>ApplicationWEB-INFclassesMETA-INF):
-
Set the field.display_property to 0 if you want to display the Index Field by description.
-
Set the field.display_property to 1 if you want to display the Index Field by name.
We recommend that you restart the server after making changes in the application.properties file. -
-
On the LIM screen, the operator can copy the data from the PO table to the Invoice table using the Copy All / Copy Selected options.
The Copy operation is governed by the MAPPING_CONFIG property in the LIM Default.properties file (SharedFolders<Batch Class Id>lim)
This property is used to map columns of the PO table and Invoice table for copying operation. For example, in accordance with above property, part_number column values of the PO table are copied to the Part No column of the Invoice table.
When copying an already matched row from the PO table to the Invoice table, the values for all the columns are retained, even if no mapping is defined for the same in the properties file.
For example, if "Discount" column is not defined in the properties file, but it contains a value in the Invoice row, then this value is retained after copying columns from the PO table.
-
The information about the currency is picked up from the locale properties.
The currency is selected for the table on the Tables screen from the Currency drop-down list:
Once the currency has been specified, its fraction separator is fetched from the locale and is used while matching the fraction values of the table.
If no currency is selected, the default separator is "."