Approval Query for Delivery qty not greater than SO Qty

[Former Member]

Hi all

i have created a store procedure to block Delivery from creating Qty more than SO Qty.

But i want that to make a query which i can apply in approval procedure.

If i have created a SO with qty 10

And delivery is prepared for 11 , then it should ask for approval of higher management.

For that we have to use Query in approval procedure , can experts please guide me.

Regards

Vamsi krishna

[Former Member]

Hi Vamsi,

Approval can only apply to header level. Line level is not accessible to Approval except the first line.

Thanks,

Gordon

[former_member218051]

Hi Vamsi,

With the help of base entry field of DLN1 table you can make out the SO against which DC is getting punched.

Then you have to compare delivered quantity and or balance quantity fields from RDR1 table against quantity field from DLN1 table.

In this way loop through all the lines of items delivered.

Hope this logic will help you write your SPTN.

Revert back if not clear.

thanking you

Malhaar

[Former Member]

Hi Vamsi,

What if there are multiple deliveries againse same SO ?

Best Regards,

Samir Gandhi

[Former Member]

Hi  Samir

Yes there might be multiple deliveries , though within multiple deliveries there might be situation where a qty is exceeded  either in single delivery case or multiple delivery case.

Regards

Vamsi Krishna

[Former Member]

Hi Vamsi,

For each item line of delivery, you need to check correosponding SO lines for previously delivered Qty and current delivery Qty, Right OR you also wish to check anything else ?.

Best Regards,

Samir Gandhi