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
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 Article Source:http://www.articlesbase.com/software-articles/dynamics-gp-retail-integration-ms-rms-barcode-scanning-notes-1110261.html
 Intuit Quicken Deluxe 2011 Brand New No Box Sealed  $11.99 Time Remaining: 4d 9h 1m Buy It Now for only: $11.99 Click To Buy Now |
 QUICKEN HOME AND BUSINESS 2012 BRAND NEW FREE SHIPPING $36.00 (5 Bids) Time Remaining: 1h 20m Click To Buy Now Bid now |
 Intuit Quicken Home and Business 2011 Brand New No Box Sealed $18.99 Time Remaining: 1d 22h 48m Buy It Now for only: $18.99 Click To Buy Now |
 New Sealed Adobe Photoshop Elements 10Premiere Elements 10 Full Bundle Version $66.00 (13 Bids) Time Remaining: 1h 21m Click To Buy Now Bid now |
 NEW QuickBooks Pro 2012 Accounting Software Sealed Retail Box Full Version $129.95 Time Remaining: 21d 19h 48m Buy It Now for only: $129.95 Click To Buy Now |
 Nancy Drew Triple Threat 2 PC CD ROM Software $3.28 (6 Bids) Time Remaining: 54m Click To Buy Now Bid now |
 New CorelDRAW Graphics Suite X5 Full Version $49.99 Time Remaining: 1d 14h 5m Buy It Now for only: $49.99 Click To Buy Now |
 FINAL CUT STUDIO 2 FINAL CUT PRO 6 COLOR MOTION 3 COMPRESSOR 3 ACADEMIC VERSION $169.99 (1 Bid) Time Remaining: 4h 32m Click To Buy Now Bid now |
 Norton 360 60 V6 3 PCs 1 Year Retail All In One AntiVirus Internet Security $32.99 Time Remaining: 17d 19h 29m Buy It Now for only: $32.99 Click To Buy Now |
 Microsoft Office Professional Plus 2010 2 PC $169.50 (11 Bids) Time Remaining: 1h 13m Click To Buy Now Bid now |
 Norton AntiVirus 2012 Retail 1 PC 1 Year Symantec $15.99 Time Remaining: 19d 19h 7m Buy It Now for only: $15.99 Click To Buy Now |
 Microsoft Office Mac 2011 Home Business $57.55 (4 Bids) Time Remaining: 2h 19m Click To Buy Now Bid now |
 Norton 360 60 Retail BOX 3 PC 1 Year All In One AntiVirus Internet Security V6 $33.99 Time Remaining: 2d 18h 24m Buy It Now for only: $33.99 Click To Buy Now |
 MS Office Professional 2010 $149.99 Time Remaining: 2h 9m Click To Buy Now Bid now |
 Norton Internet Security 2012 Retail 1 User License 3 Activations w AntiVirus $22.99 Time Remaining: 29d 5h 4m Buy It Now for only: $22.99 Click To Buy Now |
 Microsoft Office Small Business 2007 Upgrade BRAND NEW IN UNOPENED BOX $80.99 (2 Bids) Time Remaining: 30m Click To Buy Now Bid now |
 Norton 360 Version 5 50 All In One RETAIL 3 PCs $32.50 Time Remaining: 18d 13h 36m Buy It Now for only: $32.50 Click To Buy Now |
 Norton 360 60 V6 3 PCs 1 Year Retail All In One AntiVirus Internet Security $30.00 (4 Bids) Time Remaining: 50m Click To Buy Now Bid now |
 Intuit Quicken Premier 2011 Brand New No Box Sealed $14.99 Time Remaining: 3d 10h 41m Buy It Now for only: $14.99 Click To Buy Now |
 Norton Internet Security 2012 Retail 1 User License 3 Activations w AntiVirus $16.50 (9 Bids) Time Remaining: 2h Click To Buy Now Bid now |
 Kaspersky Internet Security 2012 Retail Box 3 PC 1 Year $23.99 Time Remaining: 17d 17h 21m Buy It Now for only: $23.99 Click To Buy Now |
 MICROSOFT PROJECT 2010 SOFTWARE TRAINING TUTORIALS 17 HOURS $46.97 Time Remaining: 2h 5m Click To Buy Now Bid now |
 Microsoft Expression Web 3 Academic Box $29.99 Time Remaining: 28d 1h 9m Buy It Now for only: $29.99 Click To Buy Now |
 QuickBooks Pro 2012 $122.50 (23 Bids) Time Remaining: 46m Click To Buy Now Bid now |
 QUICKEN HOME AND BUSINESS 2012 BRNAD NEW FULL VERSION $39.88 Time Remaining: 18d 26m Buy It Now for only: $39.88 Click To Buy Now |
 Webroot SecureAnywhere Complete 2012 1YR 3USER Elect+Postal Delivery $23.99 Time Remaining: 41m Buy It Now for only: $26.99 Click To Buy Now Bid now |
 Intuit Quicken Rental Propery Manager 2011 Brand New No Box Sealed $22.99 Time Remaining: 4d 12h 34m Buy It Now for only: $22.99 Click To Buy Now |
 Vintage Pipe and Cigarette Lighter Organizer Software $7.25 (1 Bid) Time Remaining: 56m Click To Buy Now Bid now |
 TurboTax BUSINESS for Tax Year 2011 by Intuit NIB SEALED Free Shipping Fast $22.00 Time Remaining: 6d 15h 44m Buy It Now for only: $22.00 Click To Buy Now |
 Norton Internet Security 2012 Retail 1 User License 3 Activations w AntiVirus $19.99 Time Remaining: 35m Click To Buy Now Bid now |
 NERO 11 PLATINIUM $49.00 Time Remaining: 6d 4h 6m Buy It Now for only: $49.00 Click To Buy Now |
 Microsoft Windows Home Server With Power Pack 3 OEM Used $29.99 Time Remaining: 45m Click To Buy Now Bid now |
|
NEW QuickBooks Pro 2012 Accounting Software Sealed Retail Box Full Version $129.95 Time Remaining: 21d 19h 48m Buy It Now for only: $129.95 Click To Buy Now |
 Windows 7 32 bit OEM DVD NOT activated or registered $52.00 (9 Bids) Time Remaining: 1h 1m Click To Buy Now Bid now |
|
Intuit Quicken Deluxe 2011 Brand New No Box Sealed $11.99 Time Remaining: 4d 9h 1m Buy It Now for only: $11.99 Click To Buy Now |
 Windows 7 Professional Upgrade Includes Genuine 32 64 bit discs Authentic Key $87.06 (13 Bids) Time Remaining: 50m Click To Buy Now Bid now |
 Norton Internet Security 2012 CD 1 User 1 Yr Factory Fresh CD $16.99 Time Remaining: 20d 1h 19m Buy It Now for only: $16.99 Click To Buy Now |
 Windows XP Pro Retail Full With Key $40.00 (1 Bid) Time Remaining: 2h 15m Click To Buy Now Bid now |
 NEW RETAIL McAfee Total Protection 2012 3 Users LATEST VERSION In Sealed Box $13.25 Time Remaining: 4d 20h 4m Buy It Now for only: $13.25 Click To Buy Now |
 Mac OS X 103 discs for iMac including Software Restore $27.98 (6 Bids) Time Remaining: 1h 5m Click To Buy Now Bid now |
 Norton Internet Security 2012 1 User License for 3 PCS Installs Antivirus $21.97 Time Remaining: 17d 11h 48m Buy It Now for only: $21.97 Click To Buy Now |
 Adobe Acrobat 70 Standard for Windows $4.99 (1 Bid) Time Remaining: 1h 3m Click To Buy Now Bid now |
 McAfee Total Protection 2012 3 Users In Retail Box The Newest Version $13.95 Time Remaining: 10d 7h 4m Buy It Now for only: $13.95 Click To Buy Now |
QUICKEN HOME AND BUSINESS 2012 BRAND NEW FREE SHIPPING $36.00 (5 Bids) Time Remaining: 1h 20m Click To Buy Now Bid now |
|
Norton 360 60 V6 3 PCs 1 Year Retail All In One AntiVirus Internet Security $32.99 Time Remaining: 17d 19h 29m Buy It Now for only: $32.99 Click To Buy Now |
New Sealed Adobe Photoshop Elements 10Premiere Elements 10 Full Bundle Version $66.00 (13 Bids) Time Remaining: 1h 21m Click To Buy Now Bid now |
|
Norton AntiVirus 2012 Retail 1 PC 1 Year Symantec $15.99 Time Remaining: 19d 19h 7m Buy It Now for only: $15.99 Click To Buy Now |
 ADOBE WINDOWS CREATIVE SUITE 55 DESIGN STANDARD FULL VERSION FREE SHIPPING $255.00 (22 Bids) Time Remaining: 35m Click To Buy Now Bid now |
|
Norton 360 60 Retail BOX 3 PC 1 Year All In One AntiVirus Internet Security V6 $33.99 Time Remaining: 2d 18h 24m Buy It Now for only: $33.99 Click To Buy Now |
 Apple iWork 09 Retail Version V903 $19.99 (1 Bid) Time Remaining: 1h 14m Click To Buy Now Bid now |
|
Norton Internet Security 2012 Retail 1 User License 3 Activations w AntiVirus $22.99 Time Remaining: 29d 5h 4m Buy It Now for only: $22.99 Click To Buy Now |
 COREL PAINTSHOP PRO X4 ULTIMATE BRAND NEW RETAIL BOX SOFTWARE $23.50 (7 Bids) Time Remaining: 2h 26m Click To Buy Now Bid now |
|
New CorelDRAW Graphics Suite X5 Full Version $49.99 Time Remaining: 1d 14h 5m Buy It Now for only: $49.99 Click To Buy Now |
 Windows server 2008 standard retail box 5 Client Access Licences $192.49 (3 Bids) Time Remaining: 1h 26m Click To Buy Now Bid now |
 All N OneV10 Optimize Windows 7Vista XPRepairClone Hard Disk Reset Win Pass $9.00 Time Remaining: 1d 3h 22m Buy It Now for only: $9.00 Click To Buy Now |
 New Adobe Creative Suite 55 Web Premium Full Retail Factory Sealed for Mac OS $255.00 (2 Bids) Time Remaining: 1h 50m Click To Buy Now Bid now |
|
Intuit Quicken Home and Business 2011 Brand New No Box Sealed $18.99 Time Remaining: 1d 22h 48m Buy It Now for only: $18.99 Click To Buy Now |
FINAL CUT STUDIO 2 FINAL CUT PRO 6 COLOR MOTION 3 COMPRESSOR 3 ACADEMIC VERSION $169.99 (1 Bid) Time Remaining: 4h 32m Click To Buy Now Bid now |
|
Norton 360 Version 5 50 All In One RETAIL 3 PCs $32.50 Time Remaining: 18d 13h 36m Buy It Now for only: $32.50 Click To Buy Now |
 NERO 11 MULTIMEDIA SOFTWARE BRAND NEW SEALED RETAIL BOX $29.00 (8 Bids) Time Remaining: 2h 26m Click To Buy Now Bid now |
