EDI of Electronic Document exchange sometimes considered by IT department as something complex, and in order to implement EDI integration for your ERP system, you have to buy expensive EDI add-ons. We would bearing in mind to provide you this little publication, that should try to bust this myth.
Traditional EDI code is unmodified length fields code structurewith document header, lines or body and document trailer. Newer EDI (or something that most likely processedsimilar to EDI scenarios upon the high level gone your Franchiser) most likely XMLstructured documents considering similar 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 say you will a see at this publication, where you can see fine chunk of EDI documentscripting in SQL. This code wasimplemented in real good Plains EDI integration concern and it should giveyou good begin or put up to you out to finish EDI for great Plains on your own,especially if you performance for smaller dispensation 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 direction isrequired to order merchandise from your accomplice via EDI code you can createPurchase Orders in great Plains POP module, later retrieve and mark it as admittance inSQL Stored Procedure, which saves the resulting quarrel set in EDI accommodating fixedlength fields text or XML file. Thisfile is next 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 alternating 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 get concentrate on SQL feeding to SOP10100 and SOP10200tables, or if you select issue logic validation integration and you arefeeding to SOP Invoice, rule programming eConnect SDK. For those of you who pick posting good Plainsbatches all the quirk through without addict bureau we recommend you todeploy GP Posting Server or Autopost, especially if you are in ecommercebusiness
4.If you have questions or concerns upon EDI,Dynamics GP customizations, integration, reporting, barcode scanning, warehousemanagement, supply chain management, well-ventilated manufacturing, logistics,consignment, make laugh mood free to call us: 1-866-528-0577, help@albaspectrum.com
No comments:
Post a Comment