Boyum Validation to prevent Sales Order entry for Leads

Mike White

• June 12, 2024 22:03

I am using a Boyum Validation to validate the BP is a Customer and not a Lead in Sales Order Entry. However, I cannot get the SQL Condition to work properly. I am on HANA BTW. 

I have tried:

@STORE1 = SQL('SELECT T0."CardType" FROM OCRD T0 WHERE T0."CardCode" = $[$4.0.0]');

IF (@STORE1 = 'L')

BEGIN

SELECT 'Lead'

END

I also tried this SQL Condition, and all I get is an error message....

IF SQL('SELECT T0."CardType" FROM OCRD T0 WHERE T0."CardCode" = $[$4.0.0]') = 'L'

BEGIN

   SELECT 'Lead' FOR BROWSE

END

HELP!!!

Vote

0

• 

  Geoff Booth

  • June 13, 2024 18:15

  Try this:

  
• 

  Mike White

  • June 13, 2024 18:21

  Thank you Geoff, that actually worked. I used a similar SQL for HANA, but that's the exact format I needed! You are the man!

  SELECT CASE T0."CardType"

  WHEN 'L' THEN 'Message'

  END FROM OCRD T0 WHERE T0."CardCode" = $[$4.0.0]

Please sign in to leave a comment.