10
Hi,
My organization runs about 150 projects every year and at year end each one has to be recreated (including new budgets) for the new fiscal year. This usually takes a week or two of data entry. Is there a way to import this data from Excel that could speed up the process?
Thanks, Anne
Hi Morph,
As Almas Mahfooz suggested, if you don't have any integration tools (like SmartConnect) or on-site developer to use eConnect as indicated by Shannon Aune, then macros might be the way to go..
I've been using a macro driven PA Contract - Project - Budget creation for years in my previous company.. it was not the fastest and it was multi-company driven, which means it was tailored to our various Cost Categories in the different companies (up to 5) and would switch company automatically after the new contract was created in one company.
The drawback of this was if the macro failed for some reason, it was hard to restart from where it had failed, and you had to delete all the contracts already created and restart the macro run.
After a few years, I started build something with Excel and Smartconnect, which would leverage eConnect stored procedure and that was very handy, but the budget upload had to be done in a separate stage, as you couldn't provision it at the same time you created the projects & cost categories. So it was always a 2-step process, but still much faster than entering everything manually.
Due to the complexity of the Project Accounting module, there is no way you could import data directly into the GP tables.. too many variables at stake here.
Hi Anne,
There are some integration options available via eConnect that you could use. I have provided a list of the eConnect integration functions that are available for Project Account below:
<taPAAccountsSetup>
<taPAChangeOrderEntryBudget>
<taPAChangeOrderEntryFeeDetail>
<taPAChangeOrderEntryFeeHeader>
<taPAChangeOrderEntryFeeSchedule>
<taPAChangeOrderEntryHdr>
<taPAContractBillingCycle>
<taPAContracts>
<taPAEmpExpenseHdrInsert>
<taPAEmpExpenseLineInsert>
<taPAEmpExpenseTaxInsert>
<taPAEquipLogHdrInsert>
<taPAEquipLogLineInsert>
<taPAMiscLogHdrInsert>
<taPAMiscLogLineInsert>
<taPAProjectAccess>
<taPAProjectBillingCycle> (this is creating a billing cyle id in GP, not processing a cycle billing)
<taPAProjectBudgetMaster>
<taPAProjectEquip>
<taPAProjectFee>
<taPAProjectFeeSchedule>
<taPAProjects>
<taPATimeSheetHdrInsert>
<taPATimeSheetLineInsert>
As always you will want to make sure that you test these functions to ensure that they will work for you before implementing them in your production environment. I hope this helps.
Thanks,
It can be done by using macro and custom code.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (