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
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
SHARE
