Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. A query does not return certain customer records when you run the query in Collections Management in Microsoft Dynamics GP

A query does not return certain customer records when you run the query in Collections Management in Microsoft Dynamics GP

View products that this article applies to.

SYMPTOMS

When you run a query in Collections Management in Microsoft Dynamics GP 9.0, the query does not return certain customer records.

CAUSE

This problem occurs because the query does not return the customer records that do not have a Statement To address specified in the Customer Maintenance window.

RESOLUTION

To resolve this problem, follow these steps:
1. Locate the customer records that do not have a Statement To address specified. To do this, follow these steps:
a. Start SQL Query Analyzer.
b. Run the following query. 
USE <fabrikam> GO
Note Replace <fabrikam> with the name of the company database.
c. Run the following query. 
SELECT * FROM RM00101 WHERE STADDRCD = ''
Note This query returns all the customer records that do not have a Statement To address assigned in the Customer Maintenance window.
2. Assign a Statement To address to these customer records. To do this, follow these steps:
a. Log on to Microsoft Dynamics GP 9.0.
b. On the Cards menu, point to Sales , and then click Customer .
c. In the Customer Maintenance window, click the lookup button next to the Customer ID box.
d. Click a customer record that the query returned in step 1c, and then click Select .
e. Assign a Statement To address, and then click Save .

↑ Back to the top

DISCLAIMER 

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS. 

↑ Back to the top

Keywords: kb, kbnosurvey, kbMBSMigrate, kbMBSPartner, BemisKB929782, kbtshoot, kbExpertiseInter, kbprb

↑ Back to the top

Article Info
Article ID : 929782
Revision : 1
Created on : 4/4/2017
Published on : 4/4/2017
Exists online : False
Views : 179