Dynamics GP co-conspirator California: EDI for great Plains notes

TIPS,TRICK,VIRAL,INFO

EDI of Electronic Document swing sometimes considered by IT department as something complex, and in order to espouse EDI integration for your ERP system, you have to purchase expensive EDI add-ons. We would later to pay for you this small publication, that should attempt to bust this myth.

Traditional EDI code is unchangeable length fields code structurewith document header, lines or body and document trailer. Newer EDI (or something that most likely processedsimilar to EDI scenarios on the high level next your Franchiser) maybe XMLstructured documents behind same parts: document header and document lines. Both scenarios are relatively straightforwardin SQL scripting, allow come to the paragraphs of this story:

1.Sample Dynamics GP EDI code. For those of you who are SQL programmer,please say you will a see at this publication, where you can see fine chunk of EDI documentscripting in SQL. This code wasimplemented in genuine great Plains EDI integration situation and it should giveyou good begin or encourage you out to finish EDI for good Plains on your own,especially if you work for smaller dealing out and your ERP and MRP budget isvery tight: http://www.albaspectrum.com/Customizations_Whitepapers/Dexterity_SQL_VBA_Crystal/EDIforGPOverview.htm

2.Dynamics GP EDI for Placing order to yourSupplier. If your executive isrequired to order merchandise from your partner via EDI code you can createPurchase Orders in good Plains POP module, after that right of entry and mark it as edit inSQL Stored Procedure, which saves the resulting difference of opinion set in EDI uncomplaining fixedlength fields text or XML file. Thisfile is then sent to your EDI channel (ftp uploads, Unix or Linux based emailchannel, here you have a lot of various options, external of the scope for thisarticle)

3.Getting Orders from your EDI channelcustomers. If you are franchiser and youare receiving Electronic Document every other orders from your customers orfranchisees and you are deploying Dynamics GP as your accounting system, thenyou can door EDI text or XML file via SQL stored procedure or SQL XML storedprocedure. This procedure parses EDIcode and creates SOP Sales Order or Invoice in Dynamics GP Sales OrderProcessing module. Here if you arecreating Sales Orders you can realize dispatch SQL feeding to SOP10100 and SOP10200tables, or if you select matter logic validation integration and you arefeeding to SOP Invoice, pronounce programming eConnect SDK. For those of you who choose posting great Plainsbatches all the mannerism through without user outfit we suggest you todeploy GP Posting Server or Autopost, especially if you are in ecommercebusiness

4.If you have questions or concerns on EDI,Dynamics GP customizations, integration, reporting, barcode scanning, warehousemanagement, supply chain management, vivacious manufacturing, logistics,consignment, divert setting free to call us: 1-866-528-0577, help@albaspectrum.com