Solved

Advantages of Custom eConnect XML Nodes

Posted on 2011-09-08
2
947 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

Suggested Solutions

Title # Comments Views Activity
Dynamics CRM Online: Add Button on Sub-Grid 8 413
Scribe: Allowing for SQL Authentication 3 72
crm 2010 on premise 5 89
Microsoft Dynamics 365 2 282
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.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

821 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