Dynamics GP Retail Integration: MS RMS, Barcode Scanning Notes

Aug 10
07:47

2009

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

If you are looking for integrated solution for your midsize retail stores chain, consider combination of Microsoft Dynamics GP (formerly known as Great Plains Dynamics) and Microsoft Retail Management System (often referred as Microsoft RMS).

mediaimage

However,Dynamics GP Retail Integration: MS RMS, Barcode Scanning Notes  Articles often Retail and Point Of Sale systems integration to accounting back end may have unique requirements (such as lot and serial numbering as part of item barcode).  If your POS system is already in production, we could reasonably integrate your existing Point of Sale to Dynamics GP via set of proven SQL Stored Procedures.  If you are in tiny business, you may consider use barcode scanner as replacement to POS, especially in international small business retail business, however in USA we recommend you to deploy POS (Counterpoint, for example).  This article may look a bit technical, as we are writing for POS Programmers and IT specialists:

 

1.       Microsoft RMS as POS, Warehouse Management and Centralized Supply Chain Management.  RMS allows you to deploy POS, Warehouse Management (WM is for one specific store, but it could be used for the whole organization if you have the only store as small or midsize shop), and RMS Headquarters (it consolidates Stores sales into central DB, similar in structure to Store Operations DB)

 

2.       MS RMS integration points to Dynamics GP.  If you are multi stores retail business and you are executing your Supply Chain Management via MS RMS Headquarters, naturally integration should be implemented on the Headquarters DB level to your Dynamics GP companies.  Schemas might be Store to Dedicated GP company, or Multiple Stores to One GP Company, or mixed, when one set of stores is consolidated into One GP company and another set into second GP company, etc.  If you do not sell to the account (like in retail store for the fitness club), please consider to create Walk-In Customer in GP RM module

 

3.       POS Transaction in Dynamics GP.  There are two options: to move Point Of Sale transaction as Sales Order Processing document (in Dynamics GP SOP module), or consolidate it as single line invoice in GP Receivable Management module

 

4.       Purchasing and Barcode Label Printing in Dynamics GP.  Some retailers prefer to control merchandise replenishment in their ERP system, in our case Great Plains Dynamics.  In GP you can deploy sophisticated methods for generating barcode for your newly received items and initiate this process on POP Purchase Receipts.  Consider such popular reporting tools as Crystal Reports, SSRS, or Dynamics GP ReportWriter for Item label printing

 

5.       Barcoding in Supply Chain Management.  Dynamics GP ERP, MRP, SCM logic is too rich to expect one of the existing GP Add-ons (custom extensions, programmed and supported by one of the Dynamics GP ISV partners) to do the job out-of-the-box.  We name our approach "solution", where we offer proven programming code from our products to be tuned for your specific GP barcoding integration interface

 

6.       Out-of-the-box Microsoft Dynamics GP to MS RMS integration.  You should be able to deploy this product with some support from our technical consultants and technicians in the case when you have straight forward integration rules from RMS Headquarters or Store Operation DB to Dynamics GP

 

7.       MS RMS integration options via Dynamics GP eConnect.  For larger retail chain we recommend to consider Great Plains eConnect programming, especially when your Retail prices are in constant change: buy one get one free, each item is 10 cents, if you buy this you can take that item free.  eConnect allows you to control your integration to GP, and do not depend on often simplified business logic of existing Great Plains Add-Ons.  Please be sure that you are familiar with XML parameters and coding

 

8.       eCommerce Shopping Card Integration to GP.  We have special project Order Connector, which allows you to integrate PHP, Linux or custom ecommerce application customers and invoices to Dynamics GP Sales Order Processing Module

 

9.       GP Retail integration internationally.  We should be able to help you if your business is located in USA, Canada, Latin America, Brazil, Pacific, Philippines, Singapore, Australia, New Zealand.  If you are in Europe: UK, Poland, Germany, Spain, France, Portugal, Russia, Ukraine, Lithuania, Latvia, Estonia - we can help you conceptually, or via remote support, or if you agree to pay our travel cost from USA.  The same applies to South African based businesses.  Dynamics GP is localize in most of the English Speaking Countries, plus in Latam: Argentina, Uruguay, Paraguay, Chile, Venezuela, Colombia, Costa Rica, Honduras, Nicaragua, Panama, Guatemala, Dominican Republic, Puerto Rico, Peru, Bolivia, Ecuador, Paraguay, Mexico

 

10.   How to get help?  Please, feel free to call us: 1-866-528-0577, help@albaspectrum.com, internationally: 1-630-961-5918 or skype: albaspectrum