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

MS CRM - Account Information Not Available Via Search

This information applies to :

Article ID
6226

Created/Updated
February 7, 2006

Category
MS CRM

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Issue:
When searching on the Sold To/Ship To (magnifying glass button) for a MS CRM company using the Account Name field no results return. The company name is displayed when searching for a Contact that is associated with that Account.

Cause:
The Accout StatusCode field in MS CRM is set to inactive for that Account which does not allow it to be directly located via searching based on Account Name.

Solution:

QuoteWerks Technical Support does not provide support for backend operations including the following steps. Please backup your data prior to performing the following:.

Your SQL Administrator will need to make this change as it requires operations on the backend of the MS CRM SQL database.

1. Close down active sessions of MS CRM and QuoteWerks.

2. In the AccountBase table there is a field called StatusCode.
-This is an integer type field and has no default value.

3. The values for status code are Active=1 and Inactive=2. If these are of any other value, change them to the appropriate value.

New Search

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