Microsoft Great Plains 8.0 - Microsoft RMS 1,2 Multi-Store Integration – overview
 by: Andrew Karasev

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS) are originally developed by different software vendors, who had no idea that in the remote future (now) these two applications will be owned by Microsoft and will need to be tightly integrated. Current integration between the two is not an easy thing. At this time MBS has RMS integration on the General Ledger and Purchase Order level into Great Plains out of the box. This integration has some advancements in comparison to old product: QuickSell, but it is still GL and PO only. We do understand the need for midsize and large retail companies, structured as clubs and selling on account to their members to have more adequate integration when you can synchronize your Sales information and have robust Great Plains reporting.

There is third party integration available on the market and supported by Alba Spectrum Technologies. Its features:

    * Accounts Receivables transactions move from RMS to Great Plains

    * Multiple Stores – Multiple Great Plains companies mapping

    * Sales Order Processing transaction integration (settings allow you to have either AR or SOP transactions created in GP)

    * Purchase Order Processing POs and Receipts integration (it also imports Open POs - Partial Receipts)

    * Automatic new customer move from RMS to GP

    * Automatic new vendor import

    * From technical side – integration is a set of SQL stored procedures and Great Plains Dexterity custom setup form. You can also schedule integration as SQL job to run overnight, looping through all your RMS stores

    * Recommended settings – targeting RMS Headquarters database (after daily transactions migration from Stores to Headquarter), however you could use linked SQL server to your Store Operation databases and pull daily transactions directly from there

Happy integrating! if you want us to do the job or use our product - give us a call 1-630-961-5918 or 1-866-528-0577! [email protected]

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM, Microsoft RMS customization company, serving clients in Chicago, Arizona, Colorado, California, Texas, New York, Georgia, Florida, Minnesota and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

[email protected]