Project Management Central

Please login or join to subscribe to this thread

Topics: Cost Management, Digital Project Management, Earned Value Management
Can MS PROJECT handle multiple base currencies for resource costs? For example I rent my forklift in Indonesia and have a monthly Indonesian Rupiah Currency cost. I pay my PMP in US Dollars. Both are
Network:233



Can MS PROJECT handle multiple base currencies for resource costs? For example I rent my forklift in Indonesia and have a monthly Indonesian Rupiah Currency cost. I pay my PMP in US Dollars. Both are work resources. Can we track both in MS Project 2016 in their native currency formats? Thank you
Sort By:
Network:644



Jonathan -

As far as I know there is no out-of-the-box way to associate different currencies with different resources such that the aggregation of estimates or actuals will handle correct conversions. What you could so is use some custom fields to capture this type of info but it might require some macros or VB to get you the roll-up reporting you'd be looking for.

This is with reference to the MSP standalone (desktop) application - it is likely easier to extend MSP Server through the back-end to handle this...

Kiron
Network:868



Most of the financial project they have their own country base currency and all other transaction they would have a range of exchange rate to apply, we do the same we have CAD vs US$ Your time frame of the project and your chartered accountant will determine the range of exchange rate considering both bank rate and open market rate and if there is any rebate on your business.
Network:4
I used to work with MS project mostly in educational environment, but it seems that they have currency settings for projects as was stated by previous author. Reference link : https://support.office.com/en-us/article/c...57-09633a80dc9a It illustrates how to change currency for a project.
Moreover the good resource where particular information on MS Project can be found is https://pm.stackexchange.com. And there you may find a related discussion on multiple currency usage in projects https://social.technet.microsoft.com/Forum...nal2010general.
In my opinion, it is a matter of customization and time to get both currencies to work in a project.

For example Project Server has a feature to allow projects be published in multiple currencies:

"Allow projects to be published in various currencies Select this option if your organization uses multiple currencies for costs within projects. (This is the default setting)."

source: https://docs.microsoft.com/en-us/project/c...r-2013-settings
Corresponding ilnks:
https://microsoftproject.uservoice.com/for...ect-pro-and-pro

Please login or join to reply

Content ID:
ADVERTISEMENTS

"Love your enemy--it will scare the hell out of them."

- Mark Twain