Solved

Advantages of Custom eConnect XML Nodes

Posted on 2011-09-08
2
941 Views
Last Modified: 2012-05-12
I am familar with the practice of attaching custom data in an eConnect transaction as documented here:
http://msdn.microsoft.com/en-us/library/bb625126.aspx

And illustrated well here:
http://www.timwappat.info/post/Piggyback-your-data-on-eConnect-for-Dynamics-GP.aspx

But outside of transactional consistency, what is the advantages of this method over simply calling a stored procedure directly in GP?  In my case, when inserting a budget master record, I need to insert a row of data into a standalone table inside of GP .  I'm having a hard time justifying the extra work of attaching the extra xml over just inserting the row directly.
0
Comment
Question by:b_levitt
2 Comments
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
ID: 36506243
Hi,

I would agree with you in questioning the value, and would actually reverse the question and have someone try and answer it.

"Why would I want to add custom XML nodes to my eConnect transactions?"

Like most things technical and development related, there are often several different ways of accomplishing a goal or meeting a requirement.

My preference is to try and keep things as simple as reasonably possible.  If I have a choice between a few lines of code calling my very reliable classes and methods to insert non-eConnect data into GP, or writing code to somehow serialize and/or insert custom XML into an eConnect XML document so that eConnect can then call a separate custom stored proc, it's obvious to me which option I'll choose.

eConnect is great for what it is and what it does, but I'm not enamored enough with it to start having it do my non-eConnect database work for me.  It's easy enough to use an If statement in my code to see if eConnect succeeded or failed, and to manage my remaining inserts from there.

In most cases, reading from and writing to GP SQL Server tables is very simple and straightforward, and does not require anything elaborate.  So I stick with simple and straightforward.

The one extra feature that I have occasionally taken advantage of with eConnect are the User Defined fields present in most eConnect schemas.  Those are handy for inserting a few custom fields related to a transaction using the eConnect Pre and Post procs.  Sure, you could write your own code, but Pre and Post procs and 5 UDF nodes are simple enough that they pass my smell test for simple and straightforward.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 
LVL 11

Author Closing Comment

by:b_levitt
ID: 36510247
Your feedback is enough for me Steve.  Especially since your previous help is what is allowing me to cover transactional consistency outside of econnect:
http://www.experts-exchange.com/Software/Industry_Specific/Financial/Great_Plains/Q_24786364.html
Thank you,
B
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now