Dynamics Community Forum Thread Details

Accounts not updating econnect from project class on a project

I am integrating projects using SmartConnect. I am passing project class ID where I have GL accounts setup but eConnect does not update the GL accounts. SmartConnect says it is a bug now I would like to understand the following functionality and how to call it either using SQL or SmartConnect, any one any idea on how to accomplish this task. It works fine from the front end but not using SmartConnect. What is the field that triggers this action?

Categories:

Microsoft Dynamics GP

Hello,

Thank you for your details. The reason that the accounts don't roll down from the classes through eConnect is because that action is in the user interface is all powered by code in the application, whereas eConnect is 100% SQL based and not all UI logic is replicated through the eConnect Stored Procedures. You could create your own Post script to update or insert the accounts in the PA43001 for the Project table based on the accounts from the Project Class ID in the PA43001 table.

The accounts from the class are in the PA43001 wish a PAsfid = 18 (replace CLASSID with your project class)

select * from PA43001 where PAsfid = '18' and PArecordid = 'CLASSID'

The accounts for the project are also in the PA43001 with a PAsfid =28 (Replace PArecordid with your Project Number)

select * from PA43001 where PAsfid = '28' and PArecordid = 'PROJECTNUMBER'

With this information you could create your own custom logic to update the projects with the accounts from your class setup, or maybe SmartConnect could use this information to help you with this as well.

If you have more detailed questions or need deeper assistance on something like they we would need to address it through a support case. While we do not write customizations we could help you with understanding the table and column meanings better or with how to create a post script with eConnect in general.

I hope this helps.

Isaac Olson

Microsoft Support

Quick Links