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 8h 13m 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: 32m Click To Buy Now Bid now |
 Intuit Quicken Home and Business 2011 Brand New No Box Sealed $18.99 Time Remaining: 1d 21h 59m Buy It Now for only: $18.99 Click To Buy Now |
 Microsoft Office Mac 2011 Home Business $61.00 (5 Bids) Time Remaining: 1h 31m Click To Buy Now Bid now |
 NEW QuickBooks Pro 2012 Accounting Software Sealed Retail Box Full Version $129.95 Time Remaining: 21d 18h 59m Buy It Now for only: $129.95 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: 3h 44m Click To Buy Now Bid now |
 New CorelDRAW Graphics Suite X5 Full Version $49.99 Time Remaining: 1d 13h 17m Buy It Now for only: $49.99 Click To Buy Now |
 Norton Internet Security 2012 Retail 1 User License 3 Activations w AntiVirus $16.50 (9 Bids) Time Remaining: 1h 11m 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 18h 41m Buy It Now for only: $32.99 Click To Buy Now |
 New Sealed Adobe Photoshop Elements 10Premiere Elements 10 Full Bundle Version $73.00 (17 Bids) Time Remaining: 33m Click To Buy Now Bid now |
 Norton AntiVirus 2012 Retail 1 PC 1 Year Symantec $15.99 Time Remaining: 19d 18h 19m Buy It Now for only: $15.99 Click To Buy Now |
 MICROSOFT PROJECT 2010 SOFTWARE TRAINING TUTORIALS 17 HOURS $46.97 Time Remaining: 1h 17m 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 17h 36m Buy It Now for only: $33.99 Click To Buy Now |
 MS Office Professional 2010 $149.99 Time Remaining: 1h 21m Click To Buy Now Bid now |
 Norton Internet Security 2012 Retail 1 User License 3 Activations w AntiVirus $22.99 Time Remaining: 29d 4h 15m Buy It Now for only: $22.99 Click To Buy Now |
 Speak Learn Tagalog Vista NEW FACTORY SEALED SOFTWARE $8.69 Time Remaining: 1h 11m Click To Buy Now Bid now |
 Norton 360 Version 5 50 All In One RETAIL 3 PCs $32.50 Time Remaining: 18d 12h 48m Buy It Now for only: $32.50 Click To Buy Now |
 Madeline European Adventures NEW FACTORY SEALED SOFTWARE $8.97 (1 Bid) Time Remaining: 1h 31m Click To Buy Now Bid now |
 Intuit Quicken Premier 2011 Brand New No Box Sealed $14.99 Time Remaining: 3d 9h 53m Buy It Now for only: $14.99 Click To Buy Now |
 2011 MICROSOFT OFFICE MAC HOME STUDENT SOFTWARE BRAND NEW SEALED RETAIL BOX $61.00 (19 Bids) Time Remaining: 1h 39m Click To Buy Now Bid now |
 Kaspersky Internet Security 2012 Retail Box 3 PC 1 Year $23.99 Time Remaining: 17d 16h 33m Buy It Now for only: $23.99 Click To Buy Now |
 macromedia dreamweaver mx training from the source with CD $4.99 Time Remaining: 39m Click To Buy Now Bid now |
 Microsoft Expression Web 3 Academic Box $29.99 Time Remaining: 28d 21m Buy It Now for only: $29.99 Click To Buy Now |
 Microsoft Office 97 Small Business Edition on CD $13.05 (2 Bids) Time Remaining: 1h 9m Click To Buy Now Bid now |
 QUICKEN HOME AND BUSINESS 2012 BRNAD NEW FULL VERSION $39.88 Time Remaining: 17d 23h 38m Buy It Now for only: $39.88 Click To Buy Now |
 Digital Backdrops Photography Backgrounds Photoshop Templates Photo Textures v $9.95 Time Remaining: 34m Click To Buy Now Bid now |
 Intuit Quicken Rental Propery Manager 2011 Brand New No Box Sealed $22.99 Time Remaining: 4d 11h 46m Buy It Now for only: $22.99 Click To Buy Now |
 LAPTOP NOTEBOOK HARD DRIVE HD CLONE COPY IMAGE USB SATA $0.98 Time Remaining: 46m Buy It Now for only: $9.95 Click To Buy Now Bid now |
 Intuit QuickBooks Pro 2012 New Sealed Retail Box Ships Fast $127.98 Time Remaining: 10d 21h 14m Buy It Now for only: $127.98 Click To Buy Now |
 Arthurs 1ST GRADE +KID PIX 4 DELUXE Bundle XP Vista MAC $10.86 Time Remaining: 32m Click To Buy Now Bid now |
 NERO 11 PLATINIUM $49.00 Time Remaining: 6d 3h 17m Buy It Now for only: $49.00 Click To Buy Now |
 Windows XP Pro Retail Full With Key $40.00 (1 Bid) Time Remaining: 1h 27m Click To Buy Now Bid now |
|
NEW QuickBooks Pro 2012 Accounting Software Sealed Retail Box Full Version $129.95 Time Remaining: 21d 18h 59m Buy It Now for only: $129.95 Click To Buy Now |
QUICKEN HOME AND BUSINESS 2012 BRAND NEW FREE SHIPPING $36.00 (5 Bids) Time Remaining: 32m Click To Buy Now Bid now |
|
Intuit Quicken Deluxe 2011 Brand New No Box Sealed $11.99 Time Remaining: 4d 8h 13m Buy It Now for only: $11.99 Click To Buy Now |
 COREL PAINTSHOP PRO X4 ULTIMATE BRAND NEW RETAIL BOX SOFTWARE $23.50 (7 Bids) Time Remaining: 1h 38m Click To Buy Now Bid now |
 Norton Internet Security 2012 CD 1 User 1 Yr Factory Fresh CD $16.99 Time Remaining: 20d 30m Buy It Now for only: $16.99 Click To Buy Now |
 NERO 11 MULTIMEDIA SOFTWARE BRAND NEW SEALED RETAIL BOX $29.00 (8 Bids) Time Remaining: 1h 38m Click To Buy Now Bid now |
 NEW RETAIL McAfee Total Protection 2012 3 Users LATEST VERSION In Sealed Box $13.25 Time Remaining: 4d 19h 16m Buy It Now for only: $13.25 Click To Buy Now |
 COREL PHOTO VIDEO X4 ULTIMATE BUNDLE BRAND NEW RETAIL BOX SOFTWARE $24.50 (13 Bids) Time Remaining: 1h 37m Click To Buy Now Bid now |
 Norton Internet Security 2012 1 User License for 3 PCS Installs Antivirus $21.97 Time Remaining: 17d 11h Buy It Now for only: $21.97 Click To Buy Now |
 Windows Vista Ultimate 64bit Full Genuine With Key $48.00 (7 Bids) Time Remaining: 1h 17m Click To Buy Now Bid now |
 McAfee Total Protection 2012 3 Users In Retail Box The Newest Version $13.95 Time Remaining: 10d 6h 16m Buy It Now for only: $13.95 Click To Buy Now |
New Sealed Adobe Photoshop Elements 10Premiere Elements 10 Full Bundle Version $73.00 (17 Bids) Time Remaining: 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 18h 41m Buy It Now for only: $32.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: 3h 44m Click To Buy Now Bid now |
|
Norton AntiVirus 2012 Retail 1 PC 1 Year Symantec $15.99 Time Remaining: 19d 18h 19m Buy It Now for only: $15.99 Click To Buy Now |
 Windows server 2008 standard retail box 5 Client Access Licences $192.49 (3 Bids) Time Remaining: 38m 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 17h 36m Buy It Now for only: $33.99 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 2m Click To Buy Now Bid now |
|
Norton Internet Security 2012 Retail 1 User License 3 Activations w AntiVirus $22.99 Time Remaining: 29d 4h 15m Buy It Now for only: $22.99 Click To Buy Now |
 ADOBE PAGEMAKER for MAC 65 + 70 upgrade RETAIL install w manuals ++ MacIntosh $16.50 (5 Bids) Time Remaining: 1h 58m Click To Buy Now Bid now |
|
New CorelDRAW Graphics Suite X5 Full Version $49.99 Time Remaining: 1d 13h 17m Buy It Now for only: $49.99 Click To Buy Now |
 Adobe Creative Suite 3 Design Standard Mac $100.00 (1 Bid) Time Remaining: 1h 32m Click To Buy Now Bid now |
 All N OneV10 Optimize Windows 7Vista XPRepairClone Hard Disk Reset Win Pass $9.00 Time Remaining: 1d 2h 34m Buy It Now for only: $9.00 Click To Buy Now |
 Adobe Creative Suite 4 Production Premium CS4 for Windows Upgrade Retail $78.77 (8 Bids) Time Remaining: 2h 48m Click To Buy Now Bid now |
|
Intuit Quicken Home and Business 2011 Brand New No Box Sealed $18.99 Time Remaining: 1d 21h 59m Buy It Now for only: $18.99 Click To Buy Now |
Microsoft Office Mac 2011 Home Business $61.00 (5 Bids) Time Remaining: 1h 31m Click To Buy Now Bid now |
|
Norton 360 Version 5 50 All In One RETAIL 3 PCs $32.50 Time Remaining: 18d 12h 48m Buy It Now for only: $32.50 Click To Buy Now |
Norton Internet Security 2012 Retail 1 User License 3 Activations w AntiVirus $16.50 (9 Bids) Time Remaining: 1h 11m Click To Buy Now Bid now |
