Skip to Content
0

Approval Template when creating marketing documents from a certain Item group

Oct 25, 2016 at 02:05 PM

68

avatar image
Former Member

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!

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

1 Answer

Danilo Kasparian Oct 26, 2016 at 12:34 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded