B1 Print and Delivery- Conditional Action case row level

Answered

Tenayu

• July 20, 2018 07:03

Hi,

When I use sql case  on header it works. When I use sql case on row level I coulnt success. Can you tell me, my sql  wrong? or it doesnt work on row level? also is it working on udf?

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

SELECT CASE $[$38.U_ItemGrpNam.0]

WHEN 'MLS' THEN 'Send' WHEN 'MLP' THEN 'Send' END FROM DUMMY

 

 

Kind regards,

 

Tenay Uzun

 

 

 

 

Vote

1

• Official comment

  

  Yaremi Miranda Lopez

  • July 27, 2018 14:01

  Hello.

  Dynamic Syntax will only work on header level fields. As there can be more (or zero in freight-only scenarios) row-level fields it is not possible to use in B1 Print and Delivery.

  Remember Tenay that you shoul only ask question in one place, support or community.

   

Please sign in to leave a comment.