Microsoft Dynamics GP Custom WMS Extension Programming

WMS is typically barcode scanning driven application and it often integrates into Purchase Order Processing module (purchase receipts scanning and upload), Inventory Control (site-to-site inventory items transfer, cycle count with barcode scanners), Sales Order Execution (Order lines allocation in picking and packing or light assembly).  However, there are too many options and data entry screens in POP, SOP, Inventory Control modules (potentially open for barcode scanning integration), so it is too optimistic to expect WMS Add-ons for Microsoft Dynamics GP to be too flexible out of the box.  In this small publication we are trying to give you orientation session for WMS selection and modification:
1. WMS approaches in integration to Dynamics GP.  You may consider two approaches.  First is when WMS has its own independent database and business logic and it uploads data to ERP application every hour.  In this scenario you deploy Dynamics GP Integration Manager, eConnect programmed integration or SQL direct data push to GP.  Second approach is when WMS is programmed in Great Plains Dexterity and is completely integrated within GP company database, user interface and Great Plains security realm.  WMS providers, pursuing the first approach are trying to capitalize on the advanced WMS logic and then provide reasonable integration flexibility to your specific Corporate ERP system.  WMS vendors who are featuring the second way - those Dynamics GP ISV partners probably have more experience in Great Plains native business logic and processes, and they are more comfortable in deploying unique Dynamics GP technologies, such as Microsoft Dexterity, eConnect, sometimes Extender, or VBA with Modifier.  The rest of the publication will be the second approach oriented
2. Dexterity programming and WMS .  Dex gives you complete control over Great Plains database, user interface, transactions and batch posting.  Custom Dexterity forms are GP security model compliant and you can setup required security within GP security tasks, roles (Dynamics GP 10.0, 11.0 and newer versions) or GP access control to Windows, Tables (for Great Plains Dynamics GP 9.0, 8.0, 7.5 and earlier versions).  Why do I even need custom programming in Barcode scanner integration?  This question is very legitimate and popular, the reason is simple - Corporate ERP application screens typically have several editable, drop down list and radio button fields, where the user have to make her or his selection via intuitive human friendly interface.  Barcode scanner is just the replacement for keyboard entry for the editable field, the rest of the choices are not too friendly for barcode scanner -this is where custom logic is needed
3. Dexterity coded WMS modification.  We prefer the approach, when Warehouse Management System exists in the form of ready to be further modified codes and screens, as virtually all of the Distributions, Supply Chain Management, Logistics implementations are different
4. How to get further help?  Please feel free to call us: 1-866-528-0577, 1-630-961-5918 or email us help@albaspectrum.com  We are also comfortable to discuss WMS implementation for SAP Business One, where customized business logic could be programmed in SB1 SDK