I'm using eConnect to create and update various items in Dynamics GP, but I can't seem to find how to use it to read data from GP. For example, I'd like to get the Vendor and Account lists from GP. Is there a way to do this from eConnect? Do I have to use SQL?
asked Mar 27, 2012 at 21:34 106k 49 49 gold badges 153 153 silver badges 188 188 bronze badgesYou don't have to use SQL; you can use eConnectOut to retrieve data, but the result sets are somewhat limited out of the box. In the end I found that just dealing with SQL was easier for me because eConnectOut doesn't give you access to all of the GP data without manipulation to the eConnect_Out_Setup table which is cumbersome at best.
There's a long list of DOCTYPEs in the eConnect_Out_Setup table for pre-existing eConnectOut queries if you're interested. The DOCTYPE you are probably looking for is Vendor (which is in the PM00200 table if you're using SQL).
If you are using XML for eConnect transactions, here's an example of that:
TRUE Customer Customer 2 346710 346710 0 1 0 0 0 More documentation on eConnectOut can be found on MSDN.