Summary: | Report 'Transactions by Category' converts all records to base currency even if this option is not selected | ||
---|---|---|---|
Product: | [Applications] kmymoney | Reporter: | danieljbridges |
Component: | reports | Assignee: | KMyMoney Devel Mailing List <kmymoney-devel> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | danieljbridges, KMyMoney, ralf.habacker |
Priority: | NOR | ||
Version: | 5.1.0 | ||
Target Milestone: | --- | ||
Platform: | PCLinuxOS | ||
OS: | Linux | ||
Latest Commit: | https://invent.kde.org/office/kmymoney/commit/1159cad3b33ab6cdd50985db7899228715b8fba1 | Version Fixed In: | 5.1.1 |
Sentry Crash Report: | |||
Attachments: |
Test File showing issue with report by category or payee
Test file to reproduce the error that has occurred again |
Description
danieljbridges
2020-07-04 13:15:14 UTC
I can confirm that this appears to be generic and not related to the currency. My base currency is GBP and the following currencies (AUD, USD, EUR, MWK, ZMW) and are all converted to GBP in the report, whether convert to base currency is selected. This seems like a major flaw in the report generation - it essentially can not deal with any currencies other than the base one. This holds for all reports that report by category or payee. Can you supply a (small) demo file that shows the problem and attach it here at change the status to reported again? Many thanks in advance. Created attachment 130888 [details]
Test File showing issue with report by category or payee
Have created a dummy file with two accounts in USD and GBP. Both have a single transaction worth 50 USD or 50 GBP. There are 4 favourite reports for Payee (base converted and unconverted) or for category (base converted and unconverted). Whether base converted or not the values are always converted to the base currency of the file (USD).
Thanks for the file showing the problem. I did analyze it and in fact, the numbers are correct but the currency shown is wrong. For the reports you mention no GBP values should be shown as the categories are denominated in USD. In order for this report to show foreign currencies and their values, the categories must be denominated in the foreign currency. So the fix will be to present the correct currency. If you want to see that it works, take a look at the transactions by account report. Git commit 49dcabca8bd912554185e49faff43c685b77764d by Thomas Baumgart. Committed on 18/08/2020 at 06:25. Pushed by tbaumgart into branch 'master'. Show correct currency in report In multi-currency transactions the transaction commodity was used as currency instead of the categories currency. The value shown is correct. This change fixes the problem by overriding the currency in this case with the one of the category. M +11 -3 kmymoney/plugins/views/reports/core/querytable.cpp https://invent.kde.org/office/kmymoney/commit/49dcabca8bd912554185e49faff43c685b77764d Git commit 1159cad3b33ab6cdd50985db7899228715b8fba1 by Thomas Baumgart. Committed on 18/08/2020 at 07:21. Pushed by tbaumgart into branch '5.1'. Show correct currency in report In multi-currency transactions the transaction commodity was used as currency instead of the categories currency. The value shown is correct. This change fixes the problem by overriding the currency in this case with the one of the category. FIXED-IN: 5.1.1 (cherry picked from commit 49dcabca8bd912554185e49faff43c685b77764d) M +11 -3 kmymoney/plugins/views/reports/core/querytable.cpp https://invent.kde.org/office/kmymoney/commit/1159cad3b33ab6cdd50985db7899228715b8fba1 *** Bug 426796 has been marked as a duplicate of this bug. *** Created attachment 173507 [details]
Test file to reproduce the error that has occurred again
- The date range in the test file reports has been updated to match the transactions included.
- Category reports with converted and non-converted base have been added
|