Free Oracle Magazine Profit:The Executive's Guide to Oracle Applications

Enter your e-mail address to receive notifications when there are new posts

Profit Magazine: The Executive's Guide to Oracle Applications

PO Matching: 2 ways, 3 ways or 4 ways

Posted on June 5th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In the Procure to pay cycle, we all know it start from requisition to payment, thus it is equally important to understand the relation between PO and Invoice, which of course is subject to Matching based on tolerances level set.

How many ways for matching
They are mainly 3 ways:

  • 2-ways
  • 3-ways
  • 4-ways

How to explain

hand2-way matching

This verifies verifies that Purchase order and invoice information match within your tolerances as follows:
Invoice price <= Purchase order price
Quantity billed <= Quantity Ordered

hand3-way matching

This verifies that the receipt and invoice information match with the quantity tolerances defined:
Invoice price <= Purchase order price
Quantity billed <= Quantity Ordered
Quantity billed <= Quantity received

hand4-way matching

This verifies that acceptance documents and invoice information match within the quantity tolerances defined:
Invoice price <= Purchase order price
Quantity billed <= Quantity Ordered
Quantity billed <= Quantity received
Quantity billed <= Quantity accepted

How to relate between PO and invoice tables:

Here are the entity relationship diagram, explaining 2 way and 3 way matching condition.

2way

3way

In summary

compare

Posted in Oracle Payable, Oracle Purchasing | 1 Comment »

Page 3 of 3«123

Next Entries »