Bug 427541 - Report Filter Bug
Summary: Report Filter Bug
Status: CONFIRMED
Alias: None
Product: kmymoney
Classification: Applications
Component: reports (show other bugs)
Version: 5.1.0
Platform: Mint (Debian based) Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-11 12:14 UTC by Mark Medoff
Modified: 2021-09-03 21:12 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
mark.anon.xml (1.51 MB, text/xml)
2020-10-11 14:21 UTC, Mark Medoff
Details
attachment-25269-0.html (1.76 KB, text/html)
2020-11-20 17:33 UTC, Mark Medoff
Details
Test.kmy (143.85 KB, application/x-kmymoney)
2020-11-25 15:00 UTC, Mark Medoff
Details
attachment-23845-0.html (3.44 KB, text/html)
2020-11-29 10:27 UTC, Mark Medoff
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Medoff 2020-10-11 12:14:44 UTC
SUMMARY
If I select the "Transactions By Category" Report, it correctly lists transactions for all accounts, including investment accounts. If I filter out any investment account, none of the investment accounts appear on report.

STEPS TO REPRODUCE
1. Select "Transactions By Category" Report
2. Run report and observe output accounts
3. Filter out an investment account

OBSERVED RESULT
None of the remaining investment accounts appear on report

EXPECTED RESULT
Non-filtered investment accounts should remain on report

SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma:
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
Comment 1 Thomas Baumgart 2020-10-11 13:38:43 UTC
Can you setup and attach to this bug a sample file that shows the problem? That would be very much appreciated.
Comment 2 Mark Medoff 2020-10-11 14:21:10 UTC
Created attachment 132275 [details]
mark.anon.xml

This is very strange.

I created the anonymous file. I went to my saved report in that file which
was now called R000002. I ran it and it ran as if none of the investment
accounts were selected even though it had been created with 1 investment
account un-selected. I then selected all investment accounts and the report
didn't change. It remained with investment transactions missing.

I then created a new report with same criteria and this Transactions by
Category (Customized) report operates as in my original bug report.

I have attached the anonymous file.

Thanks for giving this such prompt attention,
Mark

On Sun, Oct 11, 2020 at 9:38 AM Thomas Baumgart <bugzilla_noreply@kde.org>
wrote:

> https://bugs.kde.org/show_bug.cgi?id=427541
>
> Thomas Baumgart <tbaumgart@kde.org> changed:
>
>            What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>          Resolution|---                         |WAITINGFORINFO
>              Status|REPORTED                    |NEEDSINFO
>
> --- Comment #1 from Thomas Baumgart <tbaumgart@kde.org> ---
> Can you setup and attach to this bug a sample file that shows the problem?
> That
> would be very much appreciated.
>
> --
> You are receiving this mail because:
> You reported the bug.
Comment 3 Bug Janitor Service 2020-10-26 04:33:23 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 4 Thomas Baumgart 2020-10-26 07:53:37 UTC
Switching status back to reported. No time yet to look into the problem itself.
Comment 5 Thomas Baumgart 2020-11-20 17:30:53 UTC
I am having a hard time to understand what is going on. The said report R000002 is a 'tax transactions by category' report which differs from the 'transaction by category' report. Also, I am unable to find the report you created to show the problem.

It would be good if you can also attach the HTML output of the report you see based on the anonymous file and provide one or two transactions that you think are missing. Without more information I am not seeing the forest for the trees here.
Comment 6 Mark Medoff 2020-11-20 17:32:59 UTC
Created attachment 133503 [details]
attachment-25269-0.html

Ok. I'll get back to you with it in next few days.

On Fri, Nov 20, 2020, 12:30 PM Thomas Baumgart <bugzilla_noreply@kde.org>
wrote:

> https://bugs.kde.org/show_bug.cgi?id=427541
>
> Thomas Baumgart <tbaumgart@kde.org> changed:
>
>            What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>          Resolution|---                         |WAITINGFORINFO
>              Status|REPORTED                    |NEEDSINFO
>
> --- Comment #5 from Thomas Baumgart <tbaumgart@kde.org> ---
> I am having a hard time to understand what is going on. The said report
> R000002
> is a 'tax transactions by category' report which differs from the
> 'transaction
> by category' report. Also, I am unable to find the report you created to
> show
> the problem.
>
> It would be good if you can also attach the HTML output of the report you
> see
> based on the anonymous file and provide one or two transactions that you
> think
> are missing. Without more information I am not seeing the forest for the
> trees
> here.
>
> --
> You are receiving this mail because:
> You reported the bug.
Comment 7 Mark Medoff 2020-11-25 15:00:14 UTC
Created attachment 133647 [details]
Test.kmy

OK. I understand.
I created a new file called Test which I have attached to this email.

I label an account as a taxable trading brokerage account and put data in
it, including the taxable categories of capital gains.
I created a second brokerage account for tax deferred retirement and also
put transactions against it.

I created two custom reports. The two reports are identical except that one
report filters for all accounts and one report uses a filter to remove the
tax deferred retirement account.
The "all accounts" version of the report shows all income transactions
including the capital gains ones.
The "non-retirement account" version of the report no longer shows the
capital gains in the taxable investment account even though the filter did
not remove this account.

Hope this shows the problem I have found.

Mark

On Fri, Nov 20, 2020 at 12:30 PM Thomas Baumgart <bugzilla_noreply@kde.org>
wrote:

> https://bugs.kde.org/show_bug.cgi?id=427541
>
> Thomas Baumgart <tbaumgart@kde.org> changed:
>
>            What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>          Resolution|---                         |WAITINGFORINFO
>              Status|REPORTED                    |NEEDSINFO
>
> --- Comment #5 from Thomas Baumgart <tbaumgart@kde.org> ---
> I am having a hard time to understand what is going on. The said report
> R000002
> is a 'tax transactions by category' report which differs from the
> 'transaction
> by category' report. Also, I am unable to find the report you created to
> show
> the problem.
>
> It would be good if you can also attach the HTML output of the report you
> see
> based on the anonymous file and provide one or two transactions that you
> think
> are missing. Without more information I am not seeing the forest for the
> trees
> here.
>
> --
> You are receiving this mail because:
> You reported the bug.
Comment 8 Jack 2020-11-29 01:06:24 UTC
I see what you're talking about, but it's not as obvious as it might be, because you have Taxable Capital Gains (both short and long term) in the Non-taxable Retirement account, as well as A000134 and other investment accounts with Taxable Trading Account as the brokerage account.  This is not wrong, but just confusing.

It's also easy enough to reproduce with this file - start with the tax transactions by category, then configure the report - filters - accounts, and uncheck either the Non-taxable Retirement account or the associated brokerage account.  Filtering out either of them removes the taxable capital gains categories from the report.  Also - the same thing happens starting with Transactions by Category, so it's not specific to the Tax related report.  It is also a bit easier to note by excluding all the expense categories from the report, which just shortens the report.

Just to help anyone else focus on the problem, there are three transactions with short term capital gains.  The last two (for A000162 and A000154) are from the Non-taxable Retirement account, but the first (for security A000180) is in A000134, an investment account using Taxable Trading Account for it's brokerage.

Also - if you filter out the Taxable Trading Account, but include the Non-taxable accounts, the capital gains categories are again not shown on the report.

Summary - there are two brokerage accounts, both of which have transactions with two particular categories (short and long term capital gains).  The default transaction by category report shows all transaction in those two categories.  However, if you filter out either brokerage account (or the associated investment accounts) in the report configuration, NONE of the capital gains categories are shown on the report.

It will take some digging to figure out exactly what is going on.
Comment 9 Mark Medoff 2020-11-29 10:27:18 UTC
Created attachment 133721 [details]
attachment-23845-0.html

Thanks.
For convenience, I created a single capital gains category to use in
taxable and non-taxable accounts with the intention of filtering out the
non-taxable accounts on tax reports.

Mark

On Sat, Nov 28, 2020 at 8:06 PM Jack <bugzilla_noreply@kde.org> wrote:

> https://bugs.kde.org/show_bug.cgi?id=427541
>
> Jack <ostroffjh@users.sourceforge.net> changed:
>
>            What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>          Resolution|WAITINGFORINFO              |---
>      Ever confirmed|0                           |1
>              Status|NEEDSINFO                   |CONFIRMED
>
> --- Comment #8 from Jack <ostroffjh@users.sourceforge.net> ---
> I see what you're talking about, but it's not as obvious as it might be,
> because you have Taxable Capital Gains (both short and long term) in the
> Non-taxable Retirement account, as well as A000134 and other investment
> accounts with Taxable Trading Account as the brokerage account.  This is
> not
> wrong, but just confusing.
>
> It's also easy enough to reproduce with this file - start with the tax
> transactions by category, then configure the report - filters - accounts,
> and
> uncheck either the Non-taxable Retirement account or the associated
> brokerage
> account.  Filtering out either of them removes the taxable capital gains
> categories from the report.  Also - the same thing happens starting with
> Transactions by Category, so it's not specific to the Tax related report.
> It
> is also a bit easier to note by excluding all the expense categories from
> the
> report, which just shortens the report.
>
> Just to help anyone else focus on the problem, there are three transactions
> with short term capital gains.  The last two (for A000162 and A000154) are
> from
> the Non-taxable Retirement account, but the first (for security A000180)
> is in
> A000134, an investment account using Taxable Trading Account for it's
> brokerage.
>
> Also - if you filter out the Taxable Trading Account, but include the
> Non-taxable accounts, the capital gains categories are again not shown on
> the
> report.
>
> Summary - there are two brokerage accounts, both of which have transactions
> with two particular categories (short and long term capital gains).  The
> default transaction by category report shows all transaction in those two
> categories.  However, if you filter out either brokerage account (or the
> associated investment accounts) in the report configuration, NONE of the
> capital gains categories are shown on the report.
>
> It will take some digging to figure out exactly what is going on.
>
> --
> You are receiving this mail because:
> You reported the bug.
Comment 10 Jack 2021-09-03 21:12:18 UTC
Not sure how this got set to "critical" but changing to "normal"
Also, please note that when you reply to a bug by email, your ENTIRE email becomes the next comment, so please consider removing anything that doesn't need to be in the new comment.