Add multi-currency support for resource costs.
Submitted by Lincoln Phipps
Link to original bug (#138935)
Description
A project should have a default (base) currency. Resource costs inherit that unless a resource cost has been told its a different currency.
When a resource uses a different currency then the resource cost should be converted internally back to the projects base currency using a rate from a crossrate table. Using a table is actually NOT a deficiency (i.e. compared to doing some fancy online update) because all companies use a budget/indicative or book rates for currency cross rates which are set annually or monthly or on some other particular period and never spot rates.
Task costs, which are calculated, should show the cost in the base currency only at this time. Where a resource use spans a change in the rate table then it should acrue pro-rata (though truthfully Planner doesn't handle cost accruals so any logic would do).
My main interest is in cable and euro sterling but the cross rate table should scale to handle all possible currency symbols and a large number of cross rates and time periods.
e.g. from-symbol, to-symbol, period-start, period-end, rate USD EUR 20040101 20041231 0.9 EUR USD 20040101 20041231 1.1111
the rate is multiplied on the from-symbol quantity to the to-symbol (BASE) quantity.
Rgds, Lincoln.