Bug 475603

Summary:	Net worth reports do not consider investment values if an account (any account) is filtered
Product:	[Applications] kmymoney	Reporter:	Jamariano <jamariano>
Component:	reports	Assignee:	KMyMoney Devel Mailing List <kmymoney-devel>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	NOR
Version:	5.1.3
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed In:	5.2
Sentry Crash Report:
Attachments:	Kmymoney sample file to reproduce bug

Description Jamariano 2023-10-14 12:19:12 UTC

SUMMARY

The net worth report works fine as long as you do not use the filter by account functionality. If you filter by account (that is, selecting one or many accounts to be excluded from the report), then the report will simply forget about the investments, not taking them adding them into the total value. If you go back and select ALL accounts again, the final result is correct once again. This behaviour is not happening in version 5.0.6 for windows

STEPS TO REPRODUCE
1. Reports  --> Net Worth --> Net worth by month
2. Check the result
3. Configure --> Filters --> Account --> Uncheck ANY account
4. Check the result, it will differ from #2 in the value of investments


SOFTWARE/OS VERSIONS

Version: 5.1.3-dfb75418c
Linux: Ubuntu 22.04.3 LTS 22.04 (x86_64)
KDE Frameworks: Versión 5.104.0
Qt Version: Versión 5.15.8

Comment 1 Jamariano 2024-02-02 11:26:30 UTC

Created attachment 165472 [details]
Kmymoney sample file to reproduce bug

The sample file has only a checking account (€4.500) and a structure of investment accounts. There are 2 securities (a mutual fund and a bond). They have a value of €5.500.

If you run the "net worth by year" report, total net worth is €10.000. This is correct.
If you run the "net worth by year-customized" report, total net worth is €10.000. Same info as before, but with full detail. This is correct.

If you now configure the report to exclude the checking account from the report, the net worth is 0, instead of €5.500 as expected. And now in the filter list, none of the securities are shown.

Comment 2 Thomas Baumgart 2024-07-13 14:00:16 UTC

This has been fixed in the meantime in the current development (master) version of the application. When loading the sample file, no account is selected for the customized report and the values show zero. Pressing the All button in the report's account filter tab solved that issue. Unchecking the Checkings account shows the correct values. So I close this here as fixed.

Comment 3 Jamariano 2024-08-19 10:08:16 UTC

(In reply to Thomas Baumgart from comment #2)
> This has been fixed in the meantime in the current development (master)
> version of the application. When loading the sample file, no account is
> selected for the customized report and the values show zero. Pressing the
> All button in the report's account filter tab solved that issue. Unchecking
> the Checkings account shows the correct values. So I close this here as
> fixed.

I can confirm that it is working in the development version. BIG thank you.