Hi All: Happy new year.
I am trying to identify if there are cases where a Purchase Order (PO) is segmented into two or more POs # to circumvent a purchasing limit (see line 4,5 and 6)
For example, if I have ONE Purchase requisition number that has several PO's # that wont be normal and its an exception (see line 4,5, and 6)
I have a file of 4500 line items of which I need to identify all anomalies similar to line 4, 5 and 6.
I appreciate your help in advance.
Cheers,
# | Purchase Requisition Number | Purchase Order Number | Result |
1 | 10 | 11 | Pass |
2 | 10 | 11 | Pass |
3 | 10 | 11 | Pass |
4 | 20 | 12 | Fail |
5 | 20 | 13 | Fail |
6 | 20 | 14 | Fail |
Solved! Go to Solution.
@Felipe_Ribeir0 thank you so much for your prompt response. Issue solved.