Edit 9/16/15 View the main article for this error
here
I was wondering if someone might be able to help me. I created SQL 2012 stored procedures that creates an eConnect PM integration that includes both distributions as well as Analytical Accounting data. I am having some problems with getting the AA data imported . When I run the eConnect stored procedures in the following order the PM Header and Distributions appear in GP but no AA data
Edit 9/16/15 View the main article for this error
here
Edit 9/16/15 View the main article for this error
hereI was looking on the web to try and find out what I was doing wrong and I saw a post that stated the stored procedures need to be run in the order they are listed in on the eConnect Schema Reference webpage. So I changed the order they are ran to how it is listed on the page
<taPMDistribution>
<taAnalyticsDistribution>
<taPMTransactionInsert>
Now when I run it, error 349 unable to update/create distributions is raised when taPMTransactionInsert is executed. No data appears in GP. Any idea what I could be doing wrong?
Thanks