Matching Examples

The document association and matching examples provided here are based on the following assumptions:

  • The delivered Standard document association group is used.

  • The delivered Standard document association rules is used for all business units.

  • The document source is the voucher and the association document is the receiver for document association examples.

  • The delivered Basic match rule control is used unless otherwise specified.

  • The voucher is created by copying from the purchase order (with no changes to the unit price or unit of measure).

  • The purchase order, receiver, and voucher are in the same business unit.

  • The received quantity and accepted quantity on the receiver are the same (unless otherwise noted).

  • The Matching process is run for all business units.

Document Association Examples

This table represents various document association scenarios and associated receipt results. Scenarios are at the line summary level unless otherwise specified.

Scenario Document Association Algorithm Voucher Receiver Associated Receipt?

Voucher / Receiver

Sum Up To

Voucher 1 = 100

Receiver 1 = 100

Receiver 1: Yes

Voucher / Multiple Receivers

Sum Up To

Voucher 1 = 100

Receiver 1 = 70

Receiver 2 = 30

Receiver 1: Yes

Receiver 2: Yes

Voucher / Receiver

Sum Up To

Voucher 1 = 100

Receiver 1 = 90

Receiver 1: Yes

Voucher / Receiver

Sum Up To

Voucher 1 = 100

Receiver 1 = 110

Receiver 1 = 100: Yes

Receiver 1 = 10: No

Voucher / Receiver

Equal

Voucher 1 = 100

Receiver 1 = 100

Receiver 1: Yes

Voucher / Receiver

Equal

Voucher 1 = 100

Receiver 1 = 110

Receiver 1: No

Voucher / Receiver

Equal

Voucher 1 = 100

Receiver 1 = 90

Receiver 1: No

Voucher / Multiple Receivers

Equal

Voucher 1 = 100

Receiver 1 = 100

Receiver 2 = 100

Receiver 3 = 100

Receiver 1: Yes

Receiver 2: No

Receiver 3: No

Voucher / Multiple Receivers

Equal Sum

Voucher 1 = 100

Receiver 1 = 70

Receiver 2 = 30

Receiver 1: Yes

Receiver 2: Yes

Voucher / Multiple Receivers

Equal Sum

Voucher 1 = 100

Receiver 1 = 70

Receiver 2 = 40

Receiver 1: No

Receiver 2: No

Voucher / Receiver

Equal Sum

Voucher 1 = 100

Receiver 1 = 100

Receiver 1: No

Receiver 1 is associated using Equal algorithm.

Voucher / Receiver

Select All

Voucher 1 = 100

Receiver 1 = 1000

Receiver 1: Yes

Voucher / Multiple Receivers

Select All

Voucher 1 = 100

Receiver 1 = 70

Receiver 2 = 30

Receiver 3 = 90

Receiver 1 = Yes

Receiver 2 = Yes

Receiver 3 = Yes

Voucher / Receiver

Select All

Voucher 1 = 100

Receiver 1 = 10

Receiver 1: Yes

Voucher / Receiver

Select If One

Voucher 1 = 100

Receiver 1 = 100

Receiver 1: Yes

Voucher / Multiple Receivers

Select If One

Voucher 1 = 100

Receiver 1 = 50

Receiver 2 = 50

Receiver 1: No

Receiver 2: No

Matching Examples

This table represents various matching scenarios and expected results. Scenarios are at the line summary level unless otherwise specified.

Scenario Data Document Association Results Matching - Expected Results

Purchase Order / Voucher

  • PO quantity = 1000.

  • No receiver required on PO line.

  • Voucher quantity = 1000.

Purchase order and voucher associated. Tables updated.

Purchase order and voucher matched after all match rules applied.

Purchase Order / Receiver / Multiple Vouchers

  • PO quantity = 1000.

  • Receiver quantity = 1000.

  • Voucher 1 quantity = 500.

  • Voucher 2 quantity = 500.

No association performed. No tables updated.

Exception created for match rule 100 - no receipts found. No further match rules are applied.

Solution: Manually associate receiver to the vouchers.

Purchase Order / Multiple Receivers / Voucher

  • PO quantity = 1000.

  • Receiver 1 quantity = 300.

  • Receiver 2 quantity = 100.

  • Voucher quantity = 400.

Purchase order is partially associated. Voucher and both receivers associated. Tables updated.

Purchase order is partially matched and voucher and receivers are fully matched after all match rules applied.

Purchase Order / Voucher

  • PO amount = 100. PO matching tolerance is 10%.

  • No receiver required on PO line.

  • Voucher amount = 120.

Purchase order and voucher associated. Tables updated.

Exception created for match rule 260 - line amount not = PO line amount with PO % tolerance. No further match rules are applied.

Purchase Order / Multiple Receivers / Multiple Vouchers

  • PO amount = 1000.

  • Receiver 1 amount = 800.

  • Receiver 2 amount = 200.

  • Voucher 1 amount = 800.

  • Voucher 2 amount = 220.

  • Match rule tolerance amount is 10.

Purchase order and Receiver 1 associated to Voucher 1. No purchase order and receiver association for Voucher 2. Tables updated.

Purchase order is partially matched. Voucher 1 and Receiver 1 are fully matched after all match rules applied.

Exception created for Voucher 2 for match rule 100 - no receipts found. No further match rules are applied.

Purchase Order / Receiver / Voucher (header summary level)

  • The delivered Standard Match Rules Using Rules Tolerance match rule control is used.

  • PO merchandise amount = 2000.

  • Receiver amount = 2000.

  • Voucher merchandise amount = 1900.

No association performed. No tables updated.

Exception created for match rule 100 - no receipts found. No further match rules are applied.

Purchase Order / Voucher (header summary level)

  • The delivered Standard Match Rules Using Rules Tolerance match rule control is used.

  • PO merchandise amount = 2000.

  • No receiver required.

  • Voucher merchandise amount =1900.

  • Match rule tolerance is 10%.

Purchase order and voucher associated. Tables updated.

Purchase order and voucher matched after applying match rule 210 - merchandise amount = PO merchandise amount with rule % tolerance. No further match rules are applied.