Welcome > Settings menu > Invoice Processing > Capture Profiles > Line Pairing Settings

Line Pairing Settings

These settings configure how line pairing is carried out during production.

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

Get PO Lines From SAP

If selected, the purchase order line item information is read from SAP.

This setting is cleared by default.

Important This setting and all of its dependent settings are not available in the Azure cloud environment.
Convert Quantity From SAP

If selected, a difference between the invoice unit of measure and the purchase order unit of measure cannot be resolved via mathematical or order history information on the purchase order, the system performs a lookup to the SAP material master. This looks for the purchase order material in question and obtains the conversion ratio between the deviating units of measure if available.

If a ratio is found, the invoice quantity is converted to reflect the PO unit of measure. If a ration is not found, the line is not paired successfully.

This setting is cleared by default.

This setting is available only when Get PO Lines from SAP is selected above.

Get PO Lines from S/4HANA

If selected, the purchase order line item information is read from S/4HANA.

Important In order to use this setting it is mandatory that a SAP S/4HANA ERP connection is configured for this organization.

This setting is cleared by default.

Get PO Lines From DB

If selected, the purchase order line items are read from a database.

It is recommended that you do not change the database mappings if they are pre-configured based on the organization template selected when creating an organization. For example, an organization that uses the MarkView template. Modifying the database mapping is only necessary when connecting to a custom external database.

Important This setting and all of its dependent settings are not available in the Azure cloud environment.
Database Connection Name

The database connection that specifies the purchase order database connection string.

This setting is available only when Get PO Lines from DB is selected above.

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 only when Get PO Lines from DB is selected above.

Use Stored Procedure

If selected, the system calls a stored procedure to retrieve the purchase order line item information from the database.

This setting is available only when Get PO Lines from DB is selected above.

If you are using an Oracle database, specific configurations are required.

Stored Procedure Name

The name of the stored procedure that retrieves the purchase order lines from the database.

This setting is available only whenGet PO Lines from DB and Use Stored Procedure are selected above.

Stored Procedure Parameters

The comma-separated list of stored procedure parameter indexes from defined stored procedure settings that are used when calling the above stored procedure. These parameters relate to the Settings > Invoice Processing > Global Settings > Stored Procedure Settings.

This setting is available only when Get PO Lines from DB and Use Stored Procedure are selected above.

DB Table Name

The name of the database table that contains purchase order line item information. 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 only when Get PO Lines from DB is selected above.

DB PARTITION ID

The technical name of the purchase order line item database table column that holds the record partition ID.

This setting is mandatory if the Use PO Partition setting is selected in the Settings > Invoice Processing > Capture Profiles > PO Number Settings > PO Number Validation tab.

This setting is available only when Get PO Lines from DB is selected above.

DB PO

The name of the column in the purchase order line database table that holds the purchase order number.

This setting is available only when Get PO Lines from DB is selected above.

DB LINE

The name of the column in the purchase order line database table that holds the purchase order line number.

This setting is available only when Get PO Lines from DB is selected above.

DB MATERIAL NO

The name of the column in the purchase order line database table that holds the purchase order line item material number.

This setting is available only when Get PO Lines from DB is selected above.

DB MATERIAL GROUP

The name of the column in the purchase order line database table that holds the purchase order line item material group.

This setting is available only when Get PO Lines from DB is selected above.

DB DESCRIPTION

The name of the column in the purchase order line database table that holds the purchase order line item description.

This setting is available only when Get PO Lines from DB is selected above.

DB PO QUANTITY

The name of the column in the purchase order line database table that holds the order quantity for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB UNIT PRICE

The name of the column in the purchase order line database table that holds the unit price for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB PO TOTAL

The name of the column in the purchase order line database table that holds the overall total for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB TAX CODE

The name of the column in the purchase order line database table that holds the tax code for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB TAX JUR CODE

The name of the column in the purchase order line database table that holds the tax jurisdiction code for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB UOM

The name of the column in the purchase order line database table that holds the order unit of measure for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB PRICE UNIT

The name of the column in the purchase order line database table that holds the purchase order line item price unit.

This setting is available only when Get PO Lines from DB is selected above.

DB PUOM

The name of the column in the purchase order line database table that holds the order price unit of measure for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB TOTAL QUANTITY DELIVERED

The name of the column in the purchase order line database table that holds the total quantity delivered to date for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB TOTAL VALUE DELIVERED

The name of the column in the purchase order line database table that holds the total value delivered to date for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB TOTAL QUANTITY INVOICED

The name of the column in the purchase order line database table that holds the total quantity invoiced to date for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB TOTAL VALUE INVOICED

The name of the column in the purchase order line database table that holds the total value invoices to date for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB ITEM CATEGORY

The name of the column in the purchase order line database table that holds the item category or line item type for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB PLANT

The location code for the ship-to address where the goods were delivered, or where a service was performed.

This setting is available only when Get PO Lines from DB is selected above.

DB CHARGE CODE

The name of the column in the purchase order line database table that holds the charge code for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB CHARGE CODE ID

The name of the column in the purchase order line database table that holds the charge code ID for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB COMPANY CODE

The name of the column in the purchase order line database table that holds the company code for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB ERP PO TYPE

The name of the column in the purchase order line database table that holds the JD Edwards purchase order type for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB BUSINESS UNIT

The name of the column in the purchase order line database table that holds the PeopleSoft purchasing business unit for the purchase order line item.

This setting is available only when Get PO Lines from DB is selected above.

DB ERS

The name of the column in the purchase order line database table that indicates if this purchase order is intended for the Evaluated Receipt Settlement (ERS) process. If this column contains any value a PO is considered an ERS. The opposite is true if the column is blank.

This setting is available only when Get PO Lines from DB is selected above.

Convert Quantity From DB

If selected, the system performs a lookup using the unit of measure conversion setting in the Settings > Invoice Processing > Capture Profiles > Unit of Measure Settings > Unit Of Measure Settings tab. This lookup occurs if the unit of measure captured on the invoice line does not correspond to the purchase order unit of measure in the paired line. This means that the conversion ratio cannot be calculated mathematically based upon the PO line item details and the PO history.

If the database lookup is not configured correctly, or the relevant entry is missing, the line item is not paired.

This setting is available only when Get PO Lines from DB is selected above.

This setting is selected by default.

Enable Matching to GR Lines

Select this setting to support the loading of goods receipt lines for line matching. This is required in order to support matching to receipt lines in general. Whether or not matching to receipt lines is actually executed depends on the purchase order line configuration that is provided by the ERP. Also, see the DB GR-IV Flag setting.

This setting is available only when Get PO Lines from DB is selected above.

This setting is selected by default.

DB GR PARTITION ID

The database column that contains the PO partition in the configured table for GR lines.

This setting is available only when the Get PO Lines from DB and Enable Matching GR Lines settings are selected above.

DB GR-IV Flag

The name of the database column that indicates whether or not GR-IV is enabled.

This setting is available only when Enable Matching to GR Lines is selected above.

GR-IV Indicator

Value that indicates that GR-IV is enabled or not. For example, if the database column with the GR-IV flag contains an X, this indicates that GR-IV is enabled.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Lines Table Name

The name of the database table that contains GR line information.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Lines Stored Procedure

The name of the stored procedure that reads GR lines.

This setting is available only when Use Stored Procedure and Enable Matching to GR Lines are selected above.

DB GR Lines Stored Procedure Parameters

The parameters for the stored procedure.

This setting is available only when Use Stored Procedure and Enable Matching to GR Lines are selected above.

DB GR PO

The name of the database column that holds the PO number.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR PO Line

The name of the database column that hods the PO line.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Quantity

The name of the database column that holds the delivered quantity.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Total

The name of the database column that holds the total amount of delivered goods.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Quantity Invoiced

The name of the database column that holds the quantity that is already invoiced.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Total Invoiced

The name of the database column that holds the amount that is already invoiced.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Doc No

The name of the database column that holds the GR document number.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Doc Item

The name of the database column that holds the GR document line number/item number.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Doc Year

The name of the database column that holds the GR document year. This entry is optional.

This setting is available only when Enable Matching to GR Lines is selected above.

DB Delivery Note Number

The name of the database column that holds a delivery note number / shipment number.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Invoicing Status

The name of the database column that holds the status of an invoice. This can be used as an alternative if DB GR Quantity Invoiced or DB GR Total Invoiced are not available.

This setting is available only when Enable Matching to GR Lines is selected above.

DB GR Open Invoicing Status Value

The values that indicate that the GR line is still open for booking incoming invoices. You can provide multiple values as a comma-separated list.

This setting is available only when Enable Matching to GR Lines is selected above.

Get PO Lines via User Exit

If selected, purchase order line item details are retrieved via a custom lookup using the ReadPurchaseOrder User Exit. .

This setting is cleared by default.

Important This setting is not available in the Azure cloud environment.
Do Line Pairing

If selected, line pairing is carried out during extraction.

When selected, other settings are available.

This setting is cleared by default.

Enable Line Pairing Correction

If selected, and the invoice is not fully allocated, the document is sent for manual correction.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Do Line Pairing For Service

If selected, line pairing is carried out for invoices that relate to a service purchase order.

This setting is available only when Do Line Pairing is selected above.

This setting is selected by default.

Multi Pairing To Single PO Line

If selected, the system pairs multiple lines on an invoice for the same material, to a single line on the purchase order.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Check For Multiple POs

When selected, a single invoice is compared to see if it contains more than one purchase order.

This setting is available only when Do Line Pairing is selected above.

This setting is selected by default.

Description Threshold

This value indicates the minimum confidence needed to pair a line item based on the fuzzy match on description.

A value of 100 requires an exact match between the invoice line and purchase order line descriptions.

For example, if the PO line item description is BROWN HATS, then a 100% match is achieved only if the invoice line item description is one of the following. BROWN HATS, brown hats, BROWN or HAT.

  • BROWN HATS

  • brown hats

  • BROWN or HAT

For information purposes, BROWN HAT is only a 99.99% match and HATS BROWN is only an 85% match.

A setting of zero means that the closest match to the invoice line is taken as long as there is some degree of similarity.

If no valid value is specified, the default value is 0.

The value for this setting is set to 30 by default. This is the recommended value.

Note The invoice line item description must be at least 5 characters long for the system to consider it when selecting a purchase order line item.

This setting is available only when Do Line Pairing is selected above.

Description Distance

This value indicates the minimum confidence distance between the best and second best possibility for the fuzzy match on the description.

For example, if this value is set to 10% and the system is 51% sure that line 1 is the right result, but 45% sure that line 2 is the right result, then the line will not pair as the 6% distance between them is less than the minimum confidence distance.

The value for this setting is set to 10 by default. This is the recommended value.

This setting is available only when Do Line Pairing is selected above.

Description Tolerance

The line pairing tolerance that the invoice unit price is allowed to deviate from the purchase order unit price. If left blank, this additional check is not carried out.

The value for this setting is set to blank by default.

This setting is available only when Do Line Pairing is selected above.

Limits Description Threshold

This indicates how confident a fuzzy match on the system is in order for to pair a limits line item.

A setting of 100 requires an exact match between the invoice line and purchase order line descriptions.

A setting of 0 means that the closest match to the invoice line is taken as long as there is some degree of similarity.

If no value or an invalid value is provided, the system defaults to 0.

The value for this setting is set to 50 by default. This is the recommended value.

Note The invoice line item description must be at least 5 characters long for the system to consider it when selecting a purchase order line item.

This setting is available only when Do Line Pairing is selected above, and is supported by SAP or SAP S/4HANA ERP systems only.

Limits Description Distance

The minimum confidence distance between the best and second best limits line item description alternatives.

For example, if this value is set to 10% and the system is 51% sure that line 1 is the right result, but 45% sure that line 2 is the right result, then the line will not pair as the 6% distance between them is less than the minimum confidence distance.

The default value is for this setting is 0%.

The value for this setting is set to 10 by default. This is the recommended value.

This setting is available only when Do Line Pairing is selected above, and is supported by SAP or SAP S/4HANA ERP systems only.

Limits Description Tolerance

The percent tolerance that the assigned invoice lines and their total value may exceed the original purchase order line item order total.

For example, if the original purchase order line has a total of 10,000 and the tolerance is set to 10, then the system stops pairing invoice lines to this purchase order line as soon as the total value booked to date exceeds 11,000.

If left blank, this check is not carried out.

The value for this setting is set to 10 by default.

This setting is available only when Do Line Pairing is selected above, and is supported by SAP or SAP S/4HANA ERP systems only.

Unit Price Tolerance

This activates an extra check for invoice lines that pair to purchase order lines. This is due to a high correlation on the amount fields.

If set to 10, the system does not pair an invoice line to a purchase order line, if the purchase order has another line item that has pricing within 10% of the purchase order line originally chosen.

If set to zero, no extra check is carried out.

The value for this setting is set to 0 by default.

Tip This tolerance is used only when line items are paired by unit price only. When no unit price tolerance is defined, a PO line that has an exact match to the requested unit price is accepted if it is the only match. When a unit price tolerance is configured, then a check is made to see if there is a PO line that matches within the tolerance limits. If there is no match, line pairing by unit price for this line fails.

This setting is available only when Do Line Pairing is selected above.

UOM Check

If selected, the system takes any possible unit of measure differences into account when comparing the invoice quantity to the purchase order quantity.

It is recommended that you select this setting for implementations involving SAP.

This setting is available only when Do Line Pairing is selected above.

This setting is selected by default.

PUOM Tolerance

The percentage that the PO unit price may differ from the invoice unit price, in order for the same order price unit of measure. If left blank, the system looks for an exact match.

This is only considered if UOM Check is also selected.

The value for this setting is set to 10 by default.. This is the recommended value.

This setting is available only when Do Line Pairing and UOM Check are selected above.

PUOM Check

If selected, the system applies conversions to the extracted invoice quantity, based on ratios read from the purchase order if the following criteria are met.

  • If the PO unit of measure differs from the PO price unit of measure.

  • The invoice unit of measure and the PO price unit of measure are the same.

It is recommended that you select this setting for implementations involving SAP.

This setting is available only when Do Line Pairing is selected above.

This setting is selected by default.

Pair To Single GR

If selected, the system only pairs the invoice line to a goods receipt line if the corresponding purchase order line is set for goods receipt-based invoice verification.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Find GR With Delivery Number

If selected, the external delivery note number set against an ERP goods receipt is given priority when the following criteria are met.

  • Pairing an invoice line to a good receipt line.

  • The corresponding purchase order line is set for goods receipt-based invoice verification.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Only Use Delivery Number To Find GR

In order for this setting to work, also select the Find GR With Delivery Number setting.

If selected, the system only pairs an invoice line against a goods receipt line if the external delivery note number for the ERP goods receipt is be found on the invoice. If the goods receipt in the ERP system has no external delivery note number set against it, the line is be paired.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Require PO Details For Multiple Materials

This indicates if the pool of purchase order line items contain more than one line for the same material. If so, the system finds a referenced purchase order number or a purchase order line item number on the document. This is so that the system knows which purchase order line to pair with the invoice line.

If selected, and no PO details are found on the invoice, then the line item is paired.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Ignore Completed PO Lines

If selected, the system does not consider any purchase order lines that are already fully invoiced, during line pairing. Fully invoiced is defined as the quantity invoiced to date, being equal or greater than the quantity originally ordered.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Activate Sub Deb Check

If selected, the system sets the subsequent debit flag to X during line pairing. This occurs when all of the following criteria are met.

  • An invoice line is paired to a purchase order line.

  • The quantity of invoiced to date is equal to the delivered to date quantity.

  • The delivered to quantity is greater than zero.

  • The invoice unit price adjustment is less than half of the original unit price on the purchase order.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Enable Integrity Check

If selected, the system does not book an invoice line to the first open PO line/good receipt in the following circumstances.

  • When line pairing against purchase orders that have multiple open lines for the same material.

  • Lines are set for goods receipt based invoice verification when there are multiple open goods receipts.

This does not apply when:

  • A referenced purchase order or line is at line item level.

  • A delivery note number or values and quantities can distinguish the correct purchase order line or goods receipt for booking.

This parameter should always be selected in the following implementations.

  • A workflow component sits between Kofax AP Agility and the downstream ERP system.

  • Kofax AP Agility books directly to the ERP system, but is not creating fully posted invoices.

Because the system dynamically reads the live ERP purchase order history during line pairing, if two successive invoices reference the same purchase order, both can be paired to the same PO line/goods receipt. This is because the ERP purchase order history does not yet have the data from the first matched invoice. If the two purchase orders are not successive, the second invoice is not matched to the same document because the PO line/goods receipt are no longer available.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Exclude Freight From MIRA Process

If selected, the value of any miscellaneous charges on the invoice are excluded from the calculation to determine if there is a one-to-one relationship between the invoice and purchase order.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

Activate Log

If selected, the system writes additional log messages with trace entries for the line pairing operation. These entries also cover the automatic tax code determination procedure.

This content is written to the standard Kofax AP Agility IPA_CoreWorker.log file for on-premise installations. For Azure environments, this content is logged in the database and viewed using the Log Viewer form.

This setting is available only when Do Line Pairing is selected above.

This setting is selected by default.

Find SES with Invoice Number

If selected, the system attempts to select one or more SAP service entry sheets. This selection is based on a comparison between the invoice number and the acceptance reference number on the entry sheet.

This setting is available only when Do Line Pairing is selected above.

Important This setting is not available in the Azure cloud environment unless you are using the S/4HANA Cloud ERP system.

This setting is cleared by default.

Only Use Invoice Number To Find SES

If selected, the system only attempts to select one or more SAP service entry sheets during line pairing. This selection is based on a comparison between the invoice number and the acceptance reference number on the entry sheet.

This setting is available only when Do Line Pairing is selected above.

Important This setting is not available in the Azure cloud environment unless you are using the S/4HANA Cloud ERP system.

This setting is cleared by default.

Park If SES Value Less Than Invoice Value

If selected and data export involves creating documents in SAP, this setting forces the document to park rather than post, but only if the value of the invoice goes over the value of any of the booked SAP service entry sheets.

This setting is available only when Do Line Pairing is selected above.

Important This setting is not available in the Azure cloud environment unless you are using the S/4HANA Cloud ERP system.

This setting is selected by default.

Enforce Line Level Pairing

Forces line pairing to use approaches that look at individual lines only.

This setting is available only when Do Line Pairing is selected above.

This setting is cleared by default.

The following buttons are available at the bottom of the window.

Save

Saves your changes and the window is closed.

Reload

Deletes any unsaved changes and resets the field values back to the last saved settings.