| If you are looking for integrated solution for your | | | | tools as Crystal Reports, SSRS, or Dynamics GP |
| midsize retail stores chain, consider combination of | | | | ReportWriter for Item label printing |
| Microsoft Dynamics GP (formerly known as Great | | | | |
| Plains Dynamics) and Microsoft Retail Management | | | | 5. Barcoding in Supply Chain Management. |
| System (often referred as Microsoft RMS). | | | | Dynamics GP ERP, MRP, SCM logic is too rich to |
| However, often Retail and Point Of Sale systems | | | | expect one of the existing GP Add-ons (custom |
| integration to accounting back end may have unique | | | | extensions, programmed and supported by one of the |
| requirements (such as lot and serial numbering as part | | | | Dynamics GP ISV partners) to do the job |
| of item barcode). If your POS system is already in | | | | out-of-the-box. We name our approach "solution", |
| production, we could reasonably integrate your existing | | | | where we offer proven programming code from our |
| Point of Sale to Dynamics GP via set of proven SQL | | | | products to be tuned for your specific GP barcoding |
| Stored Procedures. If you are in tiny business, you | | | | integration interface |
| may consider use barcode scanner as replacement to | | | | |
| POS, especially in international small business retail | | | | 6. Out-of-the-box Microsoft Dynamics GP |
| business, however in USA we recommend you to | | | | to MS RMS integration. You should be able to deploy |
| deploy POS (Counterpoint, for example). This article | | | | this product with some support from our technical |
| may look a bit technical, as we are writing for POS | | | | consultants and technicians in the case when you |
| Programmers and IT specialists: | | | | have straight forward integration rules from RMS |
| | | | | Headquarters or Store Operation DB to Dynamics GP |
| 1. Microsoft RMS as POS, Warehouse | | | | |
| Management and Centralized Supply Chain | | | | 7. MS RMS integration options via Dynamics |
| Management. RMS allows you to deploy POS, | | | | GP eConnect. For larger retail chain we recommend |
| Warehouse Management (WM is for one specific | | | | to consider Great Plains eConnect programming, |
| store, but it could be used for the whole organization if | | | | especially when your Retail prices are in constant |
| you have the only store as small or midsize shop), and | | | | change: buy one get one free, each item is 10 cents, if |
| RMS Headquarters (it consolidates Stores sales into | | | | you buy this you can take that item free. eConnect |
| central DB, similar in structure to Store Operations DB) | | | | allows you to control your integration to GP, and do |
| | | | | not depend on often simplified business logic of existing |
| 2. MS RMS integration points to Dynamics | | | | Great Plains Add-Ons. Please be sure that you are |
| GP. If you are multi stores retail business and you | | | | familiar with XML parameters and coding |
| are executing your Supply Chain Management via MS | | | | |
| RMS Headquarters, naturally integration should be | | | | 8. eCommerce Shopping Card Integration to |
| implemented on the Headquarters DB level to your | | | | GP. We have special project Order Connector, |
| Dynamics GP companies. Schemas might be Store | | | | which allows you to integrate PHP, Linux or custom |
| to Dedicated GP company, or Multiple Stores to One | | | | ecommerce application customers and invoices to |
| GP Company, or mixed, when one set of stores is | | | | Dynamics GP Sales Order Processing Module |
| consolidated into One GP company and another set | | | | |
| into second GP company, etc. If you do not sell to | | | | 9. GP Retail integration internationally. We |
| the account (like in retail store for the fitness club), | | | | should be able to help you if your business is located in |
| please consider to create Walk-In Customer in GP RM | | | | USA, Canada, Latin America, Brazil, Pacific, Philippines, |
| module | | | | Singapore, Australia, New Zealand. If you are in |
| | | | | Europe: UK, Poland, Germany, Spain, France, Portugal, |
| 3. POS Transaction in Dynamics GP. | | | | Russia, Ukraine, Lithuania, Latvia, Estonia - we can help |
| There are two options: to move Point Of Sale | | | | you conceptually, or via remote support, or if you |
| transaction as Sales Order Processing document (in | | | | agree to pay our travel cost from USA. The same |
| Dynamics GP SOP module), or consolidate it as single | | | | applies to South African based businesses. |
| line invoice in GP Receivable Management module | | | | Dynamics GP is localize in most of the English |
| | | | | Speaking Countries, plus in Latam: Argentina, Uruguay, |
| 4. Purchasing and Barcode Label Printing in | | | | Paraguay, Chile, Venezuela, Colombia, Costa Rica, |
| Dynamics GP. Some retailers prefer to control | | | | Honduras, Nicaragua, Panama, Guatemala, Dominican |
| merchandise replenishment in their ERP system, in our | | | | Republic, Puerto Rico, Peru, Bolivia, Ecuador, Paraguay, |
| case Great Plains Dynamics. In GP you can deploy | | | | Mexico |
| sophisticated methods for generating barcode for your | | | | |
| newly received items and initiate this process on POP | | | | 10. How to get help? |
| Purchase Receipts. Consider such popular reporting | | | | |