Project Budget Updating
john.ellis@tribridge.com asked 10 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
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
Answers
Best Answer
john.ellis@tribridge.com answered 10 years ago
Davel replied 9 years ago
Chris Dew replied 9 years ago
Patrick Cox replied 4 years ago
john.ellis@tribridge.com answered 10 years ago
Thanks, Chris!
John
John
Davel replied 9 years ago Hi Chris,
Do you know if this is till the case?
Thanks
Chris Dew replied 9 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 4 years ago Hi
Is DexNext now available? Can you now use smart connect to update existing project budgets? Thanks
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