EDI of Electronic Document swap sometimes considered by IT department as something complex, and in order to take on board EDI integration for your ERP system, you have to buy costly EDI add-ons. We would afterward to provide you this small publication, that should attempt to bust this myth.
Traditional EDI code is utter length fields code structurewith document header, lines or body and document trailer. Newer EDI (or something that maybe processedsimilar to EDI scenarios upon the high level like your Franchiser) maybe XMLstructured documents considering same 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 recognize a see at this publication, where you can see good chunk of EDI documentscripting in SQL. This code wasimplemented in genuine good Plains EDI integration event and it should giveyou fine begin or back up you out to finish EDI for great Plains on your own,especially if you act out for smaller meting 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 presidency isrequired to order merchandise from your partner in crime via EDI code you can createPurchase Orders in great Plains POP module, after that door and mark it as right of entry inSQL Stored Procedure, which saves the resulting row set in EDI tolerant fixedlength fields text or XML file. Thisfile is after that sent to your EDI channel (ftp uploads, Unix or Linux based emailchannel, here you have a lot of various options, outdoor 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 admittance 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 do dispatch SQL feeding to SOP10100 and SOP10200tables, or if you pick matter logic validation integration and you arefeeding to SOP Invoice, adjudicate programming eConnect SDK. For those of you who choose posting good Plainsbatches all the habit through without user bureau we suggest 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 tone free to call us: 1-866-528-0577, help@albaspectrum.com
No comments:
Post a Comment