As a relative new-comer to this field, I was taught that cost accounts are an intersection of the work breakdown structure (WBS) and organisational breakdown structure (OBS). The situation described here sounds like the WBS is intersecting with the OBS twice. Shouldnt the WBS be decomposed further?
OK, theory and practice dont always align. Id be interested in others opinions.
Scott
Member for
18 years 2 months
Member for18 years2 months
Submitted by James Barnes on Wed, 2007-10-17 09:52
Next time you will put the costa ccounts in from the start ;)
an idea;
export resource per activity detail including cost accounts to Excel
In Excel, change the cost accounts as you need
AND add a prefix to all resource codes in excel (RES becomes NEWRES for example)
Reimport
Now you should have 2 sets of resources on each activity, one with no cost codes (RES) and one with the cost codes on (NEWRES), the new ones will all have a prefix and the correct cost code. Now;
Delete the old resource codes in P3.
You may need to go through and manually reset the resource code, if you want to get rid of the prefix.
Another way is to delete all resources in P3 once you have made the export, then you shouldn’t get duplication.
Member for
18 years 1 monthRE: allocating cost accounts
I find this situation intriguing.
As a relative new-comer to this field, I was taught that cost accounts are an intersection of the work breakdown structure (WBS) and organisational breakdown structure (OBS). The situation described here sounds like the WBS is intersecting with the OBS twice. Shouldnt the WBS be decomposed further?
OK, theory and practice dont always align. Id be interested in others opinions.
Scott
Member for
18 years 2 monthsRE: allocating cost accounts
np 8)
Member for
20 years 1 monthRE: allocating cost accounts
I tried on a small portion of my planning, and everything went fine.
Ive just got now to apply this to the entire project...
thanks again for the tip !
Member for
20 years 1 monthRE: allocating cost accounts
backups my middle name !
anyway, thanks for the tip.
onscreen, it looks like its gonna work, and Im gonna try this today.
I think the char Ill add as a prefix is going to be something like a dot, so I wont have to manually correct the resources.
and promise, next time Ill put the cost accounts from the start !
Member for
18 years 2 monthsRE: allocating cost accounts
Next time you will put the costa ccounts in from the start ;)
an idea;
export resource per activity detail including cost accounts to Excel
In Excel, change the cost accounts as you need
AND add a prefix to all resource codes in excel (RES becomes NEWRES for example)
Reimport
Now you should have 2 sets of resources on each activity, one with no cost codes (RES) and one with the cost codes on (NEWRES), the new ones will all have a prefix and the correct cost code. Now;
Delete the old resource codes in P3.
You may need to go through and manually reset the resource code, if you want to get rid of the prefix.
Another way is to delete all resources in P3 once you have made the export, then you shouldn’t get duplication.
Remeber, back up before you do any of this!