GNOME Bugzilla – Bug 138935
Add multi-currency support for resource costs.
Last modified: 2021-06-09 20:30:03 UTC
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.
I plan that the rates are loosely stored in the database with the primary key being the start date,end date, from-symbol, to-symbol. The project -id will also be stored but thats not essential. This means a project thats stored in the database can use other projects' cross rates when its loaded. If its loaded from a XML file then this obviously won't happen. At a later stage, we can do this... - when we drop a project, we can optionally drop the rates for the project, - when we load a project, we can load a separate rate file. The first part requires us to add the Database Maintenance interface, and the second part requires us to be able to load additional XML files. The additional load is also wanted for resources and calendars so a nice bit of work for someone :) This bugzilla will only add multi-currency NOT manage rates too extensively.
-- GitLab Migration Automatic Message -- This bug has been migrated to GNOME's GitLab instance and has been closed from further activity. You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/World/planner/-/issues/50.