QUOTEWERKS: Getting the address on documents to "look right"

Are you struggling to get the address on your QuoteWerks document layouts to “look right”?

With all the fields available – Address1, Address2, Address3, City, State, Zip and Country – an actual address might be held in just a few or all seven of these fields.

Then try these formulae – just open your QuoteWerks document layout, click the formula button, give the formula a name (e.g. “SOLDTO_ADDRESS”), click OK and copy/paste the formula in.

Sold To:
documentheaders->soldtoaddress1+(.if.(documentheaders->soldtoaddress1=””.or.documentheaders->soldtoaddress2=””).then.””.else.”, “)+documentheaders->soldtoaddress2+addline(documentheaders->soldtoaddress3)+addline(documentheaders->soldtocity)+addline(documentheaders->soldtostate+(.if.(documentheaders->soldtostate=””.or.documentheaders->soldtopostalcode=””).then.””.else.”, “)+documentheaders->soldtopostalcode)+addline(documentheaders->soldtocountry)

Ship To:
documentheaders->shiptoaddress1+(.if.(documentheaders->shiptoaddress1=””.or.documentheaders->shiptoaddress2=””).then.””.else.”, “)+documentheaders->shiptoaddress2+addline(documentheaders->shiptoaddress3)+addline(documentheaders->shiptocity)+addline(documentheaders->shiptostate+(.if.(documentheaders->shiptostate=””.or.documentheaders->shiptopostalcode=””).then.””.else.”, “)+documentheaders->shiptopostalcode)+addline(documentheaders->shiptocountry)

Bill To:
documentheaders->billtoaddress1+(.if.(documentheaders->billtoaddress1=””.or.documentheaders->billtoaddress2=””).then.””.else.”, “)+documentheaders->billtoaddress2+addline(documentheaders->billtoaddress3)+addline(documentheaders->billtocity)+addline(documentheaders->billtostate+(.if.(documentheaders->billtostate=””.or.documentheaders->billtopostalcode=””).then.””.else.”, “)+documentheaders->billtopostalcode)+addline(documentheaders->billtocountry)

For further assistance with QuoteWerks document and report layout authoring, please do not hesitate to get in touch with us on 0844 357 7360 or email sales@hilltopsit.co.uk as well as having a host of report layout examples that we have developed over the years, we offer very competitive hourly rates for building layouts and reports specific to your business’s requirements.

We look forward to hearing from you!