Skip to Content
avatar image
Former Member

Approval Template when creating marketing documents from a certain Item group

Hi Experts!

Is there a query for an approval template that whenever a certain marketing document is created using a certain item from an item code, an approval would be required before it would successfully be added?

For example, when a accounting staff creates a PO using an item from "Supplies" item group, an approval would pop out.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2016 at 12:34 PM

    Hi Nikkita,

    Here what you need

    SELECT 'TRUE' FROM OITM INNER JOIN OITB ON OITM.ItmsGrpCod = OITB.ItmsGrpCod WHERE ItemCode = $[$38.1.0] AND OITB.ItmsGrpNam = 'Supplies'

    Regards,

    Danilo

    Add comment
    10|10000 characters needed characters exceeded