Mass Delivery + Conditional action

Josh Marcuelo

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.