Activity Usage Spreadsheet with financial periods

G
Gema Arenas 👤 Member for 9 years 8 months

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!

Z
Zoltan Palffy 👤 Member for 16 years 11 months

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

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts