Microsoft Dynamics GP SCM Add-Ons: Automatic Sales Order Allocation

typically programmed in Great Plains Dexterity.  Popular custom logic is also when you are allocating Dynamics GP Sales Order or Invoice lines based on EDI code from your customers.  Customization works with native Dynamics GP Supply Chain Management set of modules: Sales Order Processing, Inventory Control, Purchase Order Processing.  We recommend this small publication for introduction:
1. Allocation in Sales Document.  Sales Invoice, Order, Return, Back Order or Fulfillment Order have two components: document header (table SOP10100 where customer info, invoice number, shipping address, etc. go) and document lines (table SOP10200 where you have inventory item info, warehouse, etc.).  If you decide to do order fulfillment in separate process, you have control in picking and packing - typically most of the Warehouse Management System deploy Barcoding for separate lines allocation.  If you need to introduce custom formula, you may change item quantities, based on the expected future order volume.  This is where Dexterity allows you to change QTY field in SOP10200 and call all the associated internal SOP logic to update Order Line and Order Header records
2. EDI or Electronic Document Interchange in Order Allocation.  EDI code typically comes in precisely structured text file format with document header, lines and trailer.  As Dynamics GP is MS SQL Server based ERP application, you can deploy pretty simple connection from MS SQL Server to the text file via ODBC and do precise SQL Select statement to read and parse elements of the Sales Order or Invoice, including Customer ID, Item Numbers, Quantities.  You may do all the job in EDI scenario in SQL Stored Procedure (filling SOP10100, SOP10200 and associated tables), however better results could be achieved in Dynamics GP Integration Manager (where you have to deploy Advanced ODBC data query for flexibility), or if you are Microsoft Visual Studio C# or VB developer - then your preferred tool might be eConnect (it has methods to creating SOP documents and add lines), or even Dexterity, if your business logic requires too much customization
3. Warehouse Management System for Picking and Packing.  As we already mentioned WMS deploys barcode scanning, RFID technologies to upload scanned data directly to Dynamics GP.  In picking and packing it translates into SOP Order Line allocation, based on Item Number scanned and then followed by item quantity and sometimes lot or serial number.  WMS user interface runs on the LCD screen of the barcode scanner
4. How to get help?  Please call us 1-866-528-0577, 1-630-961-5918 or email us help@albaspectrum.com  We work with nationwide clientele.  International clients welcome.  Our WMS, Barcoding, Logistics and Distributions consultants speak English, Chinese, Spanish, Portuguese, Russian, Filipino, Arabic.  In the countries, where Dynamics GP is not localized we would recommend Dynamics AX for large subsidiaries, and SAP Business One for smaller facilities