Microsoft Great Plains 8.0 - Microsoft RMS 1,2 Multi-Store Integration – overview
Written 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 t....
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!
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.
(NC)-As the first smog alert warnings of the season approach, Canadians are being urged to use ethanol-blended fuel to alleviate the urban smog problems plaguing many parts of the country. Many regions such Vancouver, Calgary, Montreal and most pa....
Read more
Low Speed impacts are those that take pace at speeds under 10 MPH. There’s often little (if any) visible Property Damage done to the rear of ones motor vehicle. However, those who are struck (especially in the rear) often have injuries, especially....
Read more
Remember back when selling online was a new experience? Dealers tried everything to sell their vehicles online. Today’s market has expanded to include several hot online marketplaces but there is the largest online marketplace, Ebay. Ebay has e....
Read more
Remember back when selling online was a new experience? Dealers tried everything to sell their vehicles online. Today’s market has expanded to include several hot online marketplaces. The largest online marketplace is Ebay. Ebay has evolved in....
Read more
What does BPU™ stand for? (BPU™ is a trademark of SupraStore.com)Basic Performance Upgrades. These modifications are: A full length three inch down-pipe (with or with-out high flow cats), 3” (75mm) or bigger cat-back exhaust system, raised boost....
Read more
