| EDI of Electronic Document Interchange sometimes | | | | create Purchase Orders in Great Plains POP module, |
| considered by IT department as something complex, | | | | then read and mark it as read in SQL Stored |
| and in order to implement EDI integration for your ERP | | | | Procedure, which saves the resulting row set in EDI |
| system, you have to purchase expensive EDI add-ons. | | | | compliant fixed length fields text or XML file. This file |
| We would like to offer you this small publication, that | | | | is then sent to your EDI channel (ftp uploads, Unix or |
| should try to bust this myth. | | | | Linux based email channel, here you have a lot of |
| Traditional EDI code is fixed length fields code | | | | various options, outside of the scope for this article) |
| structure with document header, lines or body and | | | | |
| document trailer. Newer EDI (or something that | | | | 3. Getting Orders from your EDI channel |
| maybe processed similar to EDI scenarios on the high | | | | customers. If you are franchiser and you are |
| level with your Franchiser) maybe XML structured | | | | receiving Electronic Document Interchange orders from |
| documents with similar parts: document header and | | | | your customers or franchisees and you are deploying |
| document lines. Both scenarios are relatively | | | | Dynamics GP as your accounting system, then you |
| straightforward in SQL scripting, let come to the | | | | can read EDI text or XML file via SQL stored |
| paragraphs of this story: | | | | procedure or SQL XML stored procedure. This |
| | | | | procedure parses EDI code and creates SOP Sales |
| 1. Sample Dynamics GP EDI code. For | | | | Order or Invoice in Dynamics GP Sales Order |
| those of you who are SQL programmer, please take | | | | Processing module. Here if you are creating Sales |
| a look at this publication, where you can see good | | | | Orders you can do direct SQL feeding to SOP10100 |
| chunk of EDI document scripting in SQL. This code | | | | and SOP10200 tables, or if you prefer business logic |
| was implemented in real Great Plains EDI integration | | | | validation integration and you are feeding to SOP |
| situation and it should give you good start or help you | | | | Invoice, consider programming eConnect SDK. For |
| out to finish EDI for Great Plains on your own, | | | | those of you who prefer posting Great Plains batches |
| especially if you work for smaller organization and your | | | | all the way through without user intervention we |
| ERP and MRP budget is very tight: | | | | recommend you to deploy GP Posting Server or |
| | | | | Autopost, especially if you are in ecommerce business |
| 2. Dynamics GP EDI for Placing order to | | | | |
| your Supplier. If your organization is required to order | | | | 4. |
| merchandise from your partner via EDI code you can | | | | |