Display resource allocation cost in Euro and GBP

Hello Planners,

Working with P6 8.4 on a France / UK project, I need to display the resource daily rate and budgeted cost in Euros for the french resources and in GBP for the english ones at the same time

I mean, I cannot answer the project director's needs with the P6 functionality of displaying all the cost in Euros or GBP according to the View currency in User Preferences.

Basically, I would assign only one € resource and one GBP resource to every activity.

I tried using cost UDF's and a Global change, with no satisfying results.

Thanks for your help,

Alexandre

V
Vladimir Liberzon 👤 Member for 25 years 4 months

David,

project cost is usually calculated as the costs of assigned resources.

I understood that in Alexandre case some resources have costs in Euros and others in GBR.

So the costs of project activities, work packages and the project is the sum of Euro and GBR expenses.

If to set special resource for one of the currencies then how to assign resource to resource that has cost in corresponding currency? If to assign costs to activities directly then they will not depend on assigned resources work and consumption.

D
David Kelly 👤 Member for 21 years 7 months

Alexandre,

only an American would think that Primavera's multi-currency option was adequate. They use dollars, or dollars.

 

The best way to deal with two currencies is to set up a resource for one of the currencies, say GBP,  and enter the Budget Cost as the Budget units. The Rate per hour is the exchange rate that you can vary every month or whatever for euros. So both columns, euros and GBP are available without global changes simply by showing the cost and the units.

The initial cost loading is a pain, as you may have multiple resources on one activity. Export and Import the resource assignments to excel, and do the aggregation and change to resource ID to GBP there.

V
Vladimir Liberzon 👤 Member for 25 years 4 months

Alexandre,

it looks like your question does not have easy answers.

You can use any number of currencies in Spider Project but i expect that you do not have an authority to select the right tool.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts