MD 2022 Build 4060 - Transaction Filter report with inverted amount signs

george.dobbs's Avatar

george.dobbs

29 May, 2021 11:19 PM

Greetings,

I have a saved transaction filter that quit subtotaling properly with 2021.1 (3069). I select

A single account
custom date range
Memo field
and subtotal by category.

I get the right records but the subtotaling first seems to be within each day. (see sales tax on 4/19 in attached)

Could you please take a look and see if you can duplicate this problem. Or suggest what I'm doing wrong if no trouble is found?

Thank you,
George Dobbs

  1. 1 Posted by mhoggie on 30 May, 2021 09:27 PM

    mhoggie's Avatar

    just a user,

    Yeah, does the same for me. I hate to see that. It was the only report where you could subtotal by category.

  2. 2 Posted by dwg on 30 May, 2021 09:42 PM

    dwg's Avatar

    Sean has been working on the transaction filter report, perhaps it is still not quite right:

    https://infinitekind.tenderapp.com/discussions/problems/55270-transaction-filter-report

  3. 3 Posted by Stuart Beesley ... on 02 Jun, 2021 08:57 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I agree, the report is not sorting before subtotalling the category....

  4. 4 Posted by macalves1 on 04 Jun, 2021 08:43 AM

    macalves1's Avatar

    To my knowledge, beta version 3064 is the last one properly working when it comes to transaction filters grouped by category.

  5. Support Staff 5 Posted by Maddy on 05 Aug, 2021 03:03 PM

    Maddy's Avatar

    @All

    Upgrading to the latest preview version should hopefully fix the problem reported in this thread.

    Moneydance 2021.2 (3089) is now available to download from this page.

    For a full list of improvements in the preview version, please refer to this page.

    I hope this information is helpful. Please let us know if you have further questions or need more assistance.

    --
    Maddy, Infinite Kind Support

  6. 6 Posted by macalves1 on 05 Aug, 2021 03:27 PM

    macalves1's Avatar

    Hi,

    Unfortunately, the problem persists in 3089.
    Please see attached screenshots.

    Back to 3064 is still the only working option when it comes to transaction
    filters.

    Best regards,
    Marco Alves

  7. 7 Posted by macalves1 on 10 Aug, 2021 09:56 AM

    macalves1's Avatar

    Hi,

    Today I've tried the latest beta (3092) but, the issue remains unsolved...

    Best regards,
    Marco Alves

  8. 8 Posted by george.dobbs on 22 Aug, 2021 06:08 PM

    george.dobbs's Avatar

    Looks like preview version 2021.2 (3095) still has the same problem.

    Regards
    George Dobbs

  9. 9 Posted by macalves1 on 28 Sep, 2021 06:52 PM

    macalves1's Avatar

    Hi,

    Today I've tried latest beta (4040) and while there was some improvement some work remains to be done: subtotals by category work only on a monthly basis. So, instead of collecting all transaction, for a given category, for the entire selected period, the report groups categories on each month.

    I've attached screenshots with settings and results.

    Went back to the 3064 version where the report feature is fine.

    Regards
    Marco Alves

  10. 10 Posted by macalves1 on 28 Sep, 2021 06:53 PM

    macalves1's Avatar

    And now the report..

  11. 11 Posted by Stuart Beesley ... on 29 Oct, 2021 08:20 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Preview 4060:
    * Fix category grouping and other bugs in the Transaction Filter report

  12. 12 Posted by macalves1 on 30 Oct, 2021 03:47 PM

    macalves1's Avatar

    Build 4060 almost nailed it (grouping by category is now fixed) but while amounts transferred into/out-of an account have the right signals (in+; out-) category amounts come with inverted signals (expenses as positive and income as negative).

  13. Support Staff 13 Posted by Maddy on 01 Nov, 2021 10:59 AM

    Maddy's Avatar

    @Marco

    Are you using the same settings as displayed in the screenshot on post 9 of this thread?

    --
    Maddy, Infinite Kind Support

  14. 14 Posted by macalves1 on 01 Nov, 2021 11:39 AM

    macalves1's Avatar

    Hi,

    I used this one (all accounts; This year)
    [image: image.png]

  15. Support Staff 15 Posted by Maddy on 01 Nov, 2021 11:59 AM

    Maddy's Avatar

    Please can you send us your Moneydance error logs? They are saved on your computer as an errlog.txt file.

    You can get to your error logs as follow:

    Navigate to Help->Console Window to show the console log in a window while you are attempting to generate your Transaction Filter report

    Finally you can paste the full content to your next reply.

    Thank you

    --
    Maddy, Infinite Kind Support

  16. 16 Posted by macalves1 on 01 Nov, 2021 12:38 PM

    macalves1's Avatar

    Hi,

    I've attached a file with settings, report (sample and notes) and logs.
    Hope it helps.
    Please note that I mainly use 3064 build so I installed 4060 just to test
    the report.

    Best regards,
    Marco

  17. 17 Posted by macalves1 on 02 Nov, 2021 11:49 PM

    macalves1's Avatar

    Hi,

    I must correct my notes: transfers into/out-of accounts have inverted signals as well.

  18. 18 Posted by JonL on 04 Nov, 2021 10:08 PM

    JonL's Avatar

    I am also experiencing this problem of inverted signals. I use a transaction filter to produce a list of transactions that I then 'Save as Comma Delimited'. The resulting file is imported into other software for analysis. Now it's clear that some transactions have the incorrect sign. I haven't drilled down into the file to find out what the problem is, but it's clear that the sign of transactions has changed through recent updates.

    Really need this fixed since I rely on the analysis of these transactions to manage month to month!

    Jon

  19. Support Staff 19 Posted by Maddy on 05 Nov, 2021 09:35 AM

    Maddy's Avatar

    @All Thanks for letting us know about this issue!
    I've filed a ticket in our ticketing system and the developers will be looking into it.

    Please let us know if we can be of further assistance!

    --
    Maddy, Infinite Kind Support

  20. 20 Posted by Stuart Beesley ... on 15 Nov, 2021 09:48 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Try 2022.3(4061)

  21. Support Staff 21 Posted by Maddy on 15 Nov, 2021 11:46 AM

    Maddy's Avatar

    @All

    Upgrading to the latest preview version should hopefully fix the problem for you.
    Moneydance 2022.3 (4061) is now available to download from this page.

    For a full list of improvements in the preview version, please refer to this page.

    --
    Maddy, Infinite Kind Support

  22. 22 Posted by macalves1 on 16 Nov, 2021 02:17 AM

    macalves1's Avatar

    Hi,

    Yes, with build 4061 this issue seems resolved.

    Thank you!

  23. 23 Posted by JonL on 16 Nov, 2021 10:36 AM

    JonL's Avatar

    Many thanks. Problem solved. Jon

  24. Maddy closed this discussion on 16 Nov, 2021 01:09 PM.

  25. System closed this discussion on 15 Feb, 2022 10:40 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac