Re: [GNC] Find or search all expenses in a certain account
Hi, Sorry to respond to an old thread, but I'm catching up on 2 months of emails while I was heads-down on another project.. Gio Bacareza writes: > I'll give it a try. Thanks Adrien > > On Tue, Mar 10, 2020 at 11:41 AM Adrien Monteleone < > adrien.montele...@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: Here's the problem with these approaches. A register is, by definition, the result of a search. Specifically, it is a SPLIT searach where the initial criteria is "split->account == register_account". When you do a FIND from within a register, you are, by definition, limiting your search to the *account splits*. Transfer accounts are, by definition, in *other* splits, not the account splits. The reason is that you get a search query that looks like: Find splits where Split->account == register_account AND ( ... your stuff ... ) So, in short, you can't do what you want from within a register because of the way sub-searches are implemented. The only way to do this search is to start from the CoA and search for transactions' split-accounts that match both A and B. Hope this helps, >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Hi Alton, I'm sorry I shot from the hip and answered before I realized I misunderstood you. Your solution is exactly what I'm following now. Thanks. On Wed, Mar 11, 2020 at 7:31 AM Alton Brantley wrote: > In situations like this, I have usually just moved the 10 or so > transactions from the current account(“AccountX”) to a new account (say > AccountXNew), then delete AccountX, then rename AccountXNew to AccountX. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Hi Alton, I actually tried that at first but I have hundreds of transactions and it became cumbersome fast. Thanks for the suggestion. On Wed, Mar 11, 2020 at 7:31 AM Alton Brantley wrote: > In situations like this, I have usually just moved the 10 or so > transactions from the current account(“AccountX”) to a new account (say > AccountXNew), then delete AccountX, then rename AccountXNew to AccountX. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
In situations like this, I have usually just moved the 10 or so transactions from the current account(“AccountX”) to a new account (say AccountXNew), then delete AccountX, then rename AccountXNew to AccountX. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
I'll give it a try. Thanks Adrien On Tue, Mar 10, 2020 at 11:41 AM Adrien Monteleone < adrien.montele...@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 > wrote: > > > > Hi Adrien, > > > > see below: > > > > On Mon, Mar 9, 2020 at 11:54 PM Adrien Monteleone < > adrien.montele...@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: > > > > > > 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 = > > > > Results = > > > > > > > > > > 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@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 ___ gnucash-user mailing list gnucash-user@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
Re: [GNC] Find or search all expenses in a certain account
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 wrote: > > Hi Adrien, > > see below: > > On Mon, Mar 9, 2020 at 11:54 PM Adrien Monteleone > 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: > > > 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 = > > Results = > > > > > 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@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.
Re: [GNC] Find or search all expenses in a certain account
Also, per the other thread, I have a standing question that might have saved you all this time fussing over a Find operation. Please reply there so the conversation stays together. Regards, Adrien > On Mar 9, 2020 w11d69, at 10:53 AM, Adrien Monteleone > wrote: > > Gio, as per the other thread, and John’s advice here, you’re still missing a > setting change for criteria search. > > Looking at the chart in your GoogleDoc, the only combo that is relevant is > the last pair. > > 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. > > Regards, > Adrien > >> On Mar 9, 2020 w11d69, at 12:09 AM, Gio Bacareza 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@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.
Re: [GNC] Find or search all expenses in a certain account
Gio, as per the other thread, and John’s advice here, you’re still missing a setting change for criteria search. Looking at the chart in your GoogleDoc, the only combo that is relevant is the last pair. 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. Regards, Adrien > On Mar 9, 2020 w11d69, at 12:09 AM, Gio Bacareza 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@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.
Re: [GNC] Find or search all expenses in a certain account
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? Thanks. On Mon, Mar 9, 2020 at 11:52 AM John Ralls wrote: > Gio, > > No surprise, that's not exactly lucid. > > I just tried again with a more realistic test book. The problem is that > "matches all accounts" means what it says: if you give it ten accounts then > any transaction must have splits in all 10 of them to match. > > Experimenting around a bit more, I find that if you start from the > Accounts page and use Accounts - Matches Any Account - Foo + Bar (where Foo > and Bar are accounts selected in the account list box) you get all of the > transactions with a split touching either Foo or Bar. If you use All > Accounts - Matches Any Account - Foo + Bar you get transactions with at > least one split in each of Foo and Bar. > > If you start from a register tab then the Accounts - Matches Any Account - > XXX will return no transactions unless XXX is the account whose register > you have focussed. Using All Accounts with a single account selected will > return the transactions from that register with a split touching that one > account. > > So the way to get what you want is to change the selector in the upper > right from "all criteria are met" to "any criteria are met" and then enter > a line All Accounts - Matches Any Account - XXX for each expense account > that you want to include in the result. > > Regards, > John Ralls > > > > On Mar 8, 2020, at 8:00 PM, Gio Bacareza wrote: > > > > Hi John, > > > > I also actually tried that Find > All Accounts > Choose Accounts = > > Expenses:(all children) and it's still blank. > > > > To be honest, I find this text in the documentation really hard to > > understand: > > "The Account option performs a search where the accounts selected in the > > Choose Accounts dialog will both be searched individually for results. > This > > means that a match in any of the selected accounts will either be > displayed > > (matches any account) or discarded (matches no account). > > > > The All Accounts option performs a search where accounts selected in the > > Choose Accounts dialog will only return results that match in both > > accounts." > > > > Thanks > > > > On Sun, Mar 8, 2020 at 12:40 PM John Ralls wrote: > > > >> > >> > >>> On Mar 7, 2020, at 8:04 PM, Gio Bacareza wrote: > >>> > >>> Thanks John. I'm trying to run in from the register page. > >>> > >>> On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: > >>> > > > > On Mar 7, 2020, at 1:20 AM, Gio Bacareza > wrote: > > > > Hi I tried to search all expenses in a certain account by doing Find > > > > Account > Matches Any Account - Selected Expense Account and ALL > child > > accounts. > > > > Result: blank > > > > What am I doing wrong? > > > > Did you run Find from the Accounts page or from a register page? > > >> > >> When you run from a register page Find searches only that account and > >> Account in find matches the current account rather than the transfer > >> account. If I understand what you're trying to do, use All Accounts - > >> matches all accounts - xxx where xxx means to select the accounts you > want > >> to search for in the selector dialog box. > >> > >> Regards, > >> John Ralls > >> > >> > >> > >> > >> > > > > -- > > cheers, > > > > Gio > > ___ > > gnucash-user mailing list > > gnucash-user@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 ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Gio, No surprise, that's not exactly lucid. I just tried again with a more realistic test book. The problem is that "matches all accounts" means what it says: if you give it ten accounts then any transaction must have splits in all 10 of them to match. Experimenting around a bit more, I find that if you start from the Accounts page and use Accounts - Matches Any Account - Foo + Bar (where Foo and Bar are accounts selected in the account list box) you get all of the transactions with a split touching either Foo or Bar. If you use All Accounts - Matches Any Account - Foo + Bar you get transactions with at least one split in each of Foo and Bar. If you start from a register tab then the Accounts - Matches Any Account - XXX will return no transactions unless XXX is the account whose register you have focussed. Using All Accounts with a single account selected will return the transactions from that register with a split touching that one account. So the way to get what you want is to change the selector in the upper right from "all criteria are met" to "any criteria are met" and then enter a line All Accounts - Matches Any Account - XXX for each expense account that you want to include in the result. Regards, John Ralls > On Mar 8, 2020, at 8:00 PM, Gio Bacareza wrote: > > Hi John, > > I also actually tried that Find > All Accounts > Choose Accounts = > Expenses:(all children) and it's still blank. > > To be honest, I find this text in the documentation really hard to > understand: > "The Account option performs a search where the accounts selected in the > Choose Accounts dialog will both be searched individually for results. This > means that a match in any of the selected accounts will either be displayed > (matches any account) or discarded (matches no account). > > The All Accounts option performs a search where accounts selected in the > Choose Accounts dialog will only return results that match in both > accounts." > > Thanks > > On Sun, Mar 8, 2020 at 12:40 PM John Ralls wrote: > >> >> >>> On Mar 7, 2020, at 8:04 PM, Gio Bacareza wrote: >>> >>> Thanks John. I'm trying to run in from the register page. >>> >>> On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: >>> > On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: > > Hi I tried to search all expenses in a certain account by doing Find > > Account > Matches Any Account - Selected Expense Account and ALL child > accounts. > > Result: blank > > What am I doing wrong? > Did you run Find from the Accounts page or from a register page? >> >> When you run from a register page Find searches only that account and >> Account in find matches the current account rather than the transfer >> account. If I understand what you're trying to do, use All Accounts - >> matches all accounts - xxx where xxx means to select the accounts you want >> to search for in the selector dialog box. >> >> Regards, >> John Ralls >> >> >> >> >> > > -- > cheers, > > Gio > ___ > gnucash-user mailing list > gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Hi John, I also actually tried that Find > All Accounts > Choose Accounts = Expenses:(all children) and it's still blank. To be honest, I find this text in the documentation really hard to understand: "The Account option performs a search where the accounts selected in the Choose Accounts dialog will both be searched individually for results. This means that a match in any of the selected accounts will either be displayed (matches any account) or discarded (matches no account). The All Accounts option performs a search where accounts selected in the Choose Accounts dialog will only return results that match in both accounts." Thanks On Sun, Mar 8, 2020 at 12:40 PM John Ralls wrote: > > > > On Mar 7, 2020, at 8:04 PM, Gio Bacareza wrote: > > > > Thanks John. I'm trying to run in from the register page. > > > > On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: > > > >> > >> > >>> On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: > >>> > >>> Hi I tried to search all expenses in a certain account by doing Find > > >>> Account > Matches Any Account - Selected Expense Account and ALL child > >>> accounts. > >>> > >>> Result: blank > >>> > >>> What am I doing wrong? > >>> > >> > >> Did you run Find from the Accounts page or from a register page? > >> > > When you run from a register page Find searches only that account and > Account in find matches the current account rather than the transfer > account. If I understand what you're trying to do, use All Accounts - > matches all accounts - xxx where xxx means to select the accounts you want > to search for in the selector dialog box. > > Regards, > John Ralls > > > > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
> On Mar 7, 2020, at 8:04 PM, Gio Bacareza wrote: > > Thanks John. I'm trying to run in from the register page. > > On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: > >> >> >>> On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: >>> >>> Hi I tried to search all expenses in a certain account by doing Find > >>> Account > Matches Any Account - Selected Expense Account and ALL child >>> accounts. >>> >>> Result: blank >>> >>> What am I doing wrong? >>> >> >> Did you run Find from the Accounts page or from a register page? >> When you run from a register page Find searches only that account and Account in find matches the current account rather than the transfer account. If I understand what you're trying to do, use All Accounts - matches all accounts - xxx where xxx means to select the accounts you want to search for in the selector dialog box. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Thanks John. I'm trying to run in from the register page. On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: > > > > On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: > > > > Hi I tried to search all expenses in a certain account by doing Find > > > Account > Matches Any Account - Selected Expense Account and ALL child > > accounts. > > > > Result: blank > > > > What am I doing wrong? > > > > Did you run Find from the Accounts page or from a register page? > > Regards, > John Ralls > > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
> On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: > > Hi I tried to search all expenses in a certain account by doing Find > > Account > Matches Any Account - Selected Expense Account and ALL child > accounts. > > Result: blank > > What am I doing wrong? > Did you run Find from the Accounts page or from a register page? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
[GNC] Find or search all expenses in a certain account
Hi I tried to search all expenses in a certain account by doing Find > Account > Matches Any Account - Selected Expense Account and ALL child accounts. Result: blank What am I doing wrong? -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.