Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Synchronize items with HQ
Microsoft Dynamics RMS (Archived)

Synchronize items with HQ

(0) ShareShare
ReportReport
Posted on by Gerald Rothaus 2,930

I have a client that has entered items in stores and also hq. How can I get them to sync?

I tried a 250 and a 101 but it doesn't seem to do it.

Thanks,

-Jerry

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Synchronize items with HQ

    All answers above are correct.  However, we hve created as part of the Retail Realm Store Utility a took that finds all items in Store that do not have HQID and then creates them in HQ or gives a message that item is already in existence in HQ.  It aslso provides the facility to create a worksheet to synchronise and send data to all stores.  Please contact me if you wish to know more.

    Afshin Alikhani - afshin@rrdisti.com

    Retail Realm

    PLEASE NOTE: Retail Realm is a distributor.  If you are an ed user you must have your reseller contact us and you need to obtain our add-ons through your resellers.

  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at
    Re: Synchronize items with HQ

    Jerry,

    This is a task that can be done, but much care must be taken when fixing this.  First off, Keith is correct, that in HQ items should ONLY be pushed down from HQ to store.  But whats done is done.  You can fix this but you will have to follow these steps:

    1. Stop HQ Sync (exiting out of HQ Server will do the trick)
    2. Create the items at HQ, need to have the same information or the store's info will get over written.
    3. Open up the newly created HQ item in the database and find the ID value for the item
    4. Open up the same item at the store level in the database and put the value found in #3 into the HQID for that item.
    5. Repeat for any other items created in the way
    6. Start HQ Sync again
    7. Pray (this part is option, but I find it helps my peace of mind)

    All kidding aside, we have been able to rejoin items for many customer in this way, though it can be cumbersome for many items.  A few important notes:

    • Proceed only if you are 150% confident in your ability to work with RMS at the database level.
    • TAKE BACKUPS OF BOTH HQ AND STORE OPS BEFORE DOING THIS! (Yes that was all upper case on purpose.)
    • Insert standard at your own risk, and RITE/me are not responsible, etc...
    • If you are experiencing a situation where items were created a both the store and HQ (same item) this will only fix one issue, you will still have duplicates.  Setting the same HQID for both items would be very bad, don't do it.

    If you are  experiencing duplicates or need help resolving this issue, my support team would be happy to discuss the scope of the issues with you and come up with a plan on what it would take to fix.

  • Keith.N Profile Picture
    Keith.N on at
    Re: Synchronize items with HQ

    Hi Gerald,

    All items must be created at Headquarters and then sent down to the store. Items created at the store level cannot be sent up to Headquarters.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans