[kmymoney] [Bug 457832] New: Net-Worth report displays incorrect asset values.
https://bugs.kde.org/show_bug.cgi?id=457832 Bug ID: 457832 Summary: Net-Worth report displays incorrect asset values. Product: kmymoney Version: 5.1.2 Platform: Appimage OS: Linux Status: REPORTED Severity: major Priority: NOR Component: reports Assignee: kmymoney-devel@kde.org Reporter: k...@pohw.nl Target Milestone: --- Created attachment 151299 --> https://bugs.kde.org/attachment.cgi?id=151299&action=edit KMyMoney data file SUMMARY A Net-Worth report displays incorrect asset values. I have an account with outstanding balances set to zero in 2014. Depending on how the date range of the report is set, the report still displays a positive balance for dates > 2014. This gravely compromises the reporting value. STEPS TO REPRODUCE 1. Open the attached data file bug_report_v5.xml. 2. Open the ledger for account A2 and observe the balance is zero on 2014-09-03. 3. Open the ledger for account A3 and observe the balance is zero on 2014-09-03. 4. Open the favorite report R1. 5. Observe how the balance for A2 is €500 from 2014 onwards (while the balance is in fact zero). 6. Observe how the balance for A3 is €12625.26 from 2014 onwards (while the balance is in fact zero). 7. Configure report R1. Any date change, even if using the same dates, will produce a correct report. Please be aware that if A2 and A3 are closed (and thus invisible) it is extremely difficult to understand why your current asset values are incorrect. SOFTWARE/OS VERSIONS KMyMoney: AppImage 5.1.2-cb0b492 Linux version: openSUSE Leap 15.3 KDE Plasma Version: 5.76.0-bp153.5.2.1 KDE Frameworks Version: 5.51.0 Qt Version: 5.11.3 ADDITIONAL INFORMATION I've tried to export the data file as an anonymous file, but that created a big mess, so I trimmed down the data file manually to minimum size, and anonymized it manually. -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 457832] Net-Worth report displays incorrect asset values.
https://bugs.kde.org/show_bug.cgi?id=457832 --- Comment #1 from Ceaus --- Created attachment 151300 --> https://bugs.kde.org/attachment.cgi?id=151300&action=edit Screenshot of the incorrect balance values -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 440690] Double-clicking on a root node should expand it in Account/Category view
https://bugs.kde.org/show_bug.cgi?id=440690 Thomas Baumgart changed: What|Removed |Added Resolution|--- |FIXED Latest Commit||https://invent.kde.org/offi ||ce/kmymoney/commit/9545ca2e ||83c60e33abe28f8cb89fa5b8c55 ||52781 Status|REPORTED|RESOLVED --- Comment #1 from Thomas Baumgart --- Git commit 9545ca2e83c60e33abe28f8cb89fa5b8c5552781 by Thomas Baumgart. Committed on 13/08/2022 at 12:12. Pushed by tbaumgart into branch 'master'. Expand/collaps root nodes upon double-click on account M +8-2kmymoney/widgets/kmymoneyaccounttreeview.cpp https://invent.kde.org/office/kmymoney/commit/9545ca2e83c60e33abe28f8cb89fa5b8c5552781 -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 457832] Net worth report displays incorrect asset values.
https://bugs.kde.org/show_bug.cgi?id=457832 Ceaus changed: What|Removed |Added Summary|Net-Worth report displays |Net worth report displays |incorrect asset values. |incorrect asset values. -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 457832] Net worth report displays incorrect account balance
https://bugs.kde.org/show_bug.cgi?id=457832 Ceaus changed: What|Removed |Added Summary|Net worth report displays |Net worth report displays |incorrect asset values. |incorrect account balance -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 457832] Net worth report displays incorrect account balance
https://bugs.kde.org/show_bug.cgi?id=457832 Thomas Baumgart changed: What|Removed |Added Resolution|--- |WAITINGFORINFO Status|REPORTED|NEEDSINFO --- Comment #2 from Thomas Baumgart --- I don't know how you end up with this report configuration. In your description I simply replaced step 7 with 7. Configure report R1. Press Apply w/o any changes and the report is shown correct. If I save the file and then try to reproduce the problem it is gone. Looking at the raw configuration of the report it has an active filter for category (C1). That is the reason why all your transfer transactions are not taken into account. For a net worth report it does not make sense to filter on categories. Do you have a category filter setup on your original report? What happens, if you remove it? -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 341511] Information from last item in ledger list remains when filtering list
https://bugs.kde.org/show_bug.cgi?id=341511 Thomas Baumgart changed: What|Removed |Added Status|REPORTED|NEEDSINFO Resolution|--- |WAITINGFORINFO --- Comment #2 from Thomas Baumgart --- Changing state -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 457832] Net worth report displays incorrect account balance
https://bugs.kde.org/show_bug.cgi?id=457832 Ceaus changed: What|Removed |Added Status|NEEDSINFO |REPORTED Resolution|WAITINGFORINFO |--- -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 457832] Net worth report displays incorrect account balance
https://bugs.kde.org/show_bug.cgi?id=457832 --- Comment #3 from Ceaus --- (In reply to Thomas Baumgart from comment #2) > I don't know how you end up with this report configuration. As simple as point-click-point-click-ENTER > In your description I simply replaced step 7 with > 7. Configure report R1. Press Apply w/o any changes and the report is shown > correct. Same here. > If I save the file and then try to reproduce the problem it is gone. Same here. > Looking at the raw configuration of the > report it has an active filter for category (C1). That is the reason why all > your transfer transactions are not taken into account. For a net worth > report it does not make sense to filter on categories. > Do you have a category filter setup on your original report? This is for fiscal reasons. I have a (very) small company, and when submitting the balance sheet, I have to exclude taxes from the balance sheet (that's a side effect of Dutch tax laws). So category C1 is in fact the "Paid taxes this year" category. I was hoping to be able to run the balance sheet without having to worry about paid taxes during the year. It seems I need to make it a double run: first run the balance sheet (no categories selected) and then manually process the paid taxes. Would you agree the initial finding (as per the screenshot) is a bug? > What happens, if you remove it? Than I get the correct balances. Somehow I've missed the warning for missing the transfer transactions. Which is stupid as I've been using KMM for more than a decade, and I've seen all screens hundreds and hundreds of time. I feel stupid. -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 457832] Net worth report displays incorrect account balance
https://bugs.kde.org/show_bug.cgi?id=457832 --- Comment #4 from Ceaus --- (In reply to Ceaus from comment #3) > (In reply to Thomas Baumgart from comment #2) > > In your description I simply replaced step 7 with > > 7. Configure report R1. Press Apply w/o any changes and the report is shown > > correct. > > Same here. Just to be aware: this is for this debug data file. In my original financial file this doesn't work. If tried changing the reporting start/end dates, change the storage type (kmy/xml/sql), but that trick doesn't work. Still a lagging account balance, while the balance should already be zero. > > If I save the file and then try to reproduce the problem it is gone. > > Same here. See above. Just to remove all doubt: I'm now trying the AppImage version kmymoney-5.1-179-linux-64-gcc.AppImage (that's the latest Jenkins successful build from https://binary-factory.kde.org/view/AppImage/job/KMyMoney_Release_appimage-centos7/. The results and behavior are the same. -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 457832] Net worth report displays incorrect account balance
https://bugs.kde.org/show_bug.cgi?id=457832 lp.allar...@gmail.com changed: What|Removed |Added CC||lp.allar...@gmail.com --- Comment #5 from lp.allar...@gmail.com --- @Ceaus, please look at bug ticket https://bugs.kde.org/show_bug.cgi?id=450653 and see if its the same issue or not. I already reported something similar a while ago regarding balances in reports. -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 457832] Net worth report displays incorrect account balance
https://bugs.kde.org/show_bug.cgi?id=457832 --- Comment #6 from Ceaus --- (In reply to lp.allard.1 from comment #5) > @Ceaus, > > please look at bug ticket https://bugs.kde.org/show_bug.cgi?id=450653 and > see if its the same issue or not. 450653 certainly has similarities. But it's out of my reach to conclude they are the same bug. -- You are receiving this mail because: You are the assignee for the bug.
