Conditional Approval Procedure for GRPO

[Former Member]

Hi All

I have a requirement where I need to send the GRPO document for approval to authorizer 'A' when my item is either 'X' or 'Y'.

Else for any other item the GRPOdocument needs to be sent to authorizer 'B'.

Is there a way to achieve this using conditional approval procedure and if yes how can the query be structured.

Regards,

Nikita

[former_member185682 · Accepted solution]

Hi Nikita,

Yes, there is a way.

Look this document to see how to create approval template at line level on marketing documents:

In your case I believe that you will need two approval templates one with this query:

SELECT CASE WHEN $[$38.1] = 'Item x' OR $[$38.1] = 'Item y' THEN 'TRUE' ELSE 'FALSE' END

and other with this:

SELECT CASE WHEN $[$38.1] <> 'Item x' AND $[$38.1] <> 'Item y' THEN 'TRUE' ELSE 'FALSE' END  

Case your GRPO document has the item X or item y and another item, two approval procedures will be started.

Hope it helps.

---

Best regards,

Diego Lother

[Former Member · Accepted solution]

Hi Diego

The Queries worked like a charm and the article was very helpful too. Thanks Diego.

Regards,

Nikita