SUMMARY STEPS TO REPRODUCE 1. Enter transactions in a ZMK denominated account 2. Configure 'Transactions by Payee Report' and deselect the 'Convert to Base Currency' option 3. Open report OBSERVED RESULT Currencies are always translated to the base currency whether or not this is selected. If base currency is not selected then value is prefixed with ZMK, but the value is the same. EXPECTED RESULT Value entered into the ledger with the currency prefix to be shown in the report. SOFTWARE/OS VERSIONS Windows: macOS: Linux/KDE Plasma: (available in About System) KDE Plasma Version: KDE Frameworks Version: Qt Version: ADDITIONAL INFORMATION
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
Git commit d0594c9ba43286d4acf3302fb4c03ce7bfb438cd by Ralf Habacker. Committed on 30/10/2024 at 14:15. Pushed by habacker into branch 'master'. Correction of expected test report values for “test-423870.xml” After the problem reported in error 382245 has been fixed, the expected values in reports of the mentioned test have changed and need to be adjusted. As the target accounts are managed in the US currency, the corresponding splits must also be splits must also be issued in this currency, as mentioned in the ticket. M +5 -7 kmymoney/plugins/views/reports/core/tests/data/test-423870-report-querytable-Transactions-by-Category-_Base-unconverted_.csv M +3 -5 kmymoney/plugins/views/reports/core/tests/data/test-423870-report-querytable-Transactions-by-Payee-_Base-unconverted_.csv https://invent.kde.org/office/kmymoney/-/commit/d0594c9ba43286d4acf3302fb4c03ce7bfb438cd