SageForum for UK versions of Sage 50- Help and support.

Hi, I'm struggling with using the expression functionality to add text based on given parameters

eg if the currency code is GBP then "Bank Account sort code = 111111" otherwise if currency is EURO then "bank sort is 222222" etc etc so that I don't to create a new layout for each of our five bank accounts when I know that it can be done through this....but I am really struggling with the syntax and I keep getting red lines which tell me I'm doing something wrong but don;t tell me how to fix it.

Another relatively simple one is if the tax code is T20 then "This invoice is subject to the EC reverse charge mechanism" (And if it isn't leave blank)

I have tried copying expressions from reports etc but keep coming up with errors

If you could start me off I would be eternally grateful!

Many thanks

Marianne

The logic of what you are doing is impeccable, however the sage report designer does not work like that !

What you have to do is put both items on separately and then use conditional formatting to hide the printing of the item if the condition is not true.