Loading...
Quick Links

Muli Currency Visibility in MS Project

Home Forums Discussion Muli Currency Visibility in MS Project

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #309288 Reply
    Karen Stephens
    Guest

    Is there an add-on or a macro that enables MS Project 2010 (Professional and Server) to show costs in multiple currencies. We are a global corporation and associates in different regions need to view their costs in different currencies. However, since global headquarters are located in North America, we have to have costs reflected in USD.

    #309290 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    Not that I know of, especially if costs need to be reflected in USD. If they are managed in USD then what multi-currency features that are available won’t work in this case. One solution is to show those projects in the local currency using reports. Project Server combined with a couple of conversion tables (Project->currency and Currency conversion) and Power Pivot can provide reporting for you. Hope that helps. I can also help with that if you wish to discuss. Thanks…

    #309294 Reply
    Karen Stephens
    Guest

    We have something like that in use, already; however, finance is now telling us this will not work since the figures in SAP do not and will not agree with the figures in EPM Project Server reports due to conversion rounding in Excel and the fact that MS Project will only carry costs out to 2 digits and will round

    #309297 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    Yep, they will never agree unless everything is done in local currency. What about using the multi-currency option in Project Server and then convert manually to USD? You understand that multi-currency will never match exactly so someone has to be off. You can enter costs in Project Server at the currency of choice, but then will need to use the same reporting the other way around to convert the cost to USD. Unfortunately Project Server only allows for entry in a local currency but does not have the capability to provide the conversion out of the box. Sorry, no perfect answer…just some thoughts.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Muli Currency Visibility in MS Project
Your information: