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
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Using expressions in Invoice Layouts
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Using expressions in Invoice Layouts
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.
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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Google [Bot] and 1 guest