Split Purchase Order

[Hussein982]

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

[Felipe_Ribeir0 · Accepted solution]

Hi @Hussein982 

One way of doing this

[Hussein982]

@Felipe_Ribeir0  thank you so much for your prompt response. Issue solved.