Activity Usage Spreadsheet with financial periods
- Created
- 1
- 2
Hello,
I am trying to get an accurate cost spread for my project.
We do not use resources only expenses and we have specific financial periods which I have set up in the admin tab.
However, when I show the activity usage spreadsheet on my layout, the costs are not allocated to the correct month, i.e. if my financial period runs from 24th Sept to 21st October, even though the activity finishes on the 23rd, the cost is still showing in October instead of September.
Any help/directions would be much appreciated.
Thanks!
1 reply
Oldest first- 0Zoltan Palffy ·
create one resource call it
create one resource call it lumpsum select all activities then right click and select assign then select resource then select the lumpsum resource that you just created. Now create a UDf (user defined field) let's call it UDFC and for the type of udf make it costs. Now run a global change and make the statement
where
original duration is not equal to 0
then
UDFC = Budgeted Expense Cost
now run a second global change in the global change up top make sure that under select subject area that you change this to Activity Resource Assignment.
where
resource id is not equal to (blank)
then
Budgeted Costs = UDFC
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?