| Microsoft Dynamics GP is robust Corporate ERP | | | | codes) |
| platform, which is ready for integrations, including | | | | 3. Barcoding in Consignment. Consignment is when |
| barcode scanners data upload, custom EDI, Logistics | | | | you do not own the merchandize, physically stored in |
| and Supply Chain Management, Consignment - often | | | | your inventory sites, however you typically need to |
| these ERP routines are referred as Distribution. The | | | | see the quantities of items under consignment |
| term barcoding might be also generalized, meaning | | | | contract (to be able to reorder items, based on |
| generic Retail, Warehouse Management, Shipping and | | | | expected future Sales Orders). Consignment itself is |
| Receiving, Picking and Packing automation. In this | | | | typically Accounting procedure, and barcode scanning |
| small publication we are concentrating on Distribution | | | | for consignment may require custom business logic |
| and Barcoding topics for Microsoft Dynamics GP, | | | | 4. Barcoding in Inventory transfers and cycle count. |
| formerly also referred as Great Plains Dynamics and | | | | In Dynamics GP both: inventory site to site transfer |
| eEnterprise | | | | and cycle count are based on inventory transactions |
| 1. Barcoding in Shipping. Shipping is often associated | | | | (adjustment and transfer). In both cases barcode |
| with Customer Sales Order fulfillment. In Dynamics | | | | scanner upload should be altering inventory |
| GP this logic is in Sales Transaction Entry screen, | | | | transaction screen business logic |
| where you need to disable automatic fulfillment for | | | | 5. Barcoding in Retail integrations. Dynamics GP has |
| the specific warehouse management handled order | | | | native and custom integrations to Microsoft RMS, as |
| type and do manual allocation by order line. | | | | well as to such non-Microsoft POS applications as |
| Allocation is trigger for Order to be fulfilled (or ready | | | | Counterpoint. We saw multiple requests from MS |
| for being to the customer). Integration works this | | | | RMS customers, where Great Plains is their ERP |
| way - warehouse worker scans items to be picked | | | | application - they wanted to control Receiving in |
| and packed in real time or batch mode. Barcode | | | | Dynamics GP (inventory quantities, barcode label |
| scanner uploads fulfilled lines info to GP, where | | | | printing, store to store merchandise transfer) |
| custom logic (often programmed in Great Plains | | | | 6. Barcoding in light assembly. If you are happy |
| Dexterity) reads Barcoding scanner data flow and | | | | with Microsoft Dynamics GP Bill of Materials module |
| applies fulfillment logic to specific line of the Sales | | | | functionality (and do not want or need to implement |
| Order | | | | full suite of Dynamics GP Manufacturing modules), |
| 2. Barcoding in Receiving. It is just opposite to | | | | barcoding and scanner upload could be associated |
| Shipping, where you receive merchandise or parts | | | | with BOM transaction screen |
| from your suppliers. Normally it is associated with | | | | 7. Custom Programming for Microsoft Dynamics GP |
| GP Purchase Order Processing module, where you | | | | Barcoding. The preferred way in our opinion is |
| can receive against open Purchase Order lines. | | | | "solution", where GP Barcoding partner with existing |
| Barcode scanning and integration logic is similar to | | | | proven codes offers you to tune existing logic to |
| paragraph #1. If you are mid-size or large company, | | | | your business processes. From the stand point of |
| you may have additional needs to place Purchase | | | | technology Microsoft Dexterity is one of the most |
| Order to your suppliers via EDI channel. EDI | | | | advanced choices, next would be (in our opinion) |
| purchase orders could be auto generated from Sales | | | | eConnect SDK. Reasonable tool for simple |
| Orders (with checking inventory reserves or minimum | | | | integration is Dynamics GP Integration Manager |
| replenishment levels). For EDI you can purchase | | | | (especially with Advanced ODBC queries, based on |
| Dynamics GP EDI add-on, or simply program EDI | | | | SQL Views, including cross platform: Oracle, MS |
| compliant export (typically into EDI formatted text | | | | Access, MySQL/PHP, Ingress, DBII, Pervasive SQL, |
| with header, lines and EDI trailer) via precisely | | | | Ctree, Excel) |
| formatted SQL Select statement (we published | | | | 8. How to get help? |
| numerous articles where we give you sample SQL | | | | |