[GNC] Find or search all expenses in a certain account

[Adrien Monteleone]

That was the right criteria. I’m not sure why it isn’t working for you.

Maybe I missed something, but you noted earlier that you have 10 transactions that are transfers and are fixed properly. You want to delete everything else in AccountA.

Doing a search for ‘everything else’ seems to be overkill. (especially at this point) Can’t you just do one of the following:

1. Delete every transaction starting from the top, but mindful to skip the 10 transfers.

2. Delete AccountA entirely, re-create it and re-create the 10 transfer transactions.

If there are transactions in AccountA other than the transfers you don’t want to delete, then skip them too. If there are too many and there are only *some* expense transactions you want to delete, then do those one-by-one.

I think this is a case where you probably could have trudged through it and been finished by now. (Though the challenge is always fun)

Another approach is to open the expense registers you want to deal with, do a search for “All Accounts” that match AccountA - delete those transactions, proceed to the next expense account. Rinse, repeat.

Regards,
Adrien

> On Mar 9, 2020 w11d69, at 9:54 PM, Gio Bacareza <gbacareza at gmail.com> wrote:
> 
> Hi Adrien,
> 
> see below:
> 
> On Mon, Mar 9, 2020 at 11:54 PM Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:
> Gio, as per the other thread, and John’s advice here, you’re still missing a setting change for criteria search.
> 
> If you are referring to the criteria: "any criteria are met" I have actually included that in my first set of tests but concluded that they did not differ. So I concluded that this criteria only works when you have more than 1 search criteria after doing an "Add" button. Believe me I tried to be as exhaustive as possible. See screenshot of earlier result below:
> <image.png>
> 
> If this is not the criteria you were referring to pls let me know.
>  
> 
> Looking at the chart in your GoogleDoc, the only combo that is relevant is the last pair.
> 
> Actually the relevant results I found were "test find account + 1 expense". And the only conditions that work are:
> Window -> Criteria01 -> Criteria02 -> Choose Accounts
> Accounts -> All Accounts -> matches all accounts -> "test find" account + 1 expense
> Account Window -> All Accounts -> matches all accounts -> "test find" account + 1 expense
> Account Window -> All Accounts -> matches all accounts -> 1 expense
> 
> However, I concluded that this is not optimal for what I'm trying to achieve since that means I have to do it 1 by 1 to all expense accounts relevant to the account I'm trying to correct. It's doable but is so cumbersome. So I was hoping a select ALL expense or even multiple select will do.
> 
> Multiple-select could have been a manageable compromise but alas it also doesn't work. See screenshots:
> Search = 
> <image.png>
> Results =
> <image.png>
> 
>  
> 
> 1. Conduct the Find from the Account Register in question. (so far referred to as AccountA, or test_find in your Doc)
> 2. Use an All Accounts criteria
> 3. The only middle option here is to ‘match all accounts’ you can’t choose anything else.
> 4. Select either a single target expense account, or multiples. (try with just one first)
> **5. In the upper right hand corner, above the criteria, you need to change the setting labeled “Search for items where” to “any criteria are met” (the default is ‘all criteria are met’)
> 
> Do not include AccountA/test_find in your account selection, you are already doing a Find from within that register.
> 
> You should get proper results. I’ve tried this sequence several times with different accounts and for each one I’m getting the expected results and I’ve verified them looking over the register in question.
> 
> I've tried this many times too. It only works, as mentioned above, when one and only expense transaction is selected.
> 
> When selecting MORE than 1 or selecting ALL, it returns blank. see above screenshot.
> 
> What else am I missing?