Transaction Filter Report and Memo field

baron48us's Avatar

baron48us

17 May, 2024 04:23 AM

I upgraded to 2024 version and discovered that all my Transaction Filter reports that search based on Memo field no longer have anything in the report. Are we no longer able to do Transaction Filter reports based on the Memo field? I know there are other ways to do this with tags, but that might be substantial work to update all my reports. I can do advanced search and use the Memo field as a search parameter and it works, but when I use the "Generate Report" field, the report is empty.

  1. 1 Posted by dwg on 17 May, 2024 05:03 AM

    dwg's Avatar
  2. 2 Posted by michael on 10 Aug, 2024 08:15 AM

    michael's Avatar

    Ive reported this issue twice but havent had any kind of response.

    Whats going on?

  3. 3 Posted by dtd on 10 Aug, 2024 11:17 PM

    dtd's Avatar

    Appears a lot of activity in just the past week or so.... fixes to Transaction Filter/Memo fields due out in soon to be released 5144

  4. 4 Posted by sth on 11 Aug, 2024 12:07 AM

    sth's Avatar

    Works for me. Build 5142. Searched for Dividend in memo field got a LOT of hits.

  5. 5 Posted by Stuart Beesley ... on 11 Aug, 2024 06:42 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Basically I beleive it would have (probably) worked on account to account txfrs, but unlikely where a category was involved.

    Never-the-less, it’s been fixed for the next alpha / preview.

  6. 6 Posted by sth on 11 Aug, 2024 02:46 PM

    sth's Avatar

    @Stuart, just FYI, almost all the found memos were income in the dividend category, not account -> account transfers. Unless it was confusing category with dividend.

  7. 7 Posted by Stuart Beesley ... on 11 Aug, 2024 04:00 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Oh well, it’s some odd scenario. Never the less it’s broken.

  8. 8 Posted by Stuart Beesley ... on 19 Aug, 2024 09:09 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    FYI. In PREVIEW 5145 there is now an option to the right of the description field to tick and enable the search to also search the memo field(s). Ie it will search both description and memo field(s) in one filter (rather than two separate filters). This should avoid confusion on which field to filter and will allow better use or and/or criteria.

    (Note: I haven’t personally tested this yet)

  9. 9 Posted by michael on 19 Aug, 2024 10:28 AM

    michael's Avatar

    Stuart

    Seems to work as does entering the required narrative in the Memo box without ticking the "include Memo" box.

    Michael

    [email blocked]<mailto:[email blocked]>

    +447850 855555

  10. 10 Posted by michael on 19 Aug, 2024 10:32 AM

    michael's Avatar

    Stuart

    Are you aware of any progress on Open Banking for use with UK Banks?

    Michael

    [email blocked]<mailto:[email blocked]>

    +447850 855555

  11. 11 Posted by michael on 19 Aug, 2024 11:01 AM

    michael's Avatar

    Stuart

    Forget I said it works - it doesn't! At least not always.

    I managed to get it to run correctly for the words "DIVIDEND REIT" but it returned nothing at all for the words "DIVIDEND TRUST" which it should have done.

    I tried both with separate MEO field entries and ticking the box but naddah!! The newly created identical report for Reit Dividends works correctly.

    Still broken I think

    If you still have my data try it on that for yourself

    regards

    Michael

    [email blocked]<mailto:[email blocked]>

    +447850 855555

  12. 12 Posted by Stuart Beesley ... on 19 Aug, 2024 11:19 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    U.K. banks 🤷

  13. 13 Posted by dwg on 19 Aug, 2024 11:50 AM

    dwg's Avatar

    As a side note I do not see Moneydance ever being directly involved with Open Banking.

    The requirements I see in Australia generally preclude a smaller company getting directly involved. Open Banking also means country by country involvement. Hence I would expect that Moneydance will have to use an aggregator that does the leg work and incurs the costs to become and remain an approved data recipient in various countries.

    I have not seen any recent comments on the progress of Moneydance+ support outside of North America.

  14. 14 Posted by michael on 19 Aug, 2024 12:05 PM

    michael's Avatar

    Memo lookup didn’t work in 5145 but 5146 popped up immediately and that seems to work!

    Michael

    [email blocked]<mailto:[email blocked]>

    +447850 855555

  15. 15 Posted by michael on 19 Aug, 2024 12:06 PM

    michael's Avatar

    I know they were looking to use PLAID as Sage do but it was too expensive.

    Michael

    [email blocked]<mailto:[email blocked]>

    +447850 855555

  16. 16 Posted by Stuart Beesley ... on 19 Aug, 2024 12:11 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Strange as that (desc/memo search) did not change between 5145 and 5146. So, are you sure it’s working ok?

  17. 17 Posted by dwg on 19 Aug, 2024 12:28 PM

    dwg's Avatar

    Yes Plaid proved to be not a viable solution outside of North America.

    I'm sure price was an issue but also looking at Plaid they support very few countries so they do not really have the sort of coverage that a program like Moneydance needs.

  18. 18 Posted by Stuart Beesley ... on 19 Aug, 2024 02:06 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    @Michael - strange. I tested your searches on your dataset and both memo and the desc (with memo ticked) worked OK...

  19. 19 Posted by michael on 19 Aug, 2024 03:11 PM

    michael's Avatar

    Stuart

    I couldn't make it work on 45 but it definitely works on 46 - also it was 46 that had the memo tick box option noted in the change log

    Michael

    [email blocked]<mailto:[email blocked]>

    +447850 855555

  20. 20 Posted by Stuart Beesley ... on 19 Aug, 2024 03:35 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I suspect you thought you had updated, but hadn't.... 😉

  21. 21 Posted by michael on 19 Aug, 2024 04:13 PM

    michael's Avatar

    Wouldn't be the first time!

    On 19 August 2024 16:35:28 "Stuart Beesley (Mr Toolbox)" <[email blocked]> wrote:

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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