I need my sales orders and invoices to always print the customer billing address and, in a separate area on the sales order/invoice, the delivery address (when different to the billing address).
However, when the billing and delivery addresses are the same, I want the billing address to also be printed in the delivery address field.
I am pretty sure that this will be done by making the delivery address field conditional- probably using an ‘if, is blank’ expression - I am familiar with the syntax in excel but not report designer.
Can anyone help me on this?
Thanks
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
Conditional text
- brucedenney
- Site Admin
- Posts: 4633
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Conditional text
I think what you are asking for is the Invoice address to be printed in the delivery address when the delivery address is blank.
I suggest that the way to do this is
In the place where the delivery name would be enter an expression
It would compare all the delivery fields added together to a blank and if blank then print the Invoice name, otherwise print the delivery name.
Repeat for each of the five address lines.
I suggest that the way to do this is
In the place where the delivery name would be enter an expression
It would compare all the delivery fields added together to a blank and if blank then print the Invoice name, otherwise print the delivery name.
Repeat for each of the five address lines.
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: No registered users and 3 guests