Boyum Validation to prevent Sales Order entry for Leads

Mike White

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!!!

Comentarios

2 comentarios

Fecha Votos
  • Comment author
    Geoff Booth

    Try this:

    0
  • Comment author
    Mike White

    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]

    0

Iniciar sesión para dejar un comentario.