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. Query not pulling in all customers with balances in Collection Management using Microsoft Dynamics GP

Query not pulling in all customers with balances in Collection Management using Microsoft Dynamics GP

View products that this article applies to.

Symptoms

If you build a query in Collections Management, you may notice that all customers with overdue balances are not pulling into the query. Even if you filter only on Customer ID, the query still does not pull in a particular customer that has an overdue balance.

↑ Back to the top

Cause

The "Statement To" Address ID is blank on the Customer Maintenance card in Receivables Management. 

↑ Back to the top

Resolution

Fill in the "Statement To" Address ID on the Customer Maintenance card and then the customer will pull into the query in Collections Management. To do this, follow these steps:


1. On the Cards menu, point to Sales, and click on Customer.

2. Select an Address ID for the Statement To field.

3. Save.

4. Test the query again and now this customer will pull in. To build a query, click on Transactions, point to Sales and click on Build Query. Select the query filters as desired, and click on Query.



↑ Back to the top

More Information

In SQL, the "Statement To" Address ID is stored in the STADDRCD field in the RM Customer MSTR table (RM00101). You can run the below script against the company database in a query window in SQL Server Management Studio to view all the active customers that are missing an address ID in this field:


select * from RM00101 where STADDRCD = '' and INACTIVE = 0 


After identifying the active customers that have a blank Statement To Address ID, then use the steps in the Resolution section above to select an appropriate Address Id in the Statement To field for each customer. 


↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2411688
Revision : 1
Created on : 1/7/2017
Published on : 6/8/2012
Exists online : False
Views : 407