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.
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_FLAG | RECEIPT_REQUIRED_FLAG | Match Approval |
|---|---|---|
| N | N | 2-Way |
| N | Y | 3-Way |
| Y | Y | 4-Way |
No comments:
Post a Comment