Skip to Content

Query based approval procedure

Dear Experts,

Happy New Year to all..

I have to setup approval procedure on Purchase Order form and there is one condition that if unit price is not equal to U_Decided_Price(UDF in POR1) (POR1.Price!=POR1.U_Decided_Price) then P.O. only should go to approval procedure and if unit price is equal to U_Decided _Price(POR1.Price=POR1.U_Decided_Price) then P.O. should get add without any approval.

I was thinking if it is possible through Query based Approval procedure or any alternative.

Suggestion would be highly appreciated.

Regards-

Ravi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 10:29 PM

    Dear Ravi,

    Because approval only deal with header table, it will not work for POR1 unless you only check the 1st line. You may setup alert instead. If the price is different, an alert can be sent to any users you want.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 11:13 AM

    Hi Ravi,

    Scenario is Possible only we have to put a simple MS-SQL query in Approval template setup:

    Select * from POR1 where Price!=U_Decided_Price

    But It will work propely when you configure it in approval procedure....

    Hope it'll help you...


    App.JPG (49.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2014 at 01:18 PM

    Hi,

    Approval procedure will work only on header level not on row level.

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.