Purchase order services

Purchase order services enable the sharing of purchase-order information between Kofax AP Essentials and your financial system. When Purchase order services are enabled, you can:

The Microsoft Dynamics AX 2012 integration and the NetSuite integration automatically synchronize purchase-order information between the target system and Kofax AP Essentials. For other financial systems, you must export the purchase-order data from your financial system to an XML file, which you upload to Kofax AP Essentials using AP Essentials Connect.

Purchase-order information from your financial system is visible in the Purchase orders view, the Copy purchase order lines dialog and the Search purchase orders dialog.

Line-item pairing

Line-item pairing is the process of matching invoiced line items to line items in your financial system. Kofax AP Essentials has features to automate line-item paring and make manual paring easier.

Sometimes a purchase order contains many items, but the supplier sends an invoice for only some of the items. When this happens in traditional financial systems, line pairing can be problematic, especially if the PO contains many items. Often, the line numbers on the invoice are missing, or if they do exist, they are merely row counters that do not match the line numbers in the purchase order. This makes line pairing even more difficult because the line number is vital to identifying PO lines in a financial system. To solve this problem, Kofax AP Essentials offers automatic and manual line pairing.

Depending on the settings you choose, you can use Kofax AP Essentials to match PO information manually, automatically or both.

How automatic line-item pairing works

If Automatic line-pairing is enabled, Kofax AP Essentials tries to automatically match line items on the invoice with PO lines, so the correct line number and other field values are sent to your financial system. For each line item on an invoice, Kofax AP Essentials tries to match a unique purchase order line from your financial system using these fields:

  • Supplier number (Header field)
  • Order number (Header or line-item field)
  • Article number
  • Supplier article number
  • Unit price
  • Quantity

After Kofax AP Essentials successfully matches a line item, the values for the line-item fields below are automatically updated with the values from your financial system:

  • Order line number (LIT_RowIdentifier)
    The line-number field is not captured on the invoice. The value of the line-number field is the result of the line-pairing feature.
  • Order number (LIT_OrderNumber)
  • Article number (LIT_ArticleIdentifier)
  • Description (LIT_ArticleName)

Line item rows must be unique in order for automatic line-item paring to work properly. For example, if multiple line-item rows have the same quantity and unit price, a match cannot be made. However, in this example, if the article numbers on the invoice are unique to each row and they also match the article numbers in your financial system, a match can be made.

Example

The image below depicts a typical scenario where you can benefit from automatic line pairing. In this example, you can see a purchase order in Dynamics AX and an invoice in Kofax AP Essentials. The PO contains six items, but the invoice only contains four. The invoice also uses different line numbers and article numbers than the financial system, Dynamics AX. Kofax AP Essentials identifies rows 1, 3 and 4 because their quantities are unique. Rows 5 and 6 on the PO have the same quantity, so Kofax AP Essentials looks at the unit price to determine the correct line. The result of the comparisons appear in the line-item table in Kofax AP Essentials, where you can see the correct line numbers and other field values are displayed.

Purchase Order Matching