[kmymoney] [Bug 452026] New: Income and Expenses chart displays wrong stats when currency rate changes

[Tamer]

https://bugs.kde.org/show_bug.cgi?id=452026

            Bug ID: 452026
           Summary: Income and Expenses chart displays wrong stats when
                    currency rate changes
           Product: kmymoney
           Version: 5.1.2
          Platform: Other
                OS: Microsoft Windows
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: reports
          Assignee: kmymoney-devel at kde.org
          Reporter: tfawzy at gmail.com
  Target Milestone: ---

Created attachment 147812
  --> https://bugs.kde.org/attachment.cgi?id=147812&action=edit
Income and Expenses chart displays wrong stats when currency rate changes

SUMMARY
***
"Income and Expenses This Year" Report showing incorrect values in a month if
the currency conversion rate was changed during the month.
***


STEPS TO REPRODUCE
1. Create a new KMyMoney file having base currency as EGP
2. ADD another currency AED and make the conversion rate of 1 AED = 4 EGP with
a date of 1 Jan 2022
3. Make new entry for the conversion rate to be 1 AED = 5 EGP with a date of 20
Mar 2022
4. Create a saving account "My Bank" with AED Currency.
5. Create a category "Salary" with EGP Currency.
6. Change the base currency to be AED (tools -->Currencies)
7. Add a new transaction in "My Bank" account for 1,000 AED dated 22 Mar 2022
8. Go to (Reports --> 1. Income and Expenses) and select (Income and Expenses
This year)


OBSERVED RESULT
The report will show an income of 1,250 AED

EXPECTED RESULT
The report must show an income of 1,000 AED as entered.

MY ANALYSIS:
It looks like the application did the following:
1. Converted the 1,000 AED with the rate of 1 AED= 5 EGP which made it 5,000
EGP (as this is the currency of the category "Salary") which is correct
behavior as conversion rate was changed on 20 Mar 2022 so application picked
the right rate.
2. Converted back the 5,000 EGP to the base currency (AED) at the rate of 1
AED=4 EGP which was the conversion rate at the beginning of the month, and the
result is 1,250 AED which is totally wrong.

This behavior is giving false stats on the income and expenses and users can
make wrong decisions in their life.
SOFTWARE/OS VERSIONS
Windows: Windows 10
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION

-- 
You are receiving this mail because:
You are the assignee for the bug.