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

2 comments

Date Votes
  • Comment author
    Joris Sibenius Trip

    Hi Josh

    $[CURRENT_FORMTYPE] is not available during mass delivery. Why do you use it? As mass delivery configuration is always for a specific document type, it does not make sense to have this conditional action?

     

    0
  • Comment author
    Josh Marcuelo

    Hi Joris,
    I was trying to use one report action for all document type to manage configuration easier. 

    0

Please sign in to leave a comment.