Syntax error in Derived Table while passing @prompts in the Where Clause as optional

Syntax error in Derived Table while passing @prompts in the Where Clause . Can't We mention Optional in @Prompt Syntex in the where clause?

My need is to pass Two below Parameter as optional in the Where Clause.

WHERE (("_BIC_MYBILLTYP" IN (@Prompt(Bill Type))) AND (("_BIC_MYSOLDTO" IN (@Prompt(SoldToParty))) .

I am using BO 4.1 IDT . I tried with One parameter but throwing below error. Kindly Help..

pmkmf.png (55.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers

Skip to Content