on 04-25-2012 6:26 PM
Hi,
In the query below defined for approval process for sales order i need to exclude few customers i.e. i dont want the sales order for few customers to go for approval even if the condition is satisfied
SELECT DISTINCT 'TRUE' FROM OCRD T1 WHERE T1.CreditLine < ($[$29.0.number] +T1.OrdersBal+T1.Balance) and T1.CardCode=$[$4.0.0]
Please advise !
Mona.
Hi Monica,
Please use below query i hope it's working.
SELECT DISTINCT 'TRUE' FROM OCRD T1 WHERE T1.CreditLine < ($[$29.0.number] +T1.OrdersBal+T1.Balance) and T1.CardCode=$[$4.0.0] and T1.Cardcode not in ('Cust1','Cust2',...)
Thanks & Regards,
Tushar Nathwani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mona,
Tushar is correct, you just need to add those customers to the last condition and T1.CardCode NOT IN ('CardCode1','CardCode2',....)
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SELECT DISTINCT 'TRUE' FROM OCRD T1
WHERE $[$4.0.0] NOT IN ('<customer1>', '<customer2>', ..., '<customerN>') AND (T1.CreditLine < ($[$29.0.number] +T1.OrdersBal+T1.Balance) and T1.CardCode=$[$4.0.0] )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.