Connecting invoice lines to receipt or purchase lines

The article below pertains to Procure to Pay (P2P) for the following applications and/or module(s):

AP Automation

Invoice lines must be linked to receipt lines or order lines within ISP-Invoice, so that matching can be performed. In the case of a 3-way matching, invoice lines are linked to receipt lines. In the case of a 2-way matching, invoice lines are linked to order lines. The mechanism is the same in both cases.

Linking to receipt lines is done based on criteria set for AP Automation. Several criteria for linking can be specified, with different priorities. First, it is checked whether it is possible to link based on criterion 1, if not, then criterion 2, etc.

An example:

• Criterion 1: match in order number and order line number;
• Criterion 2: match in order number and article number.

If there is a unique match between one invoice line and one receipt line based on one of the criteria, these lines are linked and the quantity and amount are taken from the invoice.
If there is no unique match, but several receipt lines meet one of the criteria, a check is made to see whether a combination can be found where the number of the invoice line equals the total number of multiple receipt lines. If so, all these order lines are assigned to the invoice line. The other way round, this does not apply, if the total of quantities on the invoice lines corresponds to one receipt line, no matching is made.