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