Print This Article Post Comment Add To Favorites Email to Friends Ezine Ready

Dynamics Gp Retail Integration: Ms Rms, Barcode Scanning Notes

By: Alba Spectrum Home | Computers-and-Technology | Software


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). However, 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




Article Source: http://www.eArticlesOnline.com

About the Author:
Andrew Karasev, Alba Spectrum, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Central America


Tags: ,

Please Rate this Article

 

Not yet Rated

Click the XML Icon Above to Receive Software Articles Via RSS!

Recent Related Articles From Software

  • Great Plains Us Payroll Tax Update Service Notes
    By: Alba Spectrum | Dec 31st 2009
    For customers on older versions of Microsoft Dynamics GP, Great Plains Dynamics and eEnteprise, in the case when you are processing Payroll internally (including W2 printout and mailing to your employees) - we would like to let you know that it is possible to update Federal, State and Local Taxes directly in Dynamics GP Pay ... Read

  • Microsoft Dynamics Gp Partner Chicago: Great Plains Customizations
    By: Alba Spectrum | Jan 23rd 2010
    If you are deploying Microsoft Dynamics GP, formerly known as Great Plains Dynamics, Microsoft Great Plains (and their predecessor Great Plains Accounting for DOS, Windows and Macintosh), we would like to review Great Plains customization support options in Chicago, Northern Illinois, North Western Indiana, Southern Wiscons ... Read

  • Development For Microsoft Dynamics Gp, Formerly Known As Great Plains: Dexterity, Econnect
    By: Alba Spectrum | Dec 15th 2009
    Microsoft Dynamics Corporate ERP and CRM family of products includes Dynamics GP (formerly known as Great Plains Dynamics, eEnterprise, Great Plains Select on Pervasive SQL and Ctree), AX (formerly known as Axapta), NAV (known as Navision), SL (Solomon), Microsoft Dynamics CRM (this is CRM application, it might be part of C ... Read

  • Microsoft Dynamics Gp: Recovering Failed Implementation Notes
    By: Alba Spectrum | Jan 4th 2010
    Your Microsoft Dynamics GP (Microsoft Great Plains, Great Plains Dynamics or Great Plains Accounting for DOS, Windows or Macintosh), not successful implementation story might be not unique. GP is mid-market Corporate ERP application, where industry expertise might be required, plus profound technical exposure for your chos ... Read

  • Great Plains Technical Self Support, Or How To Resolve The Issue Without Paying Consultant
    By: Alba Spectrum | Dec 5th 2010
    Each Mid-market Corporate ERP, MRP or Accounting application might require moderate level of technical support, including such delicate topics as data recovery. With multiple years of Dynamics GP and former Great Plains Dynamics and even archaic versions of Great Plains Accounting for DOS and Windows, we can share with you ... Read

  • Barcoding And Warehouse Management For Dynamics Gp Notes
    By: Alba Spectrum | Feb 13th 2010
    If your company deploys Microsoft Dynamics GP Great Plains as your Corporate ERP solution and you have sophisticated Supply Chain Management requirements, including barcode automation, consignment, integration with Retail and Point of Sale (POS, including Microsoft RMS), advanced picking and packing, shipping and receiving ... Read

  • Great Plains Support: Chicago, San Diego Dynamics Gp Partner Newsflash
    By: Alba Spectrum | Jul 9th 2009
    If you have Microsoft Dynamics GP, formerly known as Great Plains Dynamics, eEnterprise, or even Great Plains Accounting for DOS and Windows, regardless of the version, please read your local and nationwide ERP and MRP support highlights. Read

  • Microsoft Dynamics Gp Partner Selection Recommendations
    By: Alba Spectrum | Feb 1st 2010
    If your organization is in process of reviewing and selecting new Corporate ERP application and you are including Microsoft Business Solutions Dynamics GP, we would like to offer you this small article with advises, based on our consulting practice, successful and failed Corporate ERP implementation cases (based on Microsof ... Read

  • Upgrading Old Great Plains To Dynamics Gp Steps Overview
    By: Alba Spectrum | Jan 20th 2010
    If you are on legacy Great Plains Dynamics on MS SQL Server, Pervasive SQL 2000/Btrieve or Ctree, then update to current Microsoft Dynamics GP version 10.0 (also Dynamics GP 11.0 should be released somewhere in May 2010) should take several steps. The main message of this small publication is the fact that each version of ... Read

  • Microsoft Dynamics Gp Partner In Chicago: Barcoding And Warehouse Management Notes
    By: Alba Spectrum | Feb 10th 2010
    If you are located in Chicago metropolitan area and you have light assembly with warehouse management, picking and packing, barcode automated (or intentions to be automated via barcode scanning and upload to your Corporate ERP application) logistics (possibly with consignments), mid-size retail stores with POS application t ... Read


Copyright © 2005-2011 eArticlesOnline, LLC - All Rights Reserved
Terms of Service | Privacy Policy