Purchase order services

Purchase order services enable the sharing of purchase-order information between Tungsten 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 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 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. AP Essentials has features to automate line-item pairing and make manual pairing 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, AP Essentials offers automatic and manual line pairing.

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

How automatic line-item pairing works

If Automatic line-pairing is enabled, 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, 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

If the order line numbers on the invoice reliably match the line numbers in your financial system, consider enabling the Include order line number setting. When Include order line number is enabled, the order line number on the invoice is checked first, before the fields above. If it matches exactly one purchase order line, that line is used, even if the article number, unit price, or quantity on the invoice does not match. If the order line number is empty, or it matches no line or more than one line, AP Essentials falls back to the fields above.

After 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)
    Unless Include order line number is enabled, 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 for automatic line-item pairing 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 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. 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 AP Essentials looks at the unit price to determine the correct line. The result of the comparisons appears in the line-item table in AP Essentials, where you can see the correct line numbers and other field values are displayed.

Purchase Order Matching