?
Solved

Advantages of Custom eConnect XML Nodes

Posted on 2011-09-08
2
Medium Priority
?
964 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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…

588 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