Dynamics,Partner,Newsflash,EDI computer Dynamics GP Partner Newsflash: EDI in Great Plains
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
We will consider both situations when you are customer andyou are replenishing your inventory via EDI compliant vendors channel as wellas when you are the vendor to whom Purchase Order is placed through EDIchannel: 1. Inventoryrestocking via EDI channel. Here weassume that you are large organization, and you have Dynamics GP as your headquartersERP system. In GP Purchase OrderProcessing module, please issue Purchase Order and save it. Then open Microsoft SQL Server ManagementStudio 2005 and new query. Build yournew formatted Select statement to extract and form the data from the followingtables: POP10100 (Purchase Order HeaderWork) and POP10110 (Purchase Order Line Work). Formatted Select statement means, that each field you select with eitherCAST or CONVERT operators. EDI filetypically is saved as fixed length text file with header, lines and trailer,you save your formatted select statement as text file. We recommend you to setup SQL DTS package,which will select new purchase orders, mark them as exported to EDI, save newEDI text file and distribute this file to EDI recipients 2. ReceivingEDI orders from your customer. Here isreverse situation, when you are the vendor in EDI channel for largeorganization. For you EDI request shouldtranslate into Dynamics GP Sales Order or Invoice. This scenario is slightly more complex and wewill describe you successful scenario. You deploy either Great Plains Integration Manager or eConnect customapplication (which does the same job but in real time, if this is your goal). In IM you create new Source as Advanced ODBCand you base this source on MS SQL Server custom View. This custom view reads new EDI file, parsesit to SOP Document Header and Document Lines, then in IM destination you map itto SOP document customer Order, Invoice or Quote is this is your scenario. eConnect programming, if you are usingDynamics GP version 10.0, you are probably aware that IM is in process of beingrewritten in eConnect. So, this meansthat you future IM integration should be pretty similar to custom eConnectprogramming. At this time, of course,eConnect gives you complete control over Integration timing and allows you totrigger integration on demand or on event triggering 3. EDIAdd-Ons. Before you jump there, pleasetry to analyze free approach, we tried it several times and it works successfullyfor multiple GP customers. If you thinkyou got special case, in our opinion its uniqueness often falls into the needto translate Vendor Item Names from your Catalogue Items, or similar smalltranslations and tweaks, in our opinion, it is not the reason to pay high pricefor high end EDI add-on
Dynamics,Partner,Newsflash,EDI