on 10-25-2016 3:05 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.