Skip to Content
avatar image
Former Member

Approval Query

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 28 at 06:26 AM

    Hi,

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

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 30 at 05:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 30 at 01:45 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 30 at 02:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded