Find & Recode search misses some transactions

1

I am trying to use Find & Recode. Up until now, it has worked fine. But now I have a situation that I don’t understand.

I want to recode a number of payments, all of which contain a certain string in the Description field. When I open the Payments tab and enter this string in the search field, I see those payments, among others. Fine.

But when I then want to recode those transactions, and enter the same string in the search field of the Search & Recode function for payments, I only see transactions that have the string in the Account field, not the transactions I want to recode, which have them in the Description.

I hope I am clear.

Is this behavior intentional? Am I missing something?

Thanks for any insights on this!

PS On currently latest version, 25.8.16.2610 on macOS.

2

Hello @jeroen1,

No. In fact, it’s not the normal.

And unfortunately, I can’t reproduce this issue on version 25.8.17.2617.

I’m not sure whether this is a temporary bug in your version that has already been fixed, or if it’s something to do with the sorting of transaction listing.

Sorting could well be the source of this anomally, especially since Find & recode table cannot be sorted.

In any case, it would help if you posted a couple of screenshots so we can see the unexpected behavior you’re experiencing.

3

Thank you @Ealfardan for thinking with me.

I am doing a few experiments to try and decide what it is that prevents those transactions from showing up in the Find & Replace table. The funny thing is that some payments (01-06-2025) do show up and I am trying to determine what might cause the difference. So far I have found that it makes a difference to what account they are currently assigned. Both accounts in the example (“Overige uitgaven - overig” and “Apotheek”) are expense accounts and I see no difference in their properties.

Thank you so far, and I will let you know if and when I have found out more. In the meantime, all suggestions are welcome.

Enclosed: screenshots of payment list (filtered on the search string “lijs”) and of the find/replace table. The payment of 21-09-2020 is present in the payment list, but not in the find/replace list.

paymentlist 1
paymentlist 12942×2592 716 KB

payment list bottom
payment list bottom2942×2592 619 KB

findreplacelist top
findreplacelist top2942×2592 602 KB

findreplacelist 2
findreplacelist 22942×2592 485 KB

4

Another difference between the two tables is this:

  • Payments tab shows the top level data, meaning, it will only show 1 line per payment and that is the line with the Cash or Bank Account affected

  • Find & recode on the other hand will not show the top-level Cash or Bank Account. Instead, it will show you the other Payments - Lines.

  • Also, in case the Line Descriptions were written differently from the top-level Description field, those wouldn’t match as well.

A better approach would be to compare Payment - Liness to Find & recode since the latter is a subset of all payment lines.

5

Thanks @Ealfardan, that solves it for me. I thought the matching would be on Description, but it is actually on Line Description. Which, with hindsight, makes sense because it is the line you are recoding, not the transaction as a whole (if it has multiple lines).

And looking at Payments - Lines is the way to view the Line Description. I was not aware of that option.

I can take it from here. Thanks again.

1 Like