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!

Related Stories

See all

ConnectWise Sell vs QuoteWerks: Aspirational Perception

Jul 15, 2025

🚀 From Practical to Aspirational: Why MSPs See ConnectWise Sell as the Next Step Beyond QuoteWerks In writing, reflecting and drawing conclusions from the previous blog post comparing ConnectWise Sell and QuoteWerks, it got me wondering whether ConnectWise could be perceived as an aspirational move. As a QuoteWerks reseller, it’s natural to feel a sense […]

READ MORE

QuoteWerks Development Path – A Speculative View

Jul 14, 2025

QuoteWerks has long been a staple in the quoting and proposal software space – for IT and managed services providers, plus many, many other product and service provider verticals. Its journey from a classic Windows application to a hybrid web-enabled platform is not just a tale of modernization, it’s a fascinating case study in software […]

READ MORE

The Digital Backbone of Modern Manufacturing: Trends in Backend Software and Workflow Integration

Jul 10, 2025

In 2025, the manufacturing sector – particularly in the UK and USA – is undergoing a profound transformation. While much attention is given to robotics, AI, and smart factories on the production floor, an equally important revolution is happening behind the scenes: the modernization of backend business software. From quoting and CRM to invoicing and […]

READ MORE