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

[Gio Bacareza]

I'll give it a try. Thanks Adrien

On Tue, Mar 10, 2020 at 11:41 AM Adrien Monteleone <
adrien.monteleone at lusfiber.net> wrote:

> 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?
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
cheers,

Gio