Welcome > Solution Configuration Manager > Profile Settings overview > Line Pairing Settings

Line Pairing Settings

These options configure how line pairing is carried out.

Get PO Lines From SAP

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

Important This option 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 option is available only when "Get PO Lines from SAP" are selected above.

Get PO Lines From DB

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

Important This option and all of its dependent settings are not available in the Azure cloud environment.
SQL Connection Group

The SQL connection group that specifies the purchase order database connection string as set in the Solution Configuration Manager > Global Settings > Database SettingsDatabase Connection Settings. If no connection group is specified, the system uses group 1.

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

DB Table Name

The name of the database table that contains purchase order line item information.

This option 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 option 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 option 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 Solution Configuration Manager > Global SettingsStored Procedure Settings.

This option is available only when Get PO Lines from DB and Use Stored Procedure are 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 Solution Configuration Manager > Profile Settings PO Number Validation.

This option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 Solution Configuration Manager > Profile SettingsUnit Of Measure Settings. 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 option is available only when Get PO Lines from DB is selected above.

Enable Matching to GR Lines

Select this option to support goods receipt lines for line matching.

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

DB GR-IV Flag

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

This option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 option 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 in ReadPurchaseOrder.

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

If selected, line pairing is carried out during extraction.

When selected, other options are available.

Enable Line Pairing Correction

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

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

Do Line Pairing For Service

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

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

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 option is available only when Do Line Pairing is selected above.

Check For Multiple POs

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

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

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

It is recommended to use a value of "30" for this setting.

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

It is recommended to use a value of "10 "for this setting.

This option 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.

This option 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 service 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."

It is recommended to set this value to "50."

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 option is available only when Do Line Pairing is selected above.

Limits Description Distance

The minimum confidence distance between the best and second best service 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%.

It is recommended to use a value of "10 "for this setting.

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

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

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

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.

This option 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 option for implementations involving SAP.

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

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 recommended setting is "10."

This option 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 option is available only when Do Line Pairing is selected above.

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 option is available only when Do Line Pairing is selected above.

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 option is available only when Do Line Pairing is selected above.

Only Use Delivery Number To Find GR

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

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 option is available only when Do Line Pairing is selected above.

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 option is available only when Do Line Pairing is selected above.

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 option is available only when Do Line Pairing is selected above.

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 option is available only when Do Line Pairing is selected above.

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 Invoice Processing Agility and the downstream ERP system.

  • Invoice Processing 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 option is available only when Do Line Pairing is selected above.

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 option is available only when Do Line Pairing is selected above.

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 Invoice Processing 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 option is available only when Do Line Pairing is selected above.

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 option is available only when Do Line Pairing is selected above.

Important This option is not available in the Azure cloud environment.
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 option is available only when Do Line Pairing is selected above.

Important This option is not available in the Azure cloud environment.
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 option is available only when Do Line Pairing is selected above.

Important This option is not available in the Azure cloud environment.
Enforce Line Level Pairing

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

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