cancel
Showing results for 
Search instead for 
Did you mean: 

Approval procedure query for GRPO quantity greater than PO quantity?

0 Kudos

Hello Experts!

I need some help with creating a query for my approval procedures.

I would like to set up a query based approval template that creates an approval prompt whenever the quantity entered for a GRPO (PDN1.Quantity) is greater than the quantity from the referenced PO (POR1.Quantity).

Thank you so much!

Accepted Solutions (1)

Accepted Solutions (1)

former_member185682
Active Contributor
0 Kudos

Hi Nikka,

The answer in your other thread.

If you have interest, I wrote this document about approval template on line level:


Best regards,

Diego Lother


View Diego Lother's profile on LinkedIn

Answers (2)

Answers (2)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please note that approval procedure does not work for row level. It may work for first line of PO.

Alternatively, you can use transaction notification.

Thanks

MukeshSingh
Participant
0 Kudos

Hi NIkka,

Try this

SELECT DISTINCT 'TRUE' FROM POR1 T0 WHERE T0.DocEntry =$[$38.45.0] AND T0.LineNum=$[$38.46.0] AND T0.PriceBefDi <$[$38.11.number]

Regards,

Mukesh Singh