Dynamics GP accomplice California: EDI for good Plains notes

TIPS,TRICK,VIRAL,INFO

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

Traditional EDI code is resolved length fields code structurewith document header, lines or body and document trailer. Newer EDI (or something that maybe processedsimilar to EDI scenarios on the tall level gone your Franchiser) maybe XMLstructured documents afterward thesame parts: document header and document lines. Both scenarios are relatively straightforwardin SQL scripting, allow arrive to the paragraphs of this story:

1.Sample Dynamics GP EDI code. For those of you who are SQL programmer,please undertake a look at this publication, where you can see good chunk of EDI documentscripting in SQL. This code wasimplemented in genuine great Plains EDI integration matter and it should giveyou fine start or back you out to finish EDI for great Plains on your own,especially if you conduct yourself for smaller paperwork 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 meting out isrequired to order merchandise from your accomplice via EDI code you can createPurchase Orders in good Plains POP module, next door and mark it as entrance inSQL Stored Procedure, which saves the resulting dispute set in EDI patient fixedlength fields text or XML file. Thisfile is subsequently sent to your EDI channel (ftp uploads, Unix or Linux based emailchannel, here you have a lot of various options, uncovered of the scope for thisarticle)

3.Getting Orders from your EDI channelcustomers. If you are franchiser and youare receiving Electronic Document rotate orders from your customers orfranchisees and you are deploying Dynamics GP as your accounting system, thenyou can approach 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 pull off concentrate on SQL feeding to SOP10100 and SOP10200tables, or if you prefer matter logic validation integration and you arefeeding to SOP Invoice, declare programming eConnect SDK. For those of you who pick posting great Plainsbatches every the showing off through without addict action 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, well-ventilated manufacturing, logistics,consignment, charm vibes forgive to call us: 1-866-528-0577, help@albaspectrum.com