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:
- We create a task and add an expense resource with a cost rate in the matrix of 1 euro
- The task has an ETC of the value of the expense
- 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)