Me too! It's a quirk (report bug perhaps?) in the way that splits are handled. The split Memo is sitting on on the split, which exists in the 'other' side of the txn. The other side is sitting in the category (which is actually an Account under the covers) that you specified. Thus, if you change the options to OR, I think you will find it appears (along with other real accounts you didn't want that also have Memos with the same name you are filtering). Best bet is to extract all to spreadsheet.
I can find the hidden split entry by using search from the summary page, but it showas the full amount, not just ths split item. When I generate report the whole entry is dropped. So as far as I can see there is no way to suck out all the memos from two accounts if one is a hidden split. If this is true, is there another way I could reference these entries so I CAN get them out?
What version of MD do I need? Am on MD 2021 (2006) and latest Mojave / Mac. Also asked about this for the extract reminders script / extension by mistake as I have that working fine as a script at present.
Still not finding that hidden split where one split has no memo and the other X20. The amount is £30.95 for the entry, but only one of the splits has X20 as a memo. None of that entry id found with the script. Hope that’s clear as mud?
That's a bug! Haha... How funny that a bug in my code gave you the same problem as the standard reports.... It's the difference between a 'break' and a 'continue' (but hey I was hoping for a break!!). I reproduced the problem with your data and I have fixed the issue (quite rare dataset).. updated build 5 attached. Let me know? S
It now finds the entry with two splits, one with and one without memo = X20. Unfortunately it only shows the total amount of the entry, not just the split part.
Would it be possible for this to be done? Also, would be great if splits showed in spreadsheet? Maybe just too much to hope for. I am no coder so really have no idea what I am talking about - a load of work no doubt if a) possible and B) worth it!
Anyway, whatever, thanks for all your hard work, quick responses and continued efforts on our behalf.
Hi, there are two columns. The first is total amount and then there is split amount. Have you looked at this split amount column? The splits are in the spreadsheet in the splits columns...? Let me know?