Dynamics Community Forum Thread Details

Trying to stop work redundancy

We are using Retail Management Systems 1.2, We have 2 store locations.

Often when we move product from another store we have to rescan and re-enter all the information over again.

I was told that a central server software package would be necessary to link the two stores, but im wondering how we can bypass the redundant work.

Ryan

If you're working with HQ in RMS you'll have the opportunity to synchronize your data efficiently. In other hand, if you don't have this RMS add-on, and that you're using Microsoft Office (insert any version here) Professionnal, you can then use Access to do the work.

First, create a new database in Access and link all the tables from RMS trough an OCDB link.

Then export all your new items in a CSV format from your first store.

Send that information to your other store by email, usb key, etc.

Import the CSV file in Access and append the new information to the database.

Sure it takes some knowledge to do that, but it is possible. The best choice for a non IT professionnal is to install the HQ add-on from MS Dynamics. You'll be able to view your reports from both stores in one location. Reports for each of the stores or for the whole company, etc. You'll be able to synchronize your store in case of price changes, new items, use global customers, etc.

Quick Links

Leaderboard