web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Starting National Accounts After Initial Implementation

(0) ShareShare
ReportReport
Posted on by

I've recently started with this company, who've been using GP for the past year.  Their VAR told them that because they didn't set up National Accounts initially, that they can no longer do so.

However, under the presumption that we either own or can Purchase National accounts, could I do the following:

1. Setup The "Parent" National Account.

2. Assign the appropriate Children to this National Account. 

3. If I run Checklinks, will the system write back the CRPCSTNM field to the appropriate RM20101, and other required tables automatically?

4. If Checklinks doesn't do this automatically, could I run a SQL Script to do this manually?  After doing so would you recommend running Checklinks?

Which tables would you recommend running this script for?  Would you recommend including the History Tables as well?

5. Naturally I'd do this first in a copy of my Live DB in a Test Company.

The tests that I'd do after completion of step 4 would be to run an Aging Report, and also test Cash Application to a child's accounts from a Parental Cash Receipt.  Any other recommended tests?

I can't believe that we're the only people who've run into this problem.  Is there a "Cookbook" / Authorized Set of Procedures to go through this process?

If I should happen to go through testing, and roll forward under this new setup, is there any chance that I'd "Void my warranty" by not having Microsoft or a recognized Partner do these steps?

Thanks in advance for your collective input.

 

 

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    L Vail Profile Picture
    65,271 on at

    Hi James,

    As soon as you attach the children to the parent, all of the transaction tables (history too) are populated with the CRPCSTNM value. You don't have to do anything with SQL.  Keep in mind, that you can only remove a child from a parent if no apply information exists between the parent and the child.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    on at

    Thanks so much for your input Leslie.

    I'm going to test it next month. I'll keep you posted if I have any issues.

    J. Falk

  • Community Member Profile Picture
    on at

    did you end up having to run any Check Links processes? I'm in the same boat in that the company I'm now with did not initially setup National Accounts and now that I've set up a Parent Child relationship in test, I don't see the options I should in the Cash Receipts transaction entry window.  Any help is appreciated.

  • Community Member Profile Picture
    on at

    I found my own answer.  I needed to go Tools->Setup->System->Registration and check the "National Accounts" check box to enable the options for the module.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans