60
Hello,
Can anyone here tell me if it is possible to retrieve AR aging data through eConnect?
We have an integrating application that provides an AR aging report that was built from a SQL query that joined directly to the RM00101, RM20101, and RM30101 tables. We are no longer allowed by our network admin to access these tables directly.
Is it possible to retrieve the data in these tables by using eConnect?
Any help is appreciated.
Thanks,
Harold
*This post is locked for comments
You can call to the Requestor through eConnect and it is/was designed as the interface to get data out from eConnect. It's under used in my experience but I have built dot net calls to give me aging on demand.
I'm not sure, but I would assume the Web Service code also calls back through the Requestor itself as it seems to be more of a shell on eConnect then much of a standalone product. If I had the WS code enabled I would certainly opt for that myself but Requestor is the eConnect data query tool and is actually quite cool once you get the hang of it.
One other thing I have done in the past is to build code that wraps the RmHistoricalAgedTrialBalance stored procedure and have that return a results set. You need to manage a couple temp tables you create and quite a few parameters but then you have the GP logic creating the aging on the fly on demand. This allows you to pass in a historical cutoff date which is the great benefit of the HATB vs loading out the tables and doing the math yourself.
Best of luck.
Tim
Hello Tim,
Thank you for responding. To help keep my inquiry in perspective, I want to retrieve AR aging data. eConnect is OK if I do not have to add triggers to the GP database. Is there a way to get eConnect to retrieve the aging data without using the Requestor and triggers? If not, the GP web services appears to have that capability (from the links provided by Sandip).
Not sure if this will help, but I want to retrieve all data from the following tables: RM00101, RM20101, RM30101. Hopefully this is doable, and can be done by retrieving the entire table for each of the above tables.
Thanks,
Harold
eConnect does have the ability to return data through the Requestor setup. It's actually the only window eConnect has and if you have it loaded on your workstation you will find it under PF->Microsoft Dynamics -> eConnect -> Requestor Setup.
It is a set of table triggers which will write data out to either a MSMQ, a table or as a result set to a .Net call. It has a Customer Balance object pre configured but you can also create custom objects to return custom data sets. You really need access to the DB to ge the hang of how it works but when configured you do not need to access the DB directly.
I believe the WS code also has the same object but if you are not using the WS code currently I'd not set it up just for this.
Tim
Harold,
I am sure eConnect is part of GP Web Services. I believe behind sceen Dynamics GP Web Service use eConnect.
Let see what other blogers says about this.
Thanks
Sandip
Hello Sandip,
Thank you for taking the time to reply to my question. I see from the link you provided that GP has a web service that can be used to return AR aging data. Is it correct to assume that eConnect is not part of this web service?
Click on Ageing amount link and it will take you to Ageing periods details Here is other link msdn.microsoft.com/.../cc533962.aspx
Thanks
sandip
Harold,
eConnect don't have option to return AR ageing data. Dynamics GP Web Service has method for getting 'CustomerReceivablesSummary' it will return aging data.
Here is link for WebServices: msdn.microsoft.com/.../cc533973.aspx
Thanks
Sandip Jadhav
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
