Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / This Customer Already ...
Microsoft Dynamics GP (Archived)

This Customer Already Exists in Another National Account Relationship

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

The user wants to create a National account but when they enter the customer that is to be the parent, they get the error "This Customer Already Exists in Another National Account Relationship". The account shows as its own parent in the customer card, however, when we try to pull it up to see if there are any children, we get the error and no children are listed below. If the user is merely trying to add children to that National Account, then it should not be giving that error when they try to pull it up.

They have had 5 transactions on the customer so far, which they do not wish to delete. They have several accounts that somehow themselves as their parent. What is the best way to fix this?

Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: This Customer Already Exists in Another National Account Relationship

    Yes. I have the article. However, since it said GP 6 and retired, I decided to confirm since the customer is on GP 2013 and the account actually has history and it is not simply a case of an erroneous error on a new account with no history. Thanks!

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: This Customer Already Exists in Another National Account Relationship

    Great advice Nataraj - always check the KB articles first! :)

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: This Customer Already Exists in Another National Account Relationship

    Hi Nola,

    Please find the attached KB Article that can guide you to fix the above error.

    support.microsoft.com/.../850025

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: This Customer Already Exists in Another National Account Relationship

    After running check links try running this in SSMS.

    SELECT T1.CPRCSTNM,T2.CUSTNMBR,T2.CUSTNAME

    FROM RM00105 T1

    INNER JOIN RM00101 T2 ON T1.CPRCSTNM =T2.CPRCSTNM

    ORDER BY T1.CPRCSTNM

    See if this customer ID shows up.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: This Customer Already Exists in Another National Account Relationship

    I would try running Check Links on the Customer Master tables.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans