[kmymoney] [Bug 452026] Income and Expenses chart displays wrong stats when currency rate changes
https://bugs.kde.org/show_bug.cgi?id=452026 Tamer changed: What|Removed |Added CC||tfa...@gmail.com -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 452026] New: Income and Expenses chart displays wrong stats when currency rate changes
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-de...@kde.org Reporter: tfa...@gmail.com Target Milestone: --- Created attachment 147812 --> https://bugs.kde.org/attachment.cgi?id=147812=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 watching all bug changes.
[Akonadi] [Bug 421614] akonadiserver segfaults everytime it is stopped
https://bugs.kde.org/show_bug.cgi?id=421614 Tamer Hassan changed: What|Removed |Added Status|REPORTED|RESOLVED Resolution|--- |NOT A BUG --- Comment #1 from Tamer Hassan --- obviously a problem with current libmysqlclient21 (8.0.20) in (k)ubuntu not problem with Akonadi See: https://bugs.launchpad.net/bugs/1877504 -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 421614] New: akonadiserver segfaults everytime it is stopped
https://bugs.kde.org/show_bug.cgi?id=421614 Bug ID: 421614 Summary: akonadiserver segfaults everytime it is stopped Product: Akonadi Version: 5.11.3 Platform: Ubuntu Packages OS: Linux Status: REPORTED Keywords: drkonqi Severity: crash Priority: NOR Component: server Assignee: kdepim-b...@kde.org Reporter: thamerud...@gmail.com Target Milestone: --- Application: akonadiserver (5.11.3) Qt Version: 5.12.4 Frameworks Version: 5.62.0 Operating System: Linux 5.3.0-51-generic x86_64 Distribution: Ubuntu 19.10 -- Information about the crash: - What I was doing when the application crashed: On shutdown, logout, or manually via `akonadictl stop` This started happening only after I started using Kmail, as I've added one IMAP account. The crash can be reproduced every time. -- Backtrace: Application: Akonadi Server (akonadiserver), signal: Segmentation fault Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [Current thread is 1 (Thread 0x7f9b9a16bd40 (LWP 12262))] Thread 2 (Thread 0x7f9b99bf7700 (LWP 12263)): #0 __GI___libc_read (nbytes=16, buf=0x7f9b99bf6b60, fd=5) at ../sysdeps/unix/sysv/linux/read.c:26 #1 __GI___libc_read (fd=5, buf=0x7f9b99bf6b60, nbytes=16) at ../sysdeps/unix/sysv/linux/read.c:24 #2 0x7f9b9c93d70f in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0 #3 0x7f9b9c8f55fe in g_main_context_check () from /lib/x86_64-linux-gnu/libglib-2.0.so.0 #4 0x7f9b9c8f5a52 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0 #5 0x7f9b9c8f5be3 in g_main_context_iteration () from /lib/x86_64-linux-gnu/libglib-2.0.so.0 #6 0x7f9b9df56653 in QEventDispatcherGlib::processEvents (this=0x7f9b94000b60, flags=...) at kernel/qeventdispatcher_glib.cpp:424 #7 0x7f9b9defd5cb in QEventLoop::exec (this=this@entry=0x7f9b99bf6d70, flags=..., flags@entry=...) at ../../include/QtCore/../../src/corelib/global/qflags.h:140 #8 0x7f9b9dd36a45 in QThread::exec (this=) at ../../include/QtCore/../../src/corelib/global/qflags.h:120 #9 0x7f9b9e21befa in ?? () from /lib/x86_64-linux-gnu/libQt5DBus.so.5 #10 0x7f9b9dd37c92 in QThreadPrivate::start (arg=0x7f9b9e29ed80) at thread/qthread_unix.cpp:361 #11 0x7f9b9d0e0669 in start_thread (arg=) at pthread_create.c:479 #12 0x7f9b9d9a2323 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 1 (Thread 0x7f9b9a16bd40 (LWP 12262)): [KCrash Handler] #6 0x7f9b98d5a23f in charset_uninit () at ./mysys/charset.cc:925 #7 0x7f9b98d5f753 in my_end (infoflag=infoflag@entry=0) at ./mysys/my_init.cc:200 #8 0x7f9b98cfd173 in mysql_server_end () at ./libmysql/libmysql.cc:202 #9 0x7f9b993eb0ee in qLibraryEnd () at qsql_mysql.cpp:1243 #10 QMYSQLDriver::~QMYSQLDriver (this=0x55bd34c0c7c0, __in_chrg=) at qsql_mysql.cpp:1243 #11 0x7f9b993eb10d in QMYSQLDriver::~QMYSQLDriver (this=0x55bd34c0c7c0, __in_chrg=) at qsql_mysql.cpp:1239 #12 0x7f9b9e2bb5fb in QSqlDatabasePrivate::~QSqlDatabasePrivate (this=0x55bd34c0f220, __in_chrg=) at kernel/qsqldatabase.cpp:142 #13 0x7f9b9e2bb88e in QSqlDatabase::~QSqlDatabase (this=0x55bd34c392d8, __in_chrg=) at kernel/qsqldatabase.cpp:724 #14 QSqlDatabase::~QSqlDatabase (this=0x55bd34c392d8, __in_chrg=) at kernel/qsqldatabase.cpp:720 #15 0x7f9b9e2bd901 in QHashNode::~QHashNode (this=0x55bd34c392c0, __in_chrg=) at ../../include/QtCore/../../src/corelib/tools/qhash.h:149 #16 QHash::deleteNode2 (node=0x55bd34c392c0) at ../../include/QtCore/../../src/corelib/tools/qhash.h:547 #17 0x7f9b9dd8c70c in QHashData::free_helper (this=0x55bd34c39280, node_delete=0x7f9b9e2bd8f0 ::deleteNode2(QHashData::Node*)>) at tools/qhash.cpp:572 #18 0x7f9b9e2bbb4c in QHash::freeData (this=, x=) at ../../include/QtCore/../../src/corelib/tools/qhash.h:585 #19 QHash::~QHash (this=, __in_chrg=) at ../../include/QtCore/../../src/corelib/tools/qhash.h:254 #20 QHash::operator= (other=..., this=0x7f9b9e2ed680 <(anonymous namespace)::Q_QGS_dbDict::innerFunction()::holder>) at ../../include/QtCore/../../src/corelib/tools/qhash.h:260 #21 QHash::clear (this=0x7f9b9e2ed680 <(anonymous namespace)::Q_QGS_dbDict::innerFunction()::holder>) at ../../include/QtCore/../../src/corelib/tools/qhash.h:593 #22 QSqlDatabasePrivate::cleanConnections () at kernel/qsqldatabase.cpp:156 #23 0x7f9b9e2bbcb7 in cleanDriverDict () at kernel/qsqldatabase.cpp:164 #24 0x7f9b9df00942 in qt_call_post_routines () at kernel/qcoreapplication.cpp:351 #25 0x7f9b9df00a92 in QCoreApplication::~QCoreApplication (this=0x55bd34c02e80, __in_chrg=) at kernel/qcoreapplication.cpp:894 #26 0x7f9b9df00cdd in QCoreApplication::~QCoreApplication (this=0x55bd34c02e80, __in_chrg=) at kernel/qcoreapplication.cpp:892 #27 0x55bd337badf4 in std::default_delete::operator() (this=0x7ffe7c354560, __ptr=) at /usr/include/c++/9/bits/unique_ptr.h:75 #28 std::unique_ptr
[kmymoney4] [Bug 385857] Wrong Currency conversion rate in Reports
https://bugs.kde.org/show_bug.cgi?id=385857 --- Comment #8 from Tamer <tfa...@gmail.com> --- Created attachment 108452 --> https://bugs.kde.org/attachment.cgi?id=108452=edit Updated Screen Shots Adding two screen shots to show the list of entered transactions and showing the report that has the wrong values. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney4] [Bug 385857] Wrong Currency conversion rate in Reports
https://bugs.kde.org/show_bug.cgi?id=385857 --- Comment #7 from Tamer <tfa...@gmail.com> --- Created attachment 108451 --> https://bugs.kde.org/attachment.cgi?id=108451=edit kmy file showing the case I attached the kmy file in which the bug appears. You can see the wrong summation in the report "Income and Expenses 2016" in Month of Nov. The report is showing 170,263.37 AED instead of 344,450 AED -- You are receiving this mail because: You are watching all bug changes.
[kmymoney4] [Bug 385857] Wrong Currency conversion rate in Reports
https://bugs.kde.org/show_bug.cgi?id=385857 --- Comment #5 from Tamer <tfa...@gmail.com> --- Hi Ralf, I created a new project to simulate the case and what you mentioned is correct. the report shows the correct value. The bug looks to appear only with old projects and files. Please note that I am using this application since 2014 and I used different versions with the same file. Maybe something wrong in the database stored in the file or a scenario not covered in the new version. What I have shared is real snapshots of my records and definitely there is a problem which cannot be reproduced by simulating new projects. I am not sure if I there is any utility that can decrypt the data so i can share my file with you for analysis. if so, please let me know, or I can share my screen with you to validate my argument your self, or we can close this bug if there no other option. Thanks for your efforts. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney4] [Bug 385857] Wrong Currency conversion rate in Reports
https://bugs.kde.org/show_bug.cgi?id=385857 --- Comment #3 from Tamer <tfa...@gmail.com> --- Thanks Ralf for your prompt feedback, I have uploaded the file "[kmymoney4] [Bug 385857] Wrong Currency conversion rate in Reports.pdf" which contains the reproducing steps with screen shots to demonstrate the case in real life example. Please let me know if you need further information. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney4] [Bug 385857] Wrong Currency conversion rate in Reports
https://bugs.kde.org/show_bug.cgi?id=385857 --- Comment #2 from Tamer <tfa...@gmail.com> --- Created attachment 108428 --> https://bugs.kde.org/attachment.cgi?id=108428=edit [kmymoney4] [Bug 385857] Wrong Currency conversion rate in Reports Reproducing steps with screen shots -- You are receiving this mail because: You are watching all bug changes.
[kmymoney4] [Bug 385857] Wrong Currency conversion rate in Reports
https://bugs.kde.org/show_bug.cgi?id=385857 Tamer <tfa...@gmail.com> changed: What|Removed |Added CC||tfa...@gmail.com -- You are receiving this mail because: You are watching all bug changes.
[kmymoney4] [Bug 385857] New: Wrong Currency conversion rate in Reports
https://bugs.kde.org/show_bug.cgi?id=385857 Bug ID: 385857 Summary: Wrong Currency conversion rate in Reports Product: kmymoney4 Version: 4.8.0 Platform: MS Windows OS: MS Windows Status: UNCONFIRMED Severity: normal Priority: NOR Component: reports Assignee: kmymoney-de...@kde.org Reporter: tfa...@gmail.com Target Milestone: --- Dear Sirs, Problem Statement: Reports convert currencies in wrong rates in case rate changes of the different currencies in use. Below are the reproducing steps: 1. Make the application base currency as AED (United Arab Emirates Dirhams). 2. Create a cash account in AED: name= "Cash in AED" 3. Create an income category "Salary" in EGP (Egyptian Pounds). 4. Set the conversion rate between AED and EGP as: 1 AED = 2 EGP effective 1 Jan 2017. 5. Make a deposit transaction of 1,000 AED into "Cash in AED" with category "Salary" with entry date as 1 March 2017. --> At this stage the application will convert 1,000 AED to 2,000 EGP. 6. Set the conversion rate to be 1 AED = 5 EGP effective 1 Oct 2017. 7. Configure the Income and Expenses Report to have the option "Convert values to base currency" checked. --> the report will show the deposited 1,000 AED as 400 AED despite it is deposited into the an account with AED currency. It took the converted 2,000 EGP and converted them into AED with the latest rate (1 AED= 5 EGP) which is wrong because they money is still in AED and never converted in reality. or either to consider the rate at which the transaction was inserted which was (1 AED= 2 EGP). The current report gives wrong information and accordingly we can take wrong decisions. -- You are receiving this mail because: You are watching all bug changes.