Project Process Configurator - Project Forecast & Contract in different Currencies issue
Content (required):
We have a project forecast in functional currency EUR and an associated contract in USD. Using the Project Process Configurator we want to calculate our Revenue event using the planned amount multiplied by our percent complete in the project/contract. There is not a source to take the planned amount in Contract Currency, only Project Functional. The basis of the calculation is then incorrect as it is using a planned amount in the currency it will later be converted to.
For example: Forecast Revenue 1,000,000 EUR (Assume Exchange Rate 1.2 = 1,200,000 USD)
Percentage Complete 10%
Revenue Event Calculated (1,000,000 *10)/100 = 100,000 USD This should be 120,000 USD