Skip to Content
0

Approval Query

Apr 28 at 03:29 AM

72

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Ranu Vijay Apr 28 at 06:26 AM
0

Hi,

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

Thanks

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Can you suggest any tips to create Approval query

0
Kennedy T Apr 30 at 05:57 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Abdul Mannan Apr 30 at 01:45 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Apr 30 at 02:24 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

I am using SAP B1 8.81 PL11

0