Dynamics,Partner,California,ED computer Dynamics GP Partner California: EDI for Great Plains notes
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
Traditional EDI code is fixed length fields code structurewith document header, lines or body and document trailer. Newer EDI (or something that maybe processedsimilar to EDI scenarios on the high level with your Franchiser) maybe XMLstructured documents with similar parts: document header and document lines. Both scenarios are relatively straightforwardin SQL scripting, let come to the paragraphs of this story: 1. Sample Dynamics GP EDI code. For those of you who are SQL programmer,please take a look at this publication, where you can see good chunk of EDI documentscripting in SQL. This code wasimplemented in real Great Plains EDI integration situation and it should giveyou good start or help you out to finish EDI for Great Plains on your own,especially if you work for smaller organization 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 organization isrequired to order merchandise from your partner via EDI code you can createPurchase Orders in Great Plains POP module, then read and mark it as read inSQL Stored Procedure, which saves the resulting row set in EDI compliant 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, outside of the scope for thisarticle) 3. Getting Orders from your EDI channelcustomers. If you are franchiser and youare receiving Electronic Document Interchange orders from your customers orfranchisees and you are deploying Dynamics GP as your accounting system, thenyou can read 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 direct SQL feeding to SOP10100 and SOP10200tables, or if you prefer business logic validation integration and you arefeeding to SOP Invoice, consider programming eConnect SDK. For those of you who prefer posting Great Plainsbatches all the way through without user intervention 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, light manufacturing, logistics,consignment, please feel free to call us: 1-866-528-0577, [email protected]
Dynamics,Partner,California,ED