Free Articles, Free Web Content, Reprint Articles
Thursday, June 20, 2019
 
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 SolutionBusiness Management Articles, which should be further customized and tuned to your specific integration requirements

Source: Free Articles from ArticlesFactory.com

ABOUT THE AUTHOR


Andrew Karasev, Alba Spectrum, LLC, http://www.albaspectum.com, help@albaspectrum.com, 1-866-528-0577, serving Great Plains Dynamics GP community since 1994. Please visit our information portal Pegas Planet: http://www.pegasplanet.com. 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



Health
Business
Finance
Travel
Technology
Home Repair
Computers
Marketing
Autos
Family
Entertainment
Law
Education
Communication
Other
Sports
ECommerce
Home Business
Self Help
Internet
Partners


Page loaded in 0.151 seconds