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 Solution, which should be further customized and tuned to your specific integration requirements
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
