Dunning Wixard issue with - $[BOY_DUNNING_CARDCODE] Error

Aaron

Hi,

I am trying to use an email condition in the Dunning Wizard to select different email drafts using the B1UP email condition.

When I reference $[BOY_DUNNING_CARDCODE], I receive an “unknown error”. I have tried multiple approaches but continue to encounter the same issue.

Please note that $[BOY_DUNNING_LETTERLEVEL] is working correctly and returns the expected values.

Below is the query I am currently using:

 

SELECT
    CASE
        WHEN OCRD."LangCode" = '22' AND $[BOY_DUNNING_LETTERLEVEL] = 1 THEN 'TEST1'
        WHEN OCRD."LangCode" = '22' AND $[BOY_DUNNING_LETTERLEVEL] = 2 THEN 'TEST2'
        WHEN OCRD."LangCode" = '22' AND $[BOY_DUNNING_LETTERLEVEL] = 3 THEN 'TEST3'
        WHEN OCRD."LangCode" <> '22' AND $[BOY_DUNNING_LETTERLEVEL] = 1 THEN 'Level1'
        WHEN OCRD."LangCode" <> '22' AND $[BOY_DUNNING_LETTERLEVEL] = 2 THEN 'Level2'
        WHEN OCRD."LangCode" <> '22' AND $[BOY_DUNNING_LETTERLEVEL] = 3 THEN 'Level3'
    END
FROM OCRD
WHERE OCRD."CardCode" = $[BOY_DUNNING_CARDCODE];
 

If I enclose $[BOY_DUNNING_CARDCODE] in single quotes, the variable is no longer resolved and the CardCode is not picked up.

Could you please advise what the issue might be and how $[BOY_DUNNING_CARDCODE] should be referenced correctly within a B1UP email condition?

 

Comentarios

0 comentarios

Iniciar sesión para dejar un comentario.