Total Pageviews

Friday, April 19, 2013


PO Match Approvals 

When working with Purchase Orders in the Oracle Apps, we generally hear the word Match Approvals. Even though you all know the definitions of the approval and how they effect the invoice, lot of us stuck when we try to get the details, if we have access to only database.

First we will just have look at what the Match Approvals. Match approval is a rule associated between Purchase Order and the Invoicing. There are three types of Match Approvals,
1. 2-Way - PO Line quantity and Invoice quantity should match
2. 3-Way - PO Line quantity, Received quantity and Invoiced quantity should match
3. 4-Way - PO Line quantity, Received quantity, Accepted quantity and Invoiced quantity should match

Now from the Backend how will we come to know a which match approval it is following. Here comes the explanation.

In the PO_LINE_LOCATIONS_ALL table, there exists two columns name INSPECTION_REQUIRED_FLAG and RECEIPT_REQUIRED_FLAG. These two column values decide what is the match approval.

INSPECTION_REQUIRED_FLAGRECEIPT_REQUIRED_FLAGMatch Approval
NN2-Way
NY3-Way
YY4-Way

No comments:

Post a Comment