Consolidate National Account Activity in CM Build Query Content provided by Microsoft TechKnowledge Content Issue Summary: Consolidate National Account Activity in CM Build QueryIssue Detail: 1. Create three customers, Test, Test1 & Test2, all in the class called TEST2. Test is the Parent of Test1 & Test2 - use the National Accounts window to set this up.3. Create some transactions on each of the customers so that there is some data to query against in Collections Management.4. In the collections build query window, create a new query5. The restriction on this query should be 'Class ID' = 'TEST', such that it would only pull those three customers6. Run the query7. Notice that the results are correct in the pop-up dialog box, and that when the collections main window appears, all of the customers are available in that window for reference.8. Go back and modify the query - place a check in the box that says 'consolidate national account activity'9. Run the query again10. Notice that the pop-up has the right dollar amounts in it.11. Once the collections main window appears, do a lookup on the customer ID.12. Notice that the only customer ID in the list is 'TEST', the parent customer. This would be good, except that all of the information for TEST is ONLY for TEST, not for the consolidation of TEST, TEST1 and TEST2.Expected Results:In the Collections Main window, after a Consolidated Query has been ran, the Period Amounts, Notes/Comments (in the scrolling window), total due etc. would reflect the consolidated customer, not just the individual parent.Status of Resolution: This problem report is scheduled for a service pack. Corrected with Release 7.5 Service Pack 2This article was TechKnowledge Document ID: 4318 APPLIES TO: Dynamics GP 7.5 Last Updated: 28 Feb 2017 Was this information helpful? Yes No Tell us what we can do to improve the article Submit Thanks! Your feedback will help us improve the support experience.