Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Duplicate Cust records...
Microsoft Dynamics RMS (Archived)

Duplicate Cust records in SO but not in HQ

(0) ShareShare
ReportReport
Posted on by Tom Taylor56 25

When a new customer is created in SO and a 401 is run the customer is established in HQ properly.  After the next 401 I am finding an additional customer record in SO with all the same info including HQID.  The only decernable difference is the internal ID in the record, and when you look at the purchase history for the customer, the 2nd record does not show any since the trans record points to the Cust.id. 

The environment is RMS 2.0 SP4 .  I have 7 SO and seeing at all.  Any thoughts to root cause, dignosis approach, or how to correct would be greatly appreaciated.

Thanks,

Tom

*This post is locked for comments

  • Tom Taylor56 Profile Picture
    Tom Taylor56 25 on at
    Re: Duplicate Cust records in SO but not in HQ

    Jeff,

    All of the SO systems are running the same level of RMS.  One of the SO systems had the PC it was running on upgraded replacing the HD and going from XP to 7.  In the process of  that being done, the HQ client on that system was initially incorrectly configured causing the HQ DB to have bad data.  A restore of the HQ database was done from a backup about 3 weeks old.  Items lost during that timeframe were recreated leaving this problem now.

    Thanks,

    Tom

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: Duplicate Cust records in SO but not in HQ

    Tom,

    I would run a re-index and a database check at all stores and HQ in SO/HQ Admin.  Backup First!!

    Are the AccountOpened fields the same too?

    Running any add-ons?

    All machines in all stores are running the same version of RMS?

    If any add-ons, are they the same versions?  Can you tell when this started?

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