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

[Gio Bacareza]

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: 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: image.png]
Results =
[image: 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?


>
> Regards,
> Adrien
>
> > On Mar 9, 2020 w11d69, at 12:09 AM, Gio Bacareza <gbacareza at gmail.com>
> wrote:
> >
> > Hi John, I tried your recommendation. I actually tried to test all
> > scenarios I can think of (I can't help myself). Unfortunately, it still
> > does not produce the result I want.
> >
> > I'm sharing the results and details of what I did here. Google Docs here
> >
> https://docs.google.com/document/d/16-4oAiKGfULuI0GJXV73JUx6dv7aLk5mjYDAAo3FK5E/edit?usp=sharing
> >
> > or if you prefer PDF here
> >
> https://docs.google.com/document/d/16-4oAiKGfULuI0GJXV73JUx6dv7aLk5mjYDAAo3FK5E/edit?usp=sharing
> >
> > Is there anything I am 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 134857 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200310/223e2e02/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 358428 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200310/223e2e02/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 16673 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200310/223e2e02/attachment-0011.png>