QuoteWerks Knowledgebase Topic (Article ID 5919)
UI - Receiving an Error with Customer Product Price History
This information applies to :
November 13, 2015
When using the Tools-Show Customer Product Price History, you receive a Run Time 3075 syntax error(missing operator) in query expression
This can occur if the Account Number brought in from your contact manager contains an invalid character such as a single quote.
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.
©1993-2020 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)