407-248-1481
QuoteWerks Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Start Free Trial
Customer Area

QuoteWerks Knowledgebase Topic (Article ID 6201)

Print Layouts - Remove Comma between city and state

This information applies to :

Article ID
6201

Created/Updated
July 17, 2019

Category
Print Layouts

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Issue:
I am in a country that does not use the City field in QuoteWerks. A "Rogue" comma appears before the state field. How can this be removed


Cause:
The Full Address Field assumes that a city will be filled out.

Solution:
You can use the following formula in place of the Full Address field:

(DocumentHeaders->SoldToAddress1)+ ADDLINE(DocumentHeaders->SoldToAddress2)+ ADDLINE(DocumentHeaders->SoldToAddress3)+Addline(DocumentHeaders->SoldToState+" "+DocumentHeaders->SoldToPostalCode)

If you need additional help with the addline formula, please review Article: 5443

New Search

  •            
©1993-2024 Aspire Technologies, Inc.
    407-248-1481 (9am-5pm ET M-F)