Breaking Through Warehouse Management System for Microsoft Dynamics GP

By: Andrew Karasev

It is probably fair statement that Barcoding and RFID technology is very mature and established in USA and on the international ERP market.  However, still there are obstacles and unsuccessful implementations in Supply Chain Management, Consignment, Picking and Packing.  Talking to numerous WMS and SCM customers, we find the trend - the problem is not really in WMS itself, it works.  The problem is in rather Warehouse Management System integration implementation.  If you simply try to implement add-on to your Corporate ERP, enabling typical WMS features directly in the ERP application (all you need to do in most of the cases is to enable Barcode scanner real time or batch mode integration) - you may likely expect better chance.  Microsoft Dynamics GP ERP was also known in the past as Great Plains Dynamics and eEnterprise - if this is your ERP system, then we recommend you this document:

1. Barcode Scanner resided WMS client application.  When you scan on the warehouse floor, either doing merchandize receiving or sales order fulfillment (picking and packing) - barcode scanner talk to the WMS server and uploads scanned data directly to Microsoft Dynamics GP Distributions modules: Sales Order Processing, Purchase Order Processing, Inventory Control

2. Technology behind.  Traditionally we recommend Order Connecter layer of SQL Stored Procedures.  WMS server talks to Dynamics GP SQL database via ODBC connection, uploading data in real time or if required in batch mode.  Technology is very simple and the goal was to enable simple programming to be efficient on the top of the Barcode scanner operating system and LCD graphics

3. Convergence 2010.  We saw record level of the interest to the SCM and WMS applications, especially working directly out of Great Plains DB (not external stand alone WMS).  As we are catching up with Logistics ERP market, we invite you to visit our booth on Convergence 2011

4. International aspect.  Microsoft Dynamics GP is very popular in Arabic speaking countries, as well as in Spanish speaking Latin America.  We are well positioned to travel internationally and familiar with Corporate ERP systems markets in Saudi Arabia, Egypt, Russia, Brazil, China, Poland, Latvia, Lithuania, Mexico.  Our Corporate ERP and WMS consultants speak English, Arabic, Spanish, Portuguese, Chinese, Russian, Filipino.  In the countries, where Dynamics GP is not localized we recommend and implement SAP Business One or Dynamics AX

5. eCommerce integration perspective.  Electronic Commerce module for Microsoft Dynamics GP is compatible with Warehouse Management Extensions and we had special events to demo eCommerce B2B and B2C on Convergence 2010

6. If you are technology consultant.  Well this publication could look too simple and advertising.  If this is your feeling we invite you to visit our web site and read profound whitepapers, blogs and articles

About the Author

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land; in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego

(ArticlesBase SC #2296063)

Article Source: http://www.articlesbase.com/ - Breaking Through Warehouse Management System for Microsoft Dynamics GP

Related Articles:


ePOS and Shopping Cart Solution for Microsoft Retail Management System





Advanced Management Model of Microsoft Dynamics GP 100

Microsoft Dynamics GP 10.0 offers business ready licensing with tiered solution packages, so that customers can choose the product that best fits their needs. Previous versions of the ERP software offered the piece meal method of picking modules which were priced per user...



Dynamics GP Inventory AddOns Barcode Warehouse Management Notes

Inventory automation is often complex, as here you may need special unique requirements, but it is usually based on Barcode scanners and feeding scanned information into Great Plains Sales Order Processing, Purchasing and Inventory Control modules. Custom logic often makes existing Dynamics ISV out-of-the-box extensions difficult to implement as they may need to be highly redesigned. In this small publication we are describing the approach, when you tell us how and where in Dynamics GP barcoding should be integrated and we apply existing code sets with reasonably minor tune up and redeployment in your Microsoft Dynamics GP implementation:Inventory automation is often complex, as here you may need special unique requirements, but it is usually based on Barcode scanners and feeding scanned information into Great Plains Sales Order Processing, Purchasing and Inventory Control modules...



Dynamics GP Warehouse Management and Barcode Solution Notes

Supply Chain Management automation, including Warehouse Management, Inventory Control with Batch Mode or Real Time Barcoding, Consignment, Shipping and Receiving, Trucks Scheduling, Rentals and Warranty Contracts €“ these business processes are often too unique for hoping to get all the standard functionality through Dynamics GP ISV channel Add-Ons. Our approach is more flexible €“ we have ready for redeployment Great Plains Dexterity, SQL and eConnect custom codes and modules and we offer Solution approach, where we have experienced Dynamics GP Programmers in our Software Development Factory, ready to tune the codes and test them in your Dynamics GP Test environment. Let€™s review the approach and the technologies:Supply Chain Management automation, including Warehouse Management, Inventory Control with Batch Mode or Real Time Barcoding, Consignment, Shipping and Receiving, Trucks Scheduling, Rentals and Warranty Contracts €“ these business processes are often too unique for hoping to get all the standard functionality through Dynamics GP ISV channel Add-Ons...



Dynamics GP Barcode and Warehouse Management Solutions Notes

Companies, involved in consignment, warehouse and supply chain management, often have unique business processes and special requirements to their ERP and MRP systems. In these scenarios, it is easier to redeploy and retune existing codes to fit unique requirements (we name our ready for deployment codes Solutions), versus the attempt to customize out-of-shelf WMS and Barcoding Great Plains Add-on. In this small publication we would like to share with you existing code base, so you could decide if the €Solutions€ approach is feasible in your case:Companies, involved in consignment, warehouse and supply chain management, often have unique business processes and special requirements to their ERP and MRP systems...



How to integrate web applications through Microsoft Dynamics gp

Microsoft Dynamics GP is a mid-market business accounting software package that runs on top of a Microsoft SQL Server database. It is a part of the Microsoft Business Solutions family. The product was originally made by Great Plains Software, an independent company located in Fargo, North Dakota, which was founded by Doug Burgum...



Microsoft Dynamics GP Great Plains East European Options overview for consultant

Great Plains Software Dynamics and eEnterprise were popular in Europe, prior to Microsoft acquisition of Great Plains Software, and since then Microsoft acquired also such ERP as Navision with strong European market presence. In those days of Navision purchase, Microsoft Business Solutions made a decision to market Navision, or current name Dynamics NAV in Europe and sort of deemphasize Dynamics GP Great Plains. However Great Plains has pretty strong presence in Poland and UK, and taking into consideration European businesses interconnection, we could expect Polish or British companies would have a need to connect their Eastern European branches to their Great Plains ERP and MRP databases and reporting tools, such as FRx, Crystal Reports, SRS...



Reporting for Microsoft Dynamics GP SL NAV CRM notes

Reporting tool selection may seem to be very important, and in fact you have to distinguish between so-called Financial Reporting: Consolidated or Single company Balance Sheet, Profit and Loss, Statement of Cash Flow €“ these are typically done in FRx Financial Reporting, please see our additional publications on FRx. If your Microsoft Dynamics reporting requirements go beyond Financial Statements and you cannot find out-of-the-box report, then you should think about typical managerial reporting tool: Crystal Reports, Microsoft SQL Server Reporting Services, Microsoft Access Reporting, MS Excel or even MS SQL Server Query, saved to the text file and opened in Excel. Let€™s come through highlights:Reporting tool selection may seem to be very important, and in fact you have to distinguish between so-called Financial Reporting: Consolidated or Single company Balance Sheet, Profit and Loss, Statement of Cash Flow €“ these are typically done in FRx Financial Reporting, please see our additional publications on FRx...



Supply Chain Management for Great Plains Dynamics GP notes

Microsoft Dynamics GP ERP and MRP is robust and flexible platform for barcoding, consignment, warehouse management, picking up ecommerce. When you are at the point when Dynamics GP does your ERP, MRP and Accounting business processes job, please feel free to call our office for additional Dynamics GP modification details. For very large USA corporate business with SCM requirements, please feel free to call our office directly as you do not really expect you to get free help online over the internet...



Microsoft Dynamics GP Autoposting Server Batch Posting extension for eCommerce

If you are responsible for Great Plains integration with your e-commerce web front and you want everything to automated up to the triggering order execution in your warehouse €“ this means you need to create customer invoice, get a payment, save it to the batch and post this batch right from your e-commerce application. If you are deploying eConnect SDK €“ you probably already realized that eConnect allows you to create so-called work transactions (Sales Order Processing Invoice or Order), save them into the batch, however posting is beyond of the eConnect scope and power. Alba Spectrum designed Autoposting server, which is Dexterity add-on for Dynamics GP Great Plains and it allows you to post all types of core GP batches automatically...

Most Recent News





More Related Articles


Great Plains Warehouse Management Dynamics GP Barcoding Solutions notes

Microsoft Dynamics GP ERP and MRP application is open platform for custom add-ons development, plus it has wide selection of Logistics, Transportation, Warehouse Management, Barcode Scanning (real time barcode scanners with wireless connection or barcodeing in batch mode), Consignment, Bill of Lading, Shipping industry Agent Settlement Report. These scenarios are popular in Dynamics GP Great Plains implementation and modifications. We would like to offer you Great Plains warehouse management integration highlightsMicrosoft Dynamics GP ERP and MRP application is open platform for custom add-ons development, plus it has wide selection of Logistics, Transportation, Warehouse Management, Barcode Scanning (real time barcode scanners with wireless connection or barcodeing in batch mode), Consignment, Bill of Lading, Shipping industry Agent Settlement Report...



Dynamics GP Supply Chain Management Notes

Microsoft Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise, has good selection of native modules: SOP, POP, Inventory Control, Purchase Configurator, plus you could find various Add-ons or custom modules, supported by Dynamics GP ISV partners. This publication is review for technical specialist and it is intended to give you technology highlight and how to automate SCM in your organization:Microsoft Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise, has good selection of native modules: SOP, POP, Inventory Control, Purchase Configurator, plus you could find various Add-ons or custom modules, supported by Dynamics GP ISV partners. This publication is review for technical specialist and it is intended to give you technology highlight and how to automate SCM in your organization:1...



An Employee Management System can make Difference for Your Business

Employees are the backbone of any organization, accomplishing the day-to-day functions as well as driving growth and new initiatives for a business. However, it should be considered that if they can yield benefits for a company, they can also incur losses if not managed properly. In order to put all HR related activities in line, companies have started exploring the benefits of HR employee management systems...



Corporate ERP for Midsize Company Dynamics GP or SAP Business One

When you outgrow small business accounting packages: Quickbooks, Peachtree or you name it, there is always a risk to make the next Corporate ERP pick to be in dissonance with your business processes, Accounting, MRP and other requirements. As you can expect, there is no universal Corporate ERP application, each vendor has advantages and disadvantages. In this small publication we will try to review selection criteria and make initial comparison of Microsoft Dynamics GP and SAP Business One; we will stick to core modules and will not be highlighting ISV add-ons, but you should be aware that both applications have great selection of third party ISV supported modules...



No Other Software skill is required for Content Management System

The total control through a single source over the web sites content, design and the structure is allowed by the application called the Content Management System or CMS. With the help of this application (Content Management System) content of the web sites can be easily manipulated and updated through single source instead of multiple sources. One can easily alter, add or delete the material of the content when ever required...



Corporate ERP for Multinational Firm Microsoft Dynamics and SAP Business One

Globalization trend is real and many mid-size manufacturing organizations went into international business field. While you may get good advantage on international job market and outsource production to such countries as Brazil, you will have to be prepared to more complex accounting. In this small publication we would like to walk you through multinational firm corporate ERP selection and implementation phases, where we are using real case studies from our international ERP consulting practice:Globalization trend is real and many mid-size manufacturing organizations went into international business field...



What Businesses Should Look for in an Electronic Document Management System

In today€™s business world, electronic document management is a must. It is imperative to be able access all of your business information quickly through your computer. The days of large, growing businesses having rooms and rooms of paper files is over...



Planning For An Electronic Document Management System

In today’s fast-paced business world, more and more businesses are deciding to become paperless. ‘Becoming Paperless’ is basically the process of taking all of a company’s paper records and converting them into digital images, retrievable through the company’s network of computers and workstations. This allows the business to access the paper records in a fraction of the time it would take them to retrieve a paper file and prevents the employees from having to re-file the documents that they retrieve...



Microsoft Patch Management for Home Users

With easy access to Broadband and DSL the number of people using the Internet has skyrocket in recent years. Email, instant messaging and file sharing with other Internet users has also provided a platform for faster spreading of viruses, Trojans and Spyware. Being on the Internet without proper protection is like walking in the rain with no umbrella - you're gonna get wet no matter how fast you run...



Microsoft Dynamics GP a renovated Microsoft Business Solutions Great Plains ERP

Microsoft Business Solutions Great Plains is now renamed into Microsoft Dynamics GP, as well as Microsoft Navision into Microsoft Dynamics NAV, Microsoft Axapta into Microsoft Dynamics AX, Microsoft Solomon into Microsoft Dynamics SL and Microsoft CRM into Microsoft Dynamcis CRM. Of course Microsoft has the plan to select the most marketing attractive name for its ERP products, however the other side of the renaming may be in the plan to move Project Green forward. At the final phase of Project Green Microsoft might drop GP, NAV, AX, SL and CRM extensions and make final version name to be simply Microsoft Dynamics...