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 5919)

UI - Receiving an Error with Customer Product Price History

This information applies to :

Article ID
5919

Created/Updated
November 13, 2015

Category
Troubleshooting

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Issue:
When using the Tools-Show Customer Product Price History, you receive a Run Time 3075 syntax error(missing operator) in query expression

Cause:
This can occur if the Account Number brought in from your contact manager contains an invalid character such as a single quote.

Solution:
If your contact manager is ACT!, a setting may have been incorrectly set:
1. In QuoteWerks, Go to the Contacts-Setup Contact Manager Menu and select GoldMine as your contact manager.
2. Click on the GoldMine Setup Button
3. Select the Misc Tab and Uncheck the Use GoldMine AccountNo vs. Company Name to lookup customer price history.
4. Exit QuoteWerks.
5. Start QuoteWerks and go to the Contacts-Setup Contact Manager Menu and select ACT! as your contact manager.

New Search

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