Approval Query

[Former Member]

Hi,

I am looking for Approval query for the following , Using SAP B1

1. Creating a purchase order, if that unit price is greater the last purchase order

2. For an existing purchase order , If that edit unite price

Please give me a solution ,

I am stack on that issues

[kothandaraman_nagarajan]

Hi,

If purchase order created with only one line item, then you can add approval procedure if unit price greater than last purchase price. Not possible if your PO with more than one line item.

For editing PO, approval procedure will not work. Because approval procedure will be triggered while adding the document. But depending on your version, if user update approved PO, system may trigger approval again.

Regards,

Nagarajan

[Former Member]

I am using SAP B1 8.81 PL11

[Abdul]

Not possible its standard system behaviour run time queries only work on header level.

[KennedyT21]

Hi Akhil T Prasad

Creating a Approval Procedure based on Row level data validation might not be possible.

But the validation check can be build and the transaction could be blocked.

You will need to write this validation SQL code in transaction notification stored procedure.

Regards,

Kennedy

[former_member211473]

Hi,

Learning how to write query is easy, you may learn with practice for your improvement purpose in long term.

Thanks

[Former Member]

Can you suggest any tips to create Approval query