Mass Delivery + Conditional action
I get an error when using mass delivery with conditional action like this
SELECT CASE
--Purchase
WHEN $[CURRENT_FORMTYPE] = 142 -- Purchase Order
OR $[CURRENT_FORMTYPE] = 65301 -- AP DP Invoice
OR $[CURRENT_FORMTYPE] = 65309 -- AP DP Request
THEN 'ITEM PURCHASE'
-- Sales
WHEN $[CURRENT_FORMTYPE] = 141 -- Credit Note
OR $[CURRENT_FORMTYPE] = 133 -- AR Invoice
OR $[CURRENT_FORMTYPE] = 65300 -- AR DP Invoice
THEN 'ITEM SALES'
WHEN $[CURRENT_FORMTYPE] = 139 -- Sales Order
THEN 'ITEM SO'
WHEN $[CURRENT_FORMTYPE] = 140 -- Delivery
THEN 'ITEM DEL'
END AS RESULT FROM DUMMY WHERE '$[$3.0.0]' = 'I'

Comments
0 comments
Please sign in to leave a comment.