Skip to content
+1-888-319-3663

COMMUNITY FORUM

Project Budget Updating

john.ellis@tribridge.com asked 9 years ago
Hello:

I have successfully created, in SmartConnect 2012, a map that imports a budget for projects in GP Project Accounting.  The budget, after import, is seen by clicking the "Budget" button in the Project Maintenance window.  The budget is being imported from an Excel 2010 spreadsheet.

Unfortunately, I have noticed that if you want to update that existing budget by either adding additional data to that same spreadsheet or by modifying the data on the spreadsheet, the SmartConnect import fails and says that the Project Number and Cost Categories for the budget already exist.

This is true, despite having checked the "Update Existing" checkbox in the mapping.

Is there really not a way to update existing project budgets through SmartConnect?

Other items in GP, such as vendors and customers, can be updated by checking the "Update Existing" checkbox.  So, I'm surprised that this issue exists with project budgets.

Thanks!  Much appreciated!

John
Chris Dew replied 9 years ago

John,

The eConnect nodes from Microsoft do not support updating of projects. The only way around this would be to build new eConnect nodes (from scratch or using Node Builder) and use that inside SC.

Thanks,
Chris

Answers
Best Answer
john.ellis@tribridge.com answered 9 years ago
Thanks, Chris!

John
Davel replied 8 years ago

Hi Chris,

Do you know if this is till the case?

Thanks

Chris Dew replied 8 years ago

Dave,

The eConnect nodes from Microsoft haven't been changed at all for Projects. So the answer remains the same that you would either need to use Node Builder to create new nodes or use direct SQL table updates.

The one bright thing to look forward to will be our connector for "DexNext" from Microsoft. This will open up integration points to use the same logic as Dynamics GP without another set of business objects like eConnect.

Thanks,
Chris

Patrick Cox replied 2 years ago

Hi
Is DexNext now available? Can you now use smart connect to update existing project budgets? Thanks


If you would like to submit an answer or comment, please sign in to the eOne portal.