Please accept my sincere apologies for the delay getting back to you. I’m afraid that your request for assistance was missed by the support team, and it’s only now we’ve been able to work through the backlog of older discussions. I must apologise again for the poor level of service and lack of support you have received. I’d like to provide assistance if you’re still in a position to work through these issues.
Would it be possible for you to try upgrading to the latest preview release of Moneydance from here:
I just checked in the very latest version (2017.8) and the problem is still there. If I run a transaction filter report AND check that I want to include sub-accounts, the Sub-account values come out as +ve whereas the parent account comes out as -ve !
Which makes the totals completely wrong! (cos the positive and negative values cancel each other)
This potentially a very useful report - but this makes it near useless. I have to copy the figures out to excel total them - not good. What am I missing here?
@musto102 thank you for the screenshot. Would it be possible for you to share your current version and build number of Moneydance?
To do this, open Moneydance and select Help --> About Moneydance (or Moneydance --> About Moneydance on a Mac) where the version and build number will be displayed.
@al and @mhoggie Do you both also still see the same issue?
I can't see where the problem lies with this (and I have also tried the preview release).
If I run the report on only the sub-category, it correctly shows these all as debit expenses. But if I run the report on the main category and include sub-categories, then these sub items are shown as credits.
The only clue I can offer is that these items are listed with the Category name in the Account field while all the others are bank accounts. See screen shot.
I think I can reproduce what Ralph is pointing out.
I am running MD build 1704 on W7 64 and I have attached an example of the issue.
I have all my credit cards under a "Credit Card" parent category and I ran the "transaction filter" report with the parent category "Credit Card" as the Account/Category filter with "show sub accounts" selected.
You will notice the "categories" are listed under the "Account" header and the "accounts" are listed under the "Category" header. Also note that the credit card debits are shown as positive amounts. But interestingly the one credit card payment from checking is shown as a positive amount even though the one rebate transaction is show as a negative amount. There are some known issues with the "Transaction Filter" report and I think they may be related to the single search field "Account/Category" I have seen other search discrepancies when leaving the "Account/Category" blank. I think that search field needs to be expanded to have a separate "Account" and "Category" field as used with the "Find and Replace" extension. Although accounts are in one respect a special type of category in MD, you have to acknowledge the difference in the MD reports or things get a bit messy. I think that is the root of the issue.
I still have this problem with the transaction report.
It has now been an issue for over 3 years!
Basically the transaction report is broken when it uses sub-accounts as this causes the values to be negative and therefore the totals are wrong. I can provide numerous examples.
This makes a very useful report not very useful.
Yes I am on the latest version of MD (1915) and it still works the same way.
Is anyone fixing this?