EAP: Document Association Rule using "SumUpTo" in Release 8.9 for Matching_arch (Doc ID 649759.1)

Last updated on NOVEMBER 29, 2019

Applies to:

This document was previously published as Customer Connection Solution 201020655

Goal

How to make Matching associate one Receipt to more than one Voucher ?

or

How to make Matching associate partial Receipt to one Voucher ?

Note : In both scenario described below , the total sum voucher is less then the available receipt.

Scenario # 1 :
---------------
PO Qty = 1000
Receipt Qty = 1000
Voucher #1 Qty = 200 
Voucher #2 Qty = 300 

Expected result :Matching to associate Receipt # 1 (Qty =500) to Voucher # 1 and Voucher # 2.
Remaining unmatched Receipt Qty = 500

Scenario # 2
-----------------
PO Qty = 1000
Receipt Qty = 1000
Voucher Qty = 500

Expected result :Matching to associate Receipt # 1 (Qty =500) to Voucher # 1
Remaining unmatched Receipt Qty = 500

Scenario # 3:
-----------------
PO Qty = 1000
Receipt # 1 Qty = 100   (unmatched Qty = 50)
Voucher  # 1 Qty = 50 - matched to Receipt  # 1 by manual association or using SumUpTo  Rule.
Receipt # 2 Qty = 50
Voucher # 2 Qty = 100
Expected result : Matching to associate Receipt # 1 (remaining Qty = 50) and Receipt # 2 to Voucher # 2

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.