This article provides the AQB (Advanced Query Builder) query that can be used to pull up SalesRep information in the Customer Contact Address' Custom Fields.
The following query can be used to create a custom report in the Advanced Query Builder showing all SalesRep information in the Customer Contact Address' Custom Fields:
[DB Schema Name].[ADDRESS] (NOLOCK)
TYPE = 6
Refer to Building a Custom Report using Advanced Query Builder SQL Statements for more information on how to use the AQB to execute the above query.
Please sign in to leave a comment.