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

Applies to: Dynamics GP 2010

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 .

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.