{"id":31888,"date":"2016-08-08T14:31:21","date_gmt":"2016-08-08T22:31:21","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/2019-1-2\/batch-class-management\/line-item-matching\/"},"modified":"2022-01-26T14:18:02","modified_gmt":"2022-01-26T21:18:02","slug":"line-item-matching","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/","title":{"rendered":"Line Item Matching"},"content":{"rendered":"

The Line Item Matching (LIM) feature allows the Transact users to match and verify the processed Invoices with their corresponding Purchase Orders on the Validation Screen. Earlier LIM was developed as an external application, but now it has been integrated within the Ephesoft environment. The administrator can configure the Batch Class based on the pre-configured Default.properties file and po_configuration table, or can further change these configurations and map to an external PO Data Source as per the requirement. These configurations can be different for each data table within the Batch Class. User can configure LIM from the Document Type Screen and once the batch is executed, the user can select the option for LIM from the Validation Screen or directly use the short-cut to navigate to the LIM Screen (Ctrl + Shift + Y) to verify the Invoices against their corresponding Purchase Orders. User can manually match the items at the LIM screen if the results does not match on the Validation Screen.<\/p>\n

Two-way matching process: <\/strong>In the two-way matching process, quantity and price on the invoice are matched to the quantity and price on the corresponding purchase order. The line items are considered invalid, if any of the two conditions fails:<\/p>\n

Quantity in Invoice <= Quantity in PO<\/p>\n

Price in Invoice = Price in PO<\/p>\n

Line Item Matching: <\/strong>Items in the invoices are matched to the corresponding purchase order on the basis of configuration done by the administrator in the Properties file.<\/p>\n

Batch Class Configuration<\/h2>\n

Following are the Configurations done at Batch Class level which can be further changed by the administrator as per the requirement.<\/p>\n

    \n
  1. Go to Document Type >> Invoice-Table >> Index Fields<\/strong>. Make sure that the following Document level index fields are present in the Batch Class.PO Number:<\/strong> This field is required to fetch Purchase Order results from the database. If this field is not configured in the Batch Class, the application cannot proceed further. It is a mandatory field.Comment:<\/strong> This field helps user to add any comment in the Batch.xml in case no PO match is found. It is a mandatory field.Line Items Matched:<\/strong> This field is reflected on the LIM Screen as a checkbox. It shows whether the line items are matched or not. Configure it as a Read-only<\/strong> field in the additional configuration and field type as Checkbox<\/strong>. The validation Pattern<\/strong> should have the value True<\/strong>\/False<\/strong>.\"F:EnterpriseProduct<\/li>\n
  2. Go to Document Type >> Invoice-Table >> Tables >> Table Columns<\/strong>. Make sure that the following columns are present in the data table.Quantity:<\/strong> This column is required for applying two-way-matching algorithm. It is a mandatory field.Unit Price:<\/strong> This column is required for applying two-way-matching algorithm. It is a mandatory field.PO Line:<\/strong> This column will be updated based on the matched PO line items. It is a mandatory field.All the other fields and columns are optional.<\/li>\n<\/ol>\n

    PO Database Configuration<\/h2>\n

    A Batch Class can have more than one data table and corresponding to each data table there can be separate Properties file. The administrator can make changes in each Properties file for different set of configurations as needed.<\/p>\n

    There is a default PO data table \u201cpo_configuration\u201d already configured in the Ephesoft database with the following columns.<\/p>\n

      \n
    1. po_line<\/li>\n
    2. po_number<\/li>\n
    3. part_number<\/li>\n
    4. vendor_id<\/li>\n
    5. vendor_name<\/li>\n
    6. quantity<\/li>\n
    7. available_quantity<\/li>\n
    8. unit_price<\/li>\n
    9. item_description<\/li>\n<\/ol>\n

      The administrator can also configure an external PO data source. In order to do that, following configurations are required:<\/p>\n

        \n
      • On the Tomcat server, add a resource tag in server.xml<\/strong> file for the external data source and corresponding resource link in the context.xml<\/strong> file.<\/li>\n
      • Update the Data Source and PO_Table name in the property file.<\/li>\n<\/ul>\n

        Property File Configuration<\/h2>\n

        Property file is located at:<\/p>\n

        SharedFolders\/BatchClassIdentifier\/lim\/DocumentTypeName.DatatableName.properties<\/strong><\/p>\n

        If the above Property file does not exist, then go to the Default.properties file located at \u2013<\/p>\n

        SharedFolders\/BatchClassIdentifier\/lim\/Default.properties<\/strong><\/p>\n

         <\/p>\n

        Below is the Property Files table with details:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
        Property Placeholder<\/strong><\/td>\nDefault Value<\/strong><\/td>\nDescription<\/strong><\/td>\nAllowed Values<\/strong><\/td>\nComment<\/strong><\/td>\n<\/tr>\n
        PO_TABLE<\/td>\nPO_CONFIGURATION<\/td>\nName of the PO table in database.<\/td>\nThe name of data base table<\/td>\n<\/td>\n<\/tr>\n
        PO_COLUMNS_TO_DISPLAY<\/td>\nAll the PO column names<\/td>\nThe names of all PO columns to display at UI<\/td>\nThe names of all PO columns to display at UI.<\/td>\nColumn names are case sensitive.<\/td>\n<\/tr>\n
        INVOICE_COLUMNS_TO_DISPLAY<\/td>\nAll the Invoice columns names.<\/td>\nThe names of all invoice columns to display at UI.<\/td>\nThe names of all invoice columns to display at UI.<\/td>\nColumn names are case insensitive.<\/td>\n<\/tr>\n
        DLF_TO_DISPLAY_TOP<\/td>\nAll Document Level Fields in a batch class.<\/td>\nThe document level fields to be displayed at top panel. If this property contains fields names that are also to be displayed at bottom, then that fields are skipped.<\/td>\nThe document level fields to be displayed at top panel.<\/td>\nNames are case insensitive.<\/td>\n<\/tr>\n
        DLF_TO_DISPLAY_BOTTTOM<\/td>\nSub Total, Invoice Total, Tax<\/td>\nThe document level fields to be displayed at bottom panel.<\/td>\nThe document level fields to be displayed at bottom panel.<\/td>\nNames are case insensitive.<\/td>\n<\/tr>\n
        DLF_COMMENT<\/td>\nComment<\/td>\nThe comment document level field to add any comment in batch xml in case no PO match is found.<\/td>\nThe name of comment field configured in batch class.<\/td>\nThis field is case insensitive.<\/td>\n<\/tr>\n
        PO_COLUMNS_FILTER<\/td>\npo_number<\/td>\nThe name of PO table columns based on which PO results will be filtered.<\/td>\nThe name of PO columns on which results should be filtered.<\/td>\nPO Column names are case sensitive.<\/td>\n<\/tr>\n
        DLF_po_number<\/td>\nPO Number<\/td>\nThe name of PO Number Document level field in batch class needed for executing search query.<\/td>\nThe name of Document Level Field in batch class.<\/td>\nProperty value is case insensitive.<\/td>\n<\/tr>\n
        PO_NUMBER<\/td>\npo_number<\/td>\nThe name of PO number column in PO table.<\/td>\nThe name of PO number column in PO table.<\/td>\nProperty value is case sensitive.<\/td>\n<\/tr>\n
        MATCHING_ALGO_MAPPING<\/td>\npart_number, SEARCH_IN_DESC, item_description,\u00a0unit_price<\/td>\nThe priority based on which matching algo should be executed.<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
        INVOICE_POLINE<\/td>\nPO Line<\/td>\nThe name of PO Line column in data table needed for matching purpose.<\/td>\nThe name of PO Line column in data table.<\/td>\nProperty value is case insensitive.<\/td>\n<\/tr>\n
        PO_POLINE<\/td>\npo_line<\/td>\nThe name of PO Line column in PO table needed for matching purpose.<\/td>\nThe name of PO Line column in PO table.<\/td>\nProperty value is case sensitive.<\/td>\n<\/tr>\n
        PO_QUANTITY<\/td>\navailable_quantity<\/td>\nThe name of available quantity column in po table needed for matching purpose.<\/td>\nThe name of available quantity column in PO table.<\/td>\nProperty value is case sensitive.<\/td>\n<\/tr>\n
        PO_PRICE<\/td>\nunit_price<\/td>\nThe name of unit price column in PO table needed for matching purpose.<\/td>\nThe name of unit price column in PO table.<\/td>\nProperty value is case sensitive.<\/td>\n<\/tr>\n
        INVOICE_QUANTITY<\/td>\nQuantity<\/td>\nThe name of quantity column in data table needed for matching purpose.<\/td>\nThe name of quantity column in data table.<\/td>\nProperty value is case insensitive.<\/td>\n<\/tr>\n
        INVOICE_PRICE<\/td>\nUnit Price<\/td>\nThe name of unit price column in data table needed for matching purpose.<\/td>\nThe name of unit price column in data table.<\/td>\nProperty value is case insensitive.<\/td>\n<\/tr>\n
        INVOICE_DESC<\/td>\nDescription<\/td>\nThe name of description column in data table needed for matching purpose.<\/td>\nThe name of description column in data table.<\/td>\nProperty value is case insensitive.<\/td>\n<\/tr>\n
        MAPPING_CONFIG<\/td>\npart_number,unit_price, available_quantity,item_description,po_line<\/td>\nThe column in PO table which should be mapped to datatable column. Required for copy purposes.<\/td>\n<\/td>\nProperty value is case insensitive<\/td>\n<\/tr>\n
        TOLERANCE<\/td>\n0<\/td>\nThe allowable tolerance for 2 way matching.<\/td>\nAny positive integer value.<\/td>\n<\/td>\n<\/tr>\n
        DLF_TOTAL<\/td>\nInvoice Total<\/td>\nThe name of total document level field in batch class. Required in second phase.<\/td>\nThe name of total document level field in batch class.<\/td>\nProperty value is case insensitive.<\/td>\n<\/tr>\n
        DLF_SUB_TOTAL<\/td>\nSub Total<\/td>\nThe name of sub-total document level field in batch class. Required in second phase.<\/td>\nThe name of sub-total document level field in batch class.<\/td>\nProperty value is case insensitive.<\/td>\n<\/tr>\n
        FILTERABLE_PO_COLUMNS<\/td>\npart_number<\/td>\nComma separated names of PO columns on which filters can be applied.<\/td>\nThe name of PO columns.<\/td>\nPO column names are case sensitive.<\/td>\n<\/tr>\n
        DATASOURCE_NAME<\/td>\njdbc\/ephesoft<\/td>\nName of data source from which PO configuration is to be fetched.<\/td>\nData source name<\/td>\nData source name is case sensitive.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

         <\/p>\n

        MATCHING_ALGO_MAPPING <\/strong><\/p>\n

        It should be defined in the order of priority. Its default value is:<\/p>\n

        part_number:Part No,SEARCH_IN_DESC:part_number,item_description:Description,unit_price:Unit Price<\/em><\/p>\n

        By default<\/em>, matching will be done on basis of part number. If no match is found, then matching will be done by searching part number of PO in invoice description. If still no match is found, the item descriptions will be matched and lastly the unit price will be matched.<\/p>\n

        It is defined as {name of po column:name of invoice column, \u2026}.<\/p>\n

        SEARCH_IN_DESC:part_number: This <\/em>defines that part_number of PO table should be searched in description of invoice table for matching.<\/p>\n

         <\/p>\n

        MAPPING_CONFIG <\/strong><\/p>\n

        This property defines the name of PO column and corresponding data table column. It is required for the purpose of copy. For example, if po_line column is column name in PO table and PO Line is corresponding column name in data table then it will be defined as:<\/p>\n

        po_line:PO Line<\/em><\/p>\n

        Similarly, all columns will be defined as comma separated.<\/p>\n

        MAPPING_CONFIG=part_number:Part No,unit_price:Unit Price,available_quantity:Quantity,item_description:Description,po_line:PO Line<\/p>\n

        Working<\/h2>\n

        In order to use the LIM feature for a Document Type, mark the checkbox LIM from the Additional Configurations column on the Document Type Screen. If LIM is configured at the Document level, the LIM button becomes visible on the Validation Screen for the selected Document Type.<\/p>\n

        \"F:EnterpriseProduct<\/p>\n

        In AUTOMATED_REGEX_VALIDATION, Line items are matched for the document types for which LIM was enabled. Based on validation \u201cLine Item Field\u201d is marked as True\/Empty. If this plugin is not present at the Batch Class level, the application will always consider that the Line Items are not matched (validation failed) and the LIM button will appear in Red on the Validation Screen. The user has to manually validate the line items and process further.<\/p>\n

        \"F:EnterpriseProduct<\/p>\n

        On executing the Batch, the Automatic Validation module runs the LIM algorithm and validates the line items based on the configurations.<\/p>\n

        The checkbox Line Items Matched is a read-only field and is checked if all the line items are matched.<\/p>\n

        \"F:EnterpriseProduct<\/p>\n

        The LIM View lists the Invoice and PO data tables with line items matched.<\/p>\n

        Case 1:<\/strong> If the line items are matched and fields are valid, it will be shown as Green.<\/p>\n

        Case 2:<\/strong> If the line items are matched and validation fails, it will be shown as Red.<\/p>\n

        Case 3:<\/strong> If the line items are not matched, it will show empty rows.<\/p>\n

        Case 4:<\/strong> If there are multiple data tables for a Document Type and any of the property (Batch Class\/ PO level configuration) is missing, it will consider validation failed and the LIM View button will be Red.<\/p>\n

        \"F:EnterpriseProduct<\/p>\n

        In the above example, the green rows reflect the Line Items which are matched and valid. And the red row reflects that the Line Item is matched but invalid, here the value of the PO Line field is not correct.<\/p>\n

        (Invalid \u2013 If either the price or quantity or both did not match.)<\/p>\n

        User can manually update the PO Line by selecting the desired value from the dropdown list.<\/p>\n

        Note that the Line Items Matched checkbox will be marked based on whether all line items are matched and valid, or not. User can also mark it manually, if needed.<\/p>\n

        \"F:EnterpriseProduct<\/p>\n

        By clicking on Save, only the Data Table which is visible will be saved.<\/p>\n

        All the other Data Tables will not be saved.<\/p>\n

         <\/p>\n

         <\/p>\n","protected":false},"featured_media":0,"parent":31881,"menu_order":6,"comment_status":"closed","ping_status":"open","template":"","doc_tag":[],"yoast_head":"\nLine Item Matching | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Line Item Matching\" \/>\n<meta property=\"og:description\" content=\"The Line Item Matching (LIM) feature allows the Transact users to match and verify the processed Invoices with their corresponding […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-26T21:18:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2016\/08\/word-image-30.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/\",\"name\":\"Line Item Matching | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2016-08-08T22:31:21+00:00\",\"dateModified\":\"2022-01-26T21:18:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Features and Functions\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Administrator Role and Features\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Batch Class Management\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Line Item Matching\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Line Item Matching | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Line Item Matching","og_description":"The Line Item Matching (LIM) feature allows the Transact users to match and verify the processed Invoices with their corresponding […]","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/","og_site_name":"Ephesoft Docs","article_modified_time":"2022-01-26T21:18:02+00:00","og_image":[{"url":"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2016\/08\/word-image-30.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/","name":"Line Item Matching | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2016-08-08T22:31:21+00:00","dateModified":"2022-01-26T21:18:02+00:00","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/line-item-matching\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/"},{"@type":"ListItem","position":3,"name":"Features and Functions","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/"},{"@type":"ListItem","position":4,"name":"Administrator Role and Features","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/"},{"@type":"ListItem","position":5,"name":"Batch Class Management","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/"},{"@type":"ListItem","position":6,"name":"Line Item Matching"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31888"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=31888"}],"version-history":[{"count":2,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31888\/revisions"}],"predecessor-version":[{"id":50283,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31888\/revisions\/50283"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31881"}],"next":[{"title":"Table Extraction","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31882"}],"prev":[{"title":"Index Fields","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/index-fields-4050\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31894"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=31888"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=31888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}