"Hide all" Subcategories in a report doesn't work properly?

Feb 15, 2010 14 Replies

Hi all:



Doing an Income and Expense report by Category and specifying "Show all" for subcategories is working OK. The part of the report that I'm focusing on reads:



Medical Doctors 75.00 Medicine 363.35 Total 438.35



The subcategory amounts ($75.00, $363.35) and Total ($439.35) are correct.



If I run the same report and specify "Hide all" for subcategories this same report reads



Medical 349.56 Medicine 88.79 Total 438.35



The total ($438.35) continues to be correct but obviously that Medicine subcategory shouldn't be showing as a line item. Clicking on the $349.56 brings up a sub-report that lists out the full $438.35 detail of all "Medical," both Doctors and Medicine. Clicking on the $88.79 brings up a sub-report that spells out the detail for the true amount of Medicine, $363.35.



The $88.79 is the total of the *only* 2 Medicine transactions within Medical that are split transactions.



This shouldn't work this way and I'm at a loss as to why it does.



Ideas?



Tom Young


I've been communicating with Quicken Customer Care (my communications are written English, their replies are in Corporate Boilerplate) about this issue and they've decided I need to do the Quicken uninstall/ reinstall bit. Before I go through that I would like to ask if someone with Quicken Deluxe 2007 installed could make 3 entries in a test database and run a couple of reports to see if they duplicate my issue. (I asked Quicken Customer Care - an oxymoron if there ever was one - to do this but Corporate Boilerplate is unable to reply.)

So, in an Investing:Investment account (e.g., brokerage account) I made the following entries:

Enter transaction: Other Cash Transaction Transaction type: Payment Payee: Test Doctor Date: 2/28/2010 Category: Medical:Doctor Amount: $100.00

Enter transaction: Other Cash Transaction Transaction type: Payment Payee: Test Pharmacy Date: 2/28/2010 Category: Medical:Medicine Amount: $50.00

Enter transaction: Other Cash Transaction Transaction type: Payment Payee: Test Split Date: 2/28/2010 Category: (Split) Medical:Medicine Amount: $40.00 Misc Amount: $360.00

If I do a "Reports" > "Spending" > "Income and Expense by Category" with "Advanced" > "Subcategories" > "Show all" on these 3 transactions I get a report like this:

Medical Doctor 100.00 Medicine 90.00 TOTAL Medical 190.00 Misc 360.00 TOTAL EXPENSES 550.00

(If the above doesn't line up very well you can see it here:

formatting link
report is correct. However, if I do the same report with "Advanced" > "Subcategories" >

"Hide all" this is what I get:

Medical 150.00 Medicine 40.00 TOTAL Medical 190.00 Misc 360.00 TOTAL EXPENSES 550.00

(You can also see it here:

formatting link
subcategory "Medicine" shouldn't be there and, while the total ofMedical is correct the Medicine line is incorrect. It seems like thatsplit transaction is somehow confusing Quicken. TIA.

Tom Young

Finally got Quicken Customer Care to make the 3 entries in their "known good" installation of QD2007 and they confirm they are "able to replicate this issue at our end and have forwarded this issue to our product development department for further research."

Tom Young

Are they still releasing updates to 2007?

Translation: As soon as they hung up the phone, they balled up your contact form and tossed it in the garbage can... That is assuming they even wrote anything down in the first place.

Wow! Even given the collapsing standards everywhere, when did fixing bugs become "research" -- all those years of Ph.D. and postdocing for this? ;-)

jg

The whole "product development department for further research" is actually very entertaining.

Remember when janitors became "custodial engineers?"

"forwarded this issue to our product development department for further research:"

Translation: We sent it to India

At least, they do real work there ... though this would still not be 'research'.

sj

According to one definition of research...: "investigation or experimentation aimed at the discovery and interpretation of facts"

I would assume they are going to investigate the problem, and experiment in order to reproduce it.

How refreshing.

A young poster, not yet jaded by the reality if Intuit's total (lack of) support.

Well, I'm not young, nor new to Usenet.

As a long time software engineer (now retired), I can honestly say that I've seen a lot worse than Intuit's support. (Admittedly, I've seen a lot better also.) They make a good product at a very reasonable price. They have to keep costs down in order to remain in business and make some profit. Like others, I am not willing to pay more than I have been paying, so I don't expect too much for my $50 every few years.

I try not to get jaded by little things. There are enough bad, big things in life that come to us all eventually.

Regards Jim

OK, how about young at heart?

The whole sunsetting thing still leaves a bad taste in my mouth.

Why Intuit can't basically leave their product alone (i.e. no more "improvements"), fix the bugs and offer connections services as a subscription-based model is absolutely beyond me.

Cause they are selling more than Quicken or TurboTax. They are selling the whole company and must maintain a certain public image.

I received the following email today from Quicken:

"Dear Tom Young,

Thank you for contacting Quicken Support regarding "Income/Expense by Category report does not show subcategories".

The Advanced option to Show all, or Hide all in the categories, is so the "report layout" does not show the full layout of the sub categories. It does not filter the data from the totals in the report.

For the results to not show the category in the total, you would need to deselect the category or subcategory from the included categories found under the Categories tab of the report settings.

If you have any further questions or concerns, please visit our support site. We apologize for any inconvenience this has caused you.

Sincerely,

Quicken Customer Care"

This poorly written message seems to be suggesting I don't understand how Reports work, not that Reports prepared using Q2007 - in the situation where split transactions have been entered in Investment accounts - are buggy. (And they ARE buggy.)

Or, am I somehow mis-reading Quicken's note?

Tom Young

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required