Clarity

  • 1.  Revenue and Actual Revenue not matching in Cost Plan (multi currency issue?)

    Posted Mar 22, 2016 06:05 PM

    In our projects we use expense transactions to track fixed costs or e.g. travel and expense costs. we also want to forecast this using the cost plan. The cost plan is now showing inaccurate data comparing Actual Revenue with Forecast revenue.

     

    What we do is the following:

    1. We create a task and add an expense resource with a cost rate in the matrix of 1 euro
    2. The task has an ETC of the value of the expense
    3. When book actuals we create this via an expense transaction

     

    Then after cost plan update it looks like this - see March 2016:

    * revenue = 2290

    * actuals = 2140

    This is what seems to happen:

     

    ·         Actual revenue is calculated as USD 2140 (which is correct as the exchange rate between USD and EUR = 1.07 à 2000 x 1.07 = 2140)

     

    ·         Revenue is calculated as USD 2290 USD which is not correct. But it seems that Clarity is calculating again from Actuals to Revenue by multiplying 1.07 (2140 x 1.07 = 2290 USD)

     

    Any idea why this is going wrong?

     

    Thanks

     

    Joost

     

    Expense transaction in billing currency (EURO) is calculated wrongly in Cost plan to home currency (USD). For example:

    ·         Actual revenue is calculated as USD 2140 (which is correct as the exchange rate between USD and EUR = 1.07 à 2000 x 1.07 = 2140)

    ·         Revenue is calculated as USD 2290 USD which is not correct. But it seems that Clarity is calculating again from Actuals to Revenue by multiplying 1.07 (2140 x 1.07 = 2290 USD)



  • 2.  Re: Revenue and Actual Revenue not matching in Cost Plan (multi currency issue?)

    Posted Mar 30, 2016 07:36 AM

    Hello,

     

    Check this link: CA Clarity Tuesday Tip: Cost Plan 'Planned' calculations for past periods

     

    Hope this helps!

     

    Suhail.



  • 3.  Re: Revenue and Actual Revenue not matching in Cost Plan (multi currency issue?)

    Posted Apr 16, 2016 04:19 AM

    No I am afraid it doesn't. It only describes how it should work, but the issue is that it doesn't work as described by CA.