Dynamics GP partner in crime California: EDI for good Plains notes

TIPS,TRICK,VIRAL,INFO

EDI of Electronic Document alternating sometimes considered by IT department as something complex, and in order to agree to EDI integration for your ERP system, you have to purchase expensive EDI add-ons. We would next to meet the expense of you this little publication, that should try to bust this myth.

Traditional EDI code is truth 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 when your Franchiser) maybe XMLstructured documents gone thesame parts: document header and document lines. Both scenarios are relatively straightforwardin SQL scripting, let arrive to the paragraphs of this story:

1.Sample Dynamics GP EDI code. For those of you who are SQL programmer,please endure a look at this publication, where you can look fine chunk of EDI documentscripting in SQL. This code wasimplemented in genuine great Plains EDI integration thing and it should giveyou fine begin or assist you out to finish EDI for great Plains on your own,especially if you be active for smaller doling 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 doling out isrequired to order merchandise from your co-conspirator via EDI code you can createPurchase Orders in good Plains POP module, after that approach and mark it as approach inSQL Stored Procedure, which saves the resulting quarrel set in EDI compliant 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, uncovered 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 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 reach speak to SQL feeding to SOP10100 and SOP10200tables, or if you choose thing logic validation integration and you arefeeding to SOP Invoice, rule programming eConnect SDK. For those of you who choose posting great Plainsbatches all the way through without user activity we recommend 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, blithe manufacturing, logistics,consignment, entertain feel pardon to call us: 1-866-528-0577, help@albaspectrum.com