Free Articles, Free Web Content, Reprint Articles
Monday, March 30, 2020
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles

Great Plains Consultant Los Angeles News: GP Integration with Microsoft RMS

Microsoft Retail Management System or RMS fits to mid-size retailers and as doing its job in this segment it often requires, or better say needs, integration with back office accounting system. For mid-market ERP role is often played by Microsoft Dynamics GP or Great Plains.

Out of the box Great Plains has integration with RMS on General Ledger level and it does the job if this is just what you need. But if you would like to control your sales and inventory in Great Plains, then you need more advanced integration. In this small publication we would like to give you technical and functional highlights:

1. Microsoft SQL Server DB platform. Both applications deploy MS SQL Server: Dynamics GP and RMS (Headquarters and Store Operations). This opens such integration programming tool as SQL Stored Procedures.

2. Great Plains Integration Manager option. If you have moderate level of retail transactions, then you can consider deploying GP Integration Manager with some VBA scripting, where you import daily sales and then in VBA mark these transactions as being exported. Another option is to send day from and day to as parameters. This IM approach is very reliable, however it requires operator intervention to launch integration. If you have IT programmers, who can automate IM call on macros level, or deploy the tool, sold separately by Microsoft Business Solutions through GP partner channel then you can achieve complete automation level even with Integration Manager

3. Alba Spectrum GP RMS Integration. This product is very flexible and is written in SQL stored procedures. You can target either GP Sales Order Processing module (where Inventory control side is needed) or directly Receivable Management (where the only concern is proper GL distribution, driven by RMS Items classification). It also addresses Purchase Order Processing side. It is probably very difficult to define standard logic in Great Plains to RMS integration, this is why this specific integration can be considered as SolutionComputer Technology Articles, which should be further customized and tuned to your specific integration requirements

Source: Free Articles from


Andrew Karasev, Alba Spectrum, LLC,,, 1-866-528-0577, serving Great Plains Dynamics GP community since 1994. Please visit our information portal Pegas Planet: GP, SAP B1 local service in San Diego and Los Angeles Area: San Marcos, Mission Viejo, Escondido, Rancho Bernardo, Poway, La Jolla, Huntington Beach, Irvine, Carlsbad, Oceanside, Pasadena, La Mesa, El Cajon, Chula Vista

Home Repair
Home Business
Self Help

Page loaded in 0.119 seconds