B1 Print and Delivery- Conditional Action case row level Answered

Tenayu

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

 

 

 

 

Comments

1 comment

Date Votes
  • Comment author
    Yaremi Miranda Lopez
    • Official comment

    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.