Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / HQ implementation : da...
Microsoft Dynamics RMS (Archived)

HQ implementation : database

(0) ShareShare
ReportReport
Posted on by ledmirage2989 45

I have two stores that have its own databases with over 150,000 items. Some of these items have different item descriptions, supplier,  category, and etc..

I am about to implement HQ but would like to know if the HQ sync function can detect the differences in the items and automatically sync the information from one database to another?

 I could keep duplicate the database from one store to the other so they match but I don't want to lose years sales history.  Thank you!

*This post is locked for comments

  • Mihir Shah Profile Picture
    Mihir Shah 985 on at
    Re: HQ implementation : database

    You should be able to save the sales history for the larger store

    Try this --

    1. Larger store - Add all items / suppliers / dept. / category etc for both stores in the larger store.

    2. Make HQ database from larger store database

    3. Sync. HQ and existing larger store.

    4. Create new smaller store database from HQ.

    5. Sync small store and HQ.

  • ledmirage2989 Profile Picture
    ledmirage2989 45 on at
    Re: HQ implementation : database

    Dear Sir,

    Thank you for you reply.

    In that case, I will use the database of the larger store of the two as the master database. By doing so, I will be able to keep the sales history of the larger store. But I will lose sales history of the smaller store. Is this the right assumption or is there a way to save the sales history?

    Thank you again.

  • Suggested answer
    Mihir Shah Profile Picture
    Mihir Shah 985 on at
    Re: HQ implementation : database

    The answer is no. HQ will not automatically detect the differences in the items.

    You may want to make a single master database of all items/depts./categories in both the stores and create HQ database. Than you can try to sync each store with HQ.

    Take a backup and test the above before going live.

    RMS HQ needs more learning than Store Operations.

    Mihir

    Diviasoft, Inc.

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