Re: [GNC] Help Find Feature
On Tue, 10 Mar 2020 at 03:08, Gio Bacareza wrote: > PS The root of all this was the issue with gnucash importing multicurrency > transactions with CSV. Would you have any idea if other imports eg QIF can > handle multi-currency? > There's old code to handle multicurrency/stock QIF imports but no one knows how/if/when it works anymore. ___ 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] Help Find Feature
No worries. You;ve been a great help. Thanks! On Tue, Mar 10, 2020 at 11:19 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > On Mar 9, 2020 w11d69, at 10:00 PM, Gio Bacareza > wrote: > > > > Hi Adrien, > > > > Yes I'm afraid that is the only solution I find. It is not a viable > option right now because I'm looking at hundreds of lines. > > > > I'm very grateful for the time and attention you have given me in trying > to solve this problem as well. Thanks very much. > > > > Gio > > PS The root of all this was the issue with gnucash importing > multicurrency transactions with CSV. Would you have any idea if other > imports eg QIF can handle multi-currency? > > Sorry, can’t help there. > > Regards, > Adrien > > ___ > 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] Help Find Feature
> On Mar 9, 2020 w11d69, at 10:00 PM, Gio Bacareza wrote: > > Hi Adrien, > > Yes I'm afraid that is the only solution I find. It is not a viable option > right now because I'm looking at hundreds of lines. > > I'm very grateful for the time and attention you have given me in trying to > solve this problem as well. Thanks very much. > > Gio > PS The root of all this was the issue with gnucash importing multicurrency > transactions with CSV. Would you have any idea if other imports eg QIF can > handle multi-currency? Sorry, can’t help there. Regards, Adrien ___ 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] Help Find Feature
Hi Adrien, Yes I'm afraid that is the only solution I find. It is not a viable option right now because I'm looking at hundreds of lines. I'm very grateful for the time and attention you have given me in trying to solve this problem as well. Thanks very much. Gio PS The root of all this was the issue with gnucash importing multicurrency transactions with CSV. Would you have any idea if other imports eg QIF can handle multi-currency? On Tue, Mar 10, 2020 at 10:22 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Let’s say you want to delete transactions between AccountA and Expense:E, > > Are there any transactions in Expense:E between it and some other account > besides AccountA? > > If no, then just delete the entire account Expense:E, GnuCash will offer > to move the transactions, but in this case you want to decline. That should > save you lots of time. > > For those expense accounts that *do* involve *any* account, other than > AccountA, then you’ll have to do them one-by-one, from a Find done from > AccountA. > > Regards, > Adrien > > > > > On Mar 9, 2020 w11d69, at 9:05 PM, Gio Bacareza > wrote: > > > > Hi Adrien, i'll answer this first because it's much faster for me since > i've done it. I have tried with 1 expense account or several specific > accounts. It works. > > > > But when you try with select ALL expense accounts that's when it's blank. > > > > So I think that when you ID the specific expense accounts and manually > select them 1x1 it will work. But I was hoping again for a more efficient > method since selecting all is much faster than selecting dozens of specific > expense accounts. > > > > But if it's the only thing that works for now then I have to bite the > bullet. > > > > Thanks once again. > > > > > ___ > 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] Help Find Feature
Let’s say you want to delete transactions between AccountA and Expense:E, Are there any transactions in Expense:E between it and some other account besides AccountA? If no, then just delete the entire account Expense:E, GnuCash will offer to move the transactions, but in this case you want to decline. That should save you lots of time. For those expense accounts that *do* involve *any* account, other than AccountA, then you’ll have to do them one-by-one, from a Find done from AccountA. Regards, Adrien > On Mar 9, 2020 w11d69, at 9:05 PM, Gio Bacareza wrote: > > Hi Adrien, i'll answer this first because it's much faster for me since i've > done it. I have tried with 1 expense account or several specific accounts. It > works. > > But when you try with select ALL expense accounts that's when it's blank. > > So I think that when you ID the specific expense accounts and manually select > them 1x1 it will work. But I was hoping again for a more efficient method > since selecting all is much faster than selecting dozens of specific expense > accounts. > > But if it's the only thing that works for now then I have to bite the bullet. > > Thanks once again. > ___ 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] Help Find Feature
Hi Adrien, "Do ANY of the target expense accounts involve transactions with ANY other account than AccountA?" Yes. My objective is to be able to select ALL expense accounts. Because they are expense accounts it is very very likely that they will have transactions with other accounts besides AccountA. For example, you may have an expense:dining when using your AUD credit card as well as your USD credit card. On Mon, Mar 9, 2020 at 10:46 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The picture is getting clearer. > > Okay then, next question: > > Do ANY of the target expense accounts involve transactions with ANY other > account than AccountA? > > Put another way, do you have even a single transaction between some other > bank account in any of those same expense accounts? > > > Regards, > Adrien > > > On Mar 8, 2020 w11d68, at 9:37 PM, Gio Bacareza > wrote: > > > > Hi Adrien, thanks for being patient with me. > > > > I think my earlier illustration was not clear because I just realized > that > > it could be read as contents of a single transaction viewed as > multi-splits > > when what I wanted to illustrate are single transactions. > > > > So with that let me try to answer your question. > > 1. Non expense accounts involving AccountA USD and Account B PHP have > been > > fixed. Reason is these are usually interbank transfers and they are not > as > > many so I had fixed them manually. eg 1 transaction in multi-split view: > > Dr. Account A USD XX > > Dr. Trading PHP YY > > Cr. Account B PHP YY > > Cr. Trading USD XX > > > > 2. Typical example below of an expense transaction in multisplit view. > > Notice how gnucash imported and autopopulated with 1:1 currency exchange. > > There are hundreds of these so changing them one by one is a a no-go. > > Dr. Account A USD XX > > Dr. Trading PHP XX > > Cr. Expense:C,D, E PHP XX ( meaning different expenses) > > Cr. Trading USD XX > > > > 3. So that's why I wanted to just find with Account A USD those that > > expenses so I can delete them and re-import with the correct exchange > rates. > > > > Thanks > > > ___ > 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] Help Find Feature
Hi Adrien, i'll answer this first because it's much faster for me since i've done it. I have tried with 1 expense account or several specific accounts. It works. But when you try with select ALL expense accounts that's when it's blank. So I think that when you ID the specific expense accounts and manually select them 1x1 it will work. But I was hoping again for a more efficient method since selecting all is much faster than selecting dozens of specific expense accounts. But if it's the only thing that works for now then I have to bite the bullet. Thanks once again. On Mon, Mar 9, 2020 at 10:59 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Try the search with just one expense account then. (that you can easily > see in the register so you know it is there) > > Regards, > Adrien > > > On Mar 8, 2020 w11d68, at 9:44 PM, Gio Bacareza > wrote: > > > > I did that. Still blank :( > > ___ > 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] Help Find Feature
Try the search with just one expense account then. (that you can easily see in the register so you know it is there) Regards, Adrien > On Mar 8, 2020 w11d68, at 9:44 PM, Gio Bacareza wrote: > > I did that. Still blank :( ___ 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] Help Find Feature
I did that. Still blank :( On Mon, Mar 9, 2020 at 10:32 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Yes, it is blank, because you missed this step: > > >>-then change the “Search for items where” to “any criteria are > met” > > Thus, with ‘all criteria’ you’re asking it to return transactions where > ‘all' of those accounts have splits in the *same* transaction, of which > there are none. > > By changing it to ‘any criteria’ you are asking for all transactions where > ‘any’ of those accounts have splits. > > Still though, to make sure I don’t advise you in a way that makes a mess, > see my earlier question about what other accounts are involved. I see you > aren’t using View > Transaction Journal, so go ahead and turn that on > first. (it is also possible to do some find operations to check this if > needed) > > Regards, > Adrien > > > > On Mar 8, 2020 w11d68, at 9:20 PM, Gio Bacareza > wrote: > > > > Hi Adrien, thanks for this. I really appreciate it. > > > > I've tried exactly what you have prescribed because that's how I thought > I > > understood Find - All Accounts work. But alas it has always returned a > > blank result. (screenshots attached) > > [image: image.png] > > [image: image.png] > > [image: image.png] > > > ___ > 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] Help Find Feature
The picture is getting clearer. Okay then, next question: Do ANY of the target expense accounts involve transactions with ANY other account than AccountA? Put another way, do you have even a single transaction between some other bank account in any of those same expense accounts? Regards, Adrien > On Mar 8, 2020 w11d68, at 9:37 PM, Gio Bacareza wrote: > > Hi Adrien, thanks for being patient with me. > > I think my earlier illustration was not clear because I just realized that > it could be read as contents of a single transaction viewed as multi-splits > when what I wanted to illustrate are single transactions. > > So with that let me try to answer your question. > 1. Non expense accounts involving AccountA USD and Account B PHP have been > fixed. Reason is these are usually interbank transfers and they are not as > many so I had fixed them manually. eg 1 transaction in multi-split view: > Dr. Account A USD XX > Dr. Trading PHP YY > Cr. Account B PHP YY > Cr. Trading USD XX > > 2. Typical example below of an expense transaction in multisplit view. > Notice how gnucash imported and autopopulated with 1:1 currency exchange. > There are hundreds of these so changing them one by one is a a no-go. > Dr. Account A USD XX > Dr. Trading PHP XX > Cr. Expense:C,D, E PHP XX ( meaning different expenses) > Cr. Trading USD XX > > 3. So that's why I wanted to just find with Account A USD those that > expenses so I can delete them and re-import with the correct exchange rates. > > Thanks ___ 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] Help Find Feature
Hi Adrien, thanks for being patient with me. I think my earlier illustration was not clear because I just realized that it could be read as contents of a single transaction viewed as multi-splits when what I wanted to illustrate are single transactions. So with that let me try to answer your question. 1. Non expense accounts involving AccountA USD and Account B PHP have been fixed. Reason is these are usually interbank transfers and they are not as many so I had fixed them manually. eg 1 transaction in multi-split view: Dr. Account A USD XX Dr. Trading PHP YY Cr. Account B PHP YY Cr. Trading USD XX 2. Typical example below of an expense transaction in multisplit view. Notice how gnucash imported and autopopulated with 1:1 currency exchange. There are hundreds of these so changing them one by one is a a no-go. Dr. Account A USD XX Dr. Trading PHP XX Cr. Expense:C,D, E PHP XX ( meaning different expenses) Cr. Trading USD XX 3. So that's why I wanted to just find with Account A USD those that expenses so I can delete them and re-import with the correct exchange rates. Thanks On Mon, Mar 9, 2020 at 10:05 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Gio, I recall the multi-currency thread. This puts some things in > perspective. > > In order to help you find the best method, there are a few more questions, > here’s the first: > > Do any of those transactions in AccountA-USD that have splits with the > expense accounts also have splits with AccountB-PHP? > > Such as something similar to: > > Cr. AccountA-USD > Dr. AccountB-PHP > Dr. ExpenseE-??? > > That is, do any of them involve A, B *and* the offending expense accounts? > (actual debits/credits aren’t really relevant, that was just an > illustration) > > Use View > Transaction Journal, if you aren’t already, to see this. > > Regards, > Adrien > > > > > On Mar 8, 2020 w11d68, at 8:46 PM, Gio Bacareza > wrote: > > > > Hi Adrien, thanks for the response. > > > > To answer your questions: > > The reason I want to delete these transactions is because of a faulty > > multi-currency import. See, I imported a year's worth of multicurrency > > accounts and now I am fixing these as gnucash does not handle > > multi-currency accounts export well. So I ended up with accounts where > the > > exchange rates between these accounts were auto populated by gnucash > with a > > 1:1 ratio by default. I have fixed some accounts and have reconciled > them. > > I selected those with a few transactions because the process is very > manual > > and time consuming. So now I am left with accounts with transactions some > > of which are with (1) reconciled accounts and some with (2) expense > > accounts. Those with reconciled transactions I don't want to touch > because > > the other side is reconciled. Those on expense I want to delete and > > reimport with a method I found that works with multi-currency imports. > > Hence this is the reason I want to delete the transactions where the > > transfer account = expense and children. > > > > Illustrating the scenario without showing actual transactions, consider > > Bank Account A USD. It has 10 or so transfers to Bank Account B in PHP > and > > 200 expenses. I have fixed the 10 transfers manually. But I dont want to > > fix the 200 expenses manually because it's too much time and effort for > me. > > So I plan to delete them and re-import with new method that works. > > > > I hope this also answers your 2nd question: “Do you want to delete some > or > > *all* of the transactions in that expense account?" > > > > Sorry if I didn't include the background in my first post as I didn't > want > > to complicate the question. > > > > Now that I've explained the background is there a better way? Thanks. > > > ___ > 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] Help Find Feature
To be clear, a transaction can involve *more* than two accounts. I’m trying to ascertain if you have that case (it is not uncommon) and if any of these will be effected by your deletions. That fact will change the recommended procedure. Regards, Adrien > On Mar 8, 2020 w11d68, at 9:30 PM, Adrien Monteleone > wrote: > > Yes, it is blank, because you missed this step: > >>> -then change the “Search for items where” to “any criteria are met” > > Thus, with ‘all criteria’ you’re asking it to return transactions where ‘all' > of those accounts have splits in the *same* transaction, of which there are > none. > > By changing it to ‘any criteria’ you are asking for all transactions where > ‘any’ of those accounts have splits. > > Still though, to make sure I don’t advise you in a way that makes a mess, see > my earlier question about what other accounts are involved. I see you aren’t > using View > Transaction Journal, so go ahead and turn that on first. (it is > also possible to do some find operations to check this if needed) > > Regards, > Adrien > > >> On Mar 8, 2020 w11d68, at 9:20 PM, Gio Bacareza wrote: >> >> Hi Adrien, thanks for this. I really appreciate it. >> >> I've tried exactly what you have prescribed because that's how I thought I >> understood Find - All Accounts work. But alas it has always returned a >> blank result. (screenshots attached) >> [image: image.png] >> [image: image.png] >> [image: image.png] > ___ 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] Help Find Feature
Yes, it is blank, because you missed this step: >>-then change the “Search for items where” to “any criteria are met” Thus, with ‘all criteria’ you’re asking it to return transactions where ‘all' of those accounts have splits in the *same* transaction, of which there are none. By changing it to ‘any criteria’ you are asking for all transactions where ‘any’ of those accounts have splits. Still though, to make sure I don’t advise you in a way that makes a mess, see my earlier question about what other accounts are involved. I see you aren’t using View > Transaction Journal, so go ahead and turn that on first. (it is also possible to do some find operations to check this if needed) Regards, Adrien > On Mar 8, 2020 w11d68, at 9:20 PM, Gio Bacareza wrote: > > Hi Adrien, thanks for this. I really appreciate it. > > I've tried exactly what you have prescribed because that's how I thought I > understood Find - All Accounts work. But alas it has always returned a > blank result. (screenshots attached) > [image: image.png] > [image: image.png] > [image: image.png] ___ 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] Help Find Feature
Hi Stephen, thanks for the response. Once again, I want to apologize if my initial and following posts were not clear. My bad. As I have explained to Adrien in my earlier response (I respond on a FIFO basis.) the reason I cannot do what you have suggested is that it doesn't apply. The Expense account and all its children is not the problem. The problem is with specific accounts where I need to delete all expenses within them. I tried to explain in gnucash nomenclature where expenses are not categories but just another accounts. So within the concerned accounts (which are bank and credit card accounts), I just need to delete the expenses. I hope this is much clearer. If it's not responsibility to improve clarity is mine. Do let me know. Thanks. On Mon, Mar 9, 2020 at 1:49 AM Stephen M. Butler wrote: > On 3/7/20 8:03 PM, Gio Bacareza wrote: > > Thanks Tommy. This is a really interesting method and I can already think > > of use cases. For my scenario though, as I mentioned earlier response, it > > will add extra steps to what it is that I want to do. > > > > I want to be able to find transactions to/from expense accounts because I > > need to delete them and I am looking for the fastest way to do that. > Thanks > > > Hmm. Did you say _every_ transaction involved in _all_ expense accounts? > > Open your file and save off a copy. > > Then on the Accounts tab, find the top-level Expenses account and > highlight that. > > Click on Edit menu item and then on Delete Account. > > On the popup screen select the options to delete sub-accounts and to > delete transactions. > > Click on the Delete button on the lower right corner. > > POOF -- all transactions involving an expense account are gone. So are > all the Expense accounts! But you can add those back in as needed. > > -- > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > > ___ > 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] Help Find Feature
Gio, I recall the multi-currency thread. This puts some things in perspective. In order to help you find the best method, there are a few more questions, here’s the first: Do any of those transactions in AccountA-USD that have splits with the expense accounts also have splits with AccountB-PHP? Such as something similar to: Cr. AccountA-USD Dr. AccountB-PHP Dr. ExpenseE-??? That is, do any of them involve A, B *and* the offending expense accounts? (actual debits/credits aren’t really relevant, that was just an illustration) Use View > Transaction Journal, if you aren’t already, to see this. Regards, Adrien > On Mar 8, 2020 w11d68, at 8:46 PM, Gio Bacareza wrote: > > Hi Adrien, thanks for the response. > > To answer your questions: > The reason I want to delete these transactions is because of a faulty > multi-currency import. See, I imported a year's worth of multicurrency > accounts and now I am fixing these as gnucash does not handle > multi-currency accounts export well. So I ended up with accounts where the > exchange rates between these accounts were auto populated by gnucash with a > 1:1 ratio by default. I have fixed some accounts and have reconciled them. > I selected those with a few transactions because the process is very manual > and time consuming. So now I am left with accounts with transactions some > of which are with (1) reconciled accounts and some with (2) expense > accounts. Those with reconciled transactions I don't want to touch because > the other side is reconciled. Those on expense I want to delete and > reimport with a method I found that works with multi-currency imports. > Hence this is the reason I want to delete the transactions where the > transfer account = expense and children. > > Illustrating the scenario without showing actual transactions, consider > Bank Account A USD. It has 10 or so transfers to Bank Account B in PHP and > 200 expenses. I have fixed the 10 transfers manually. But I dont want to > fix the 200 expenses manually because it's too much time and effort for me. > So I plan to delete them and re-import with new method that works. > > I hope this also answers your 2nd question: “Do you want to delete some or > *all* of the transactions in that expense account?" > > Sorry if I didn't include the background in my first post as I didn't want > to complicate the question. > > Now that I've explained the background is there a better way? Thanks. ___ 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] Help Find Feature
Hi David, thanks for the response. Sorry If my original post was not clear. My bad. I was not planning to delete split lines. I was planning to delete the whole transaction. I understand that any transaction has at least 2 splits: a debit and a credit account or left or right or source or target. In my scenario, anything where the other side = expense and all its children eg Expense:Groceries, Expense:Dining etc needs to be deleted as a whole transaction not as just the split. Why do I want to do this? It has something to do with gnucash's issue with multicurrency imports. I detailed the background in my earlier response to Adrien. I've tried many solutions and most of them require me to change each transactions manually one at a time. To do that with a year's worth of expense transactions is a no-go for me. I have experimented with an import method that seem to work. So I plan to just delete the expenses and re-import them. If there's a better way I am all ears. Thanks David. On Sun, Mar 8, 2020 at 1:29 PM David Carlson wrote: > Gio, > > In GnuCash you cannot delete split lines without throwing the transaction > out of balance. Hence, you need to replace the undesired account with a > different account. If you want to delete every instance of an expense A > and replace it with expense B you can do that in the account tree by > relocating expense A under expense B then deleting expense A. > > If you want to only select a few instances of A and replace them with B, > that probably means examining one transaction at a time and changing A to > B individually. If you use the technique described by Tommy Trussell you > can generate a "short list" of transactions that meet your criteria for > finding the desired transactions, but you would still need to edit those > transactions one at a time. > > David Carlson > > On Sat, Mar 7, 2020 at 10:10 PM Gio Bacareza wrote: > >> Thanks Tommy. This is a really interesting method and I can already think >> of use cases. For my scenario though, as I mentioned earlier response, it >> will add extra steps to what it is that I want to do. >> >> I want to be able to find transactions to/from expense accounts because I >> need to delete them and I am looking for the fastest way to do that. >> Thanks >> >> On Sun, Mar 8, 2020 at 4:30 AM Tommy Trussell >> wrote: >> >> > On Sat, Mar 7, 2020 at 5:43 AM Maf. King wrote: >> > >> > > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: >> > > > Hi, >> > > > >> > > > I've read the manual, tried everything and searched the lists but >> can't >> > > > seem to figure out how you can search for ALL expense transactions >> > from a >> > > > certain account. >> > > > >> > > > Any help would be appreciated. >> > > >> > > Try the transaction report, (or possibly the account report.) >> > > >> > >> > I just happened to be wondering the same thing so here's what I did in >> > detail >> > >> > 1) Go to the Accounts page and select the top-level item you want to >> report >> > under. In this case: >> > Expenses >> > >> > 2) Edit--> Open SubAccounts [OR right-click --> Open SubAccounts] >> > >> > 3) A new register will open; GnuCash may warn you that it's read-only. >> In >> > this case the tab says "Expenses+" to indicate it includes SubAccounts. >> > >> > 4) I wanted to see JUST last month's expenses so I chose >> > View --> Filter By... >> > o Select Range >> > 2/1/2020 >> > 2/29/2020 >> > >> > 5) Now that you have the transactions filtered, open the Account report: >> > Reports --> Account Report >> > >> > 6) Play with the report settings till the report shows the detail you >> need. >> > (If you need to tinker further, you can copy the report contents and >> paste >> > into a spreadsheet.) >> > >> > - >> > > 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. >> > >> >> >> -- >> 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. >> > > > -- > David Carlson > -- cheers, Gio ___ gnucash-user
Re: [GNC] Help Find Feature
Hi Adrien, thanks for the response. To answer your questions: The reason I want to delete these transactions is because of a faulty multi-currency import. See, I imported a year's worth of multicurrency accounts and now I am fixing these as gnucash does not handle multi-currency accounts export well. So I ended up with accounts where the exchange rates between these accounts were auto populated by gnucash with a 1:1 ratio by default. I have fixed some accounts and have reconciled them. I selected those with a few transactions because the process is very manual and time consuming. So now I am left with accounts with transactions some of which are with (1) reconciled accounts and some with (2) expense accounts. Those with reconciled transactions I don't want to touch because the other side is reconciled. Those on expense I want to delete and reimport with a method I found that works with multi-currency imports. Hence this is the reason I want to delete the transactions where the transfer account = expense and children. Illustrating the scenario without showing actual transactions, consider Bank Account A USD. It has 10 or so transfers to Bank Account B in PHP and 200 expenses. I have fixed the 10 transfers manually. But I dont want to fix the 200 expenses manually because it's too much time and effort for me. So I plan to delete them and re-import with new method that works. I hope this also answers your 2nd question: “Do you want to delete some or *all* of the transactions in that expense account?" Sorry if I didn't include the background in my first post as I didn't want to complicate the question. Now that I've explained the background is there a better way? Thanks. On Sun, Mar 8, 2020 at 1:26 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > First, I would ask, “Why do you want to delete these transactions?” and > second, “Do you want to delete some or *all* of the transactions in that > expense account?" > > You don’t need to ‘find’ transactions from an expense account to delete > them. > > Just open the expense account if you want to delete certain ones, which > you can narrow with a Find operation there if you like. > > Or if you want to delete all transactions in an expense account, just > delete the account. > > GnuCash will ask you upon account deletion if you want to move the > transactions as re-assigned to a different account (good for refactoring > your tree) or if you want to delete the transactions entirely. Choose > accordingly. > > But I’d still be interested in the original “why?” because you *may* be > thinking deletion is an answer to a problem that might have a better > solution. > > Regards, > Adrien > > > On Mar 7, 2020 w10d67, at 10:03 PM, Gio Bacareza > wrote: > > > > Thanks Tommy. This is a really interesting method and I can already think > > of use cases. For my scenario though, as I mentioned earlier response, it > > will add extra steps to what it is that I want to do. > > > > I want to be able to find transactions to/from expense accounts because I > > need to delete them and I am looking for the fastest way to do that. > Thanks > > ___ > 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] Help Find Feature
Yes, wise indeed. Regards, Adrien > On Mar 8, 2020 w11d68, at 6:42 PM, David Carlson > wrote: > > I agree that the purpose and the method are two different animals. I wanted > to make sure that Gio was aware that the specific method of an expense > account deletion will have consequences in other parts of his data, so he can > avoid shooting himself in the foot. ___ 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] Help Find Feature
I agree that the purpose and the method are two different animals. I wanted to make sure that Gio was aware that the specific method of an expense account deletion will have consequences in other parts of his data, so he can avoid shooting himself in the foot. On Sun, Mar 8, 2020 at 5:36 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Looking at the example again, it still isn’t clear what the OP aims to > accomplish or why. (maybe this isn’t even the right rabbit hole) > > If they want to only delete transactions in AccountA that *do not* also > include splits with AccountB and AccountC, but do include splits with > Expense:E and Expense:F then probably two successive Find operations would > need to be done to narrow the result properly. (or just visually skip them > when deleting) > > Otherwise as David noted, AccountB and AccountC will also see those > transactions disappear and be affected. > > This might even be a case where the target transactions should be found, > then one-by-one, edited manually to exclude splits to Expense:E & Expense:F > and re-balance each transaction between only AccountA, B, & C. > > Regards, > Adrien > ___ > 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. > -- David Carlson ___ 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] Help Find Feature
Looking at the example again, it still isn’t clear what the OP aims to accomplish or why. (maybe this isn’t even the right rabbit hole) If they want to only delete transactions in AccountA that *do not* also include splits with AccountB and AccountC, but do include splits with Expense:E and Expense:F then probably two successive Find operations would need to be done to narrow the result properly. (or just visually skip them when deleting) Otherwise as David noted, AccountB and AccountC will also see those transactions disappear and be affected. This might even be a case where the target transactions should be found, then one-by-one, edited manually to exclude splits to Expense:E & Expense:F and re-balance each transaction between only AccountA, B, & C. Regards, Adrien ___ 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] Help Find Feature
Certainly. I can’t imagine anyone thinking they can delete transactions and *not* affect running balances or reconciliations. We don’t know the original purpose to the pursuit of the deletion, but that might very well be the intent. Maybe the current balances are off. Maybe there are lots of known duplicates from an import problem. That doesn’t change *how* to accomplish the task as asked though. Regards, Adrien > On Mar 8, 2020 w11d68, at 2:51 PM, David Carlson > wrote: > > Deleting complete multi-split transactions would, of course, change running > balances in all affected accounts, possibly affecting bank account > reconciliations or whatever happens to be in those deleted transactions. ___ 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] Help Find Feature
On 3/8/20 11:14 AM, Adrien Monteleone wrote: > Per a previous post Gio noted the intent to delete *some* expense > transactions. AHA. Insight (to quote Martin Gardner). > > The example given was: > >> So example consider accountA. In it you would have transactions to/from: >> AccountB >> AccountC >> Expense:E >> Expense:F >> >> I want to be able to search so it will list Expense:E and F but NOT >> Accounts B and C. Then I can delete these expenses. > It still isn’t clear if the intent is to delete everything in Expense:E & > Expense:F or just those that also are split with AccountA. Well, there is that option to delete an entire account/sub-account. But that is drastic. Not as drastic as deleting everything! > > In the latter case, a proper Find operation I think is the fastest route, > deleting each one by one from that resulting list. (a search result that is, > not a report which does involve extra clicks as the OP noted.) > > Regards, > Adrien > > > >> On Mar 8, 2020 w11d68, at 12:48 PM, Stephen M. Butler wrote: >> >> Hmm. Did you say _every_ transaction involved in _all_ expense accounts? >> >> Open your file and save off a copy. >> >> Then on the Accounts tab, find the top-level Expenses account and >> highlight that. >> >> Click on Edit menu item and then on Delete Account. >> >> On the popup screen select the options to delete sub-accounts and to >> delete transactions. >> >> Click on the Delete button on the lower right corner. >> >> POOF -- all transactions involving an expense account are gone. So are >> all the Expense accounts! But you can add those back in as needed. > > ___ > 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Help Find Feature
Deleting complete multi-split transactions would, of course, change running balances in all affected accounts, possibly affecting bank account reconciliations or whatever happens to be in those deleted transactions. On Sun, Mar 8, 2020 at 1:27 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The proper Find operation would be this: > > 1. Open the AccountA register. > 2. Edit > Find > 3. Set Criteria to “All Accounts” > 3a. If you want all transactions that contain *both* Expense:E and > Expense:F > -then select both accounts in the pop-up selector (use > CTRL/CMD-click to select non-adjacent accounts, or shift-click for a range) > 3b. If you want transactions that contain *either* Expense:E or > Expense:F > -then select Expense:E > -then Add another “All Accounts” criteria and select Expense:F > -then change the “Search for items where” to “any criteria are met” > 4. Click the Find button > > From the search results, delete each transaction as desired one-by-one. > > Note, you can further refine search results with additional Finds from the > resulting register of a previous Find. > > Regards, > Adrien > > > On Mar 8, 2020 w11d68, at 1:14 PM, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > > Per a previous post Gio noted the intent to delete *some* expense > transactions. > > > > The example given was: > > > >> So example consider accountA. In it you would have transactions to/from: > >> AccountB > >> AccountC > >> Expense:E > >> Expense:F > >> > >> I want to be able to search so it will list Expense:E and F but NOT > >> Accounts B and C. Then I can delete these expenses. > > > > It still isn’t clear if the intent is to delete everything in Expense:E > & Expense:F or just those that also are split with AccountA. > > > > In the latter case, a proper Find operation I think is the fastest > route, deleting each one by one from that resulting list. (a search result > that is, not a report which does involve extra clicks as the OP noted.) > > > > Regards, > > Adrien > > > > > > > >> On Mar 8, 2020 w11d68, at 12:48 PM, Stephen M. Butler > wrote: > >> > >> Hmm. Did you say _every_ transaction involved in _all_ expense > accounts? > >> > >> Open your file and save off a copy. > >> > >> Then on the Accounts tab, find the top-level Expenses account and > >> highlight that. > >> > >> Click on Edit menu item and then on Delete Account. > >> > >> On the popup screen select the options to delete sub-accounts and to > >> delete transactions. > >> > >> Click on the Delete button on the lower right corner. > >> > >> POOF -- all transactions involving an expense account are gone. So are > >> all the Expense accounts! But you can add those back in as needed. > > > > > ___ > 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. > -- David Carlson ___ 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] Help Find Feature
The proper Find operation would be this: 1. Open the AccountA register. 2. Edit > Find 3. Set Criteria to “All Accounts” 3a. If you want all transactions that contain *both* Expense:E and Expense:F -then select both accounts in the pop-up selector (use CTRL/CMD-click to select non-adjacent accounts, or shift-click for a range) 3b. If you want transactions that contain *either* Expense:E or Expense:F -then select Expense:E -then Add another “All Accounts” criteria and select Expense:F -then change the “Search for items where” to “any criteria are met” 4. Click the Find button From the search results, delete each transaction as desired one-by-one. Note, you can further refine search results with additional Finds from the resulting register of a previous Find. Regards, Adrien > On Mar 8, 2020 w11d68, at 1:14 PM, Adrien Monteleone > wrote: > > Per a previous post Gio noted the intent to delete *some* expense > transactions. > > The example given was: > >> So example consider accountA. In it you would have transactions to/from: >> AccountB >> AccountC >> Expense:E >> Expense:F >> >> I want to be able to search so it will list Expense:E and F but NOT >> Accounts B and C. Then I can delete these expenses. > > It still isn’t clear if the intent is to delete everything in Expense:E & > Expense:F or just those that also are split with AccountA. > > In the latter case, a proper Find operation I think is the fastest route, > deleting each one by one from that resulting list. (a search result that is, > not a report which does involve extra clicks as the OP noted.) > > Regards, > Adrien > > > >> On Mar 8, 2020 w11d68, at 12:48 PM, Stephen M. Butler wrote: >> >> Hmm. Did you say _every_ transaction involved in _all_ expense accounts? >> >> Open your file and save off a copy. >> >> Then on the Accounts tab, find the top-level Expenses account and >> highlight that. >> >> Click on Edit menu item and then on Delete Account. >> >> On the popup screen select the options to delete sub-accounts and to >> delete transactions. >> >> Click on the Delete button on the lower right corner. >> >> POOF -- all transactions involving an expense account are gone. So are >> all the Expense accounts! But you can add those back in as needed. > ___ 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] Help Find Feature
Per a previous post Gio noted the intent to delete *some* expense transactions. The example given was: > So example consider accountA. In it you would have transactions to/from: > AccountB > AccountC > Expense:E > Expense:F > > I want to be able to search so it will list Expense:E and F but NOT > Accounts B and C. Then I can delete these expenses. It still isn’t clear if the intent is to delete everything in Expense:E & Expense:F or just those that also are split with AccountA. In the latter case, a proper Find operation I think is the fastest route, deleting each one by one from that resulting list. (a search result that is, not a report which does involve extra clicks as the OP noted.) Regards, Adrien > On Mar 8, 2020 w11d68, at 12:48 PM, Stephen M. Butler wrote: > > Hmm. Did you say _every_ transaction involved in _all_ expense accounts? > > Open your file and save off a copy. > > Then on the Accounts tab, find the top-level Expenses account and > highlight that. > > Click on Edit menu item and then on Delete Account. > > On the popup screen select the options to delete sub-accounts and to > delete transactions. > > Click on the Delete button on the lower right corner. > > POOF -- all transactions involving an expense account are gone. So are > all the Expense accounts! But you can add those back in as needed. ___ 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] Help Find Feature
On 3/7/20 8:03 PM, Gio Bacareza wrote: > Thanks Tommy. This is a really interesting method and I can already think > of use cases. For my scenario though, as I mentioned earlier response, it > will add extra steps to what it is that I want to do. > > I want to be able to find transactions to/from expense accounts because I > need to delete them and I am looking for the fastest way to do that. Thanks > Hmm. Did you say _every_ transaction involved in _all_ expense accounts? Open your file and save off a copy. Then on the Accounts tab, find the top-level Expenses account and highlight that. Click on Edit menu item and then on Delete Account. On the popup screen select the options to delete sub-accounts and to delete transactions. Click on the Delete button on the lower right corner. POOF -- all transactions involving an expense account are gone. So are all the Expense accounts! But you can add those back in as needed. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Help Find Feature
Gio, In GnuCash you cannot delete split lines without throwing the transaction out of balance. Hence, you need to replace the undesired account with a different account. If you want to delete every instance of an expense A and replace it with expense B you can do that in the account tree by relocating expense A under expense B then deleting expense A. If you want to only select a few instances of A and replace them with B, that probably means examining one transaction at a time and changing A to B individually. If you use the technique described by Tommy Trussell you can generate a "short list" of transactions that meet your criteria for finding the desired transactions, but you would still need to edit those transactions one at a time. David Carlson On Sat, Mar 7, 2020 at 10:10 PM Gio Bacareza wrote: > Thanks Tommy. This is a really interesting method and I can already think > of use cases. For my scenario though, as I mentioned earlier response, it > will add extra steps to what it is that I want to do. > > I want to be able to find transactions to/from expense accounts because I > need to delete them and I am looking for the fastest way to do that. Thanks > > On Sun, Mar 8, 2020 at 4:30 AM Tommy Trussell > wrote: > > > On Sat, Mar 7, 2020 at 5:43 AM Maf. King wrote: > > > > > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: > > > > Hi, > > > > > > > > I've read the manual, tried everything and searched the lists but > can't > > > > seem to figure out how you can search for ALL expense transactions > > from a > > > > certain account. > > > > > > > > Any help would be appreciated. > > > > > > Try the transaction report, (or possibly the account report.) > > > > > > > I just happened to be wondering the same thing so here's what I did in > > detail > > > > 1) Go to the Accounts page and select the top-level item you want to > report > > under. In this case: > > Expenses > > > > 2) Edit--> Open SubAccounts [OR right-click --> Open SubAccounts] > > > > 3) A new register will open; GnuCash may warn you that it's read-only. In > > this case the tab says "Expenses+" to indicate it includes SubAccounts. > > > > 4) I wanted to see JUST last month's expenses so I chose > > View --> Filter By... > > o Select Range > > 2/1/2020 > > 2/29/2020 > > > > 5) Now that you have the transactions filtered, open the Account report: > > Reports --> Account Report > > > > 6) Play with the report settings till the report shows the detail you > need. > > (If you need to tinker further, you can copy the report contents and > paste > > into a spreadsheet.) > > > > - > > > 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. > > > > > -- > 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. > -- David Carlson ___ 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] Help Find Feature
First, I would ask, “Why do you want to delete these transactions?” and second, “Do you want to delete some or *all* of the transactions in that expense account?" You don’t need to ‘find’ transactions from an expense account to delete them. Just open the expense account if you want to delete certain ones, which you can narrow with a Find operation there if you like. Or if you want to delete all transactions in an expense account, just delete the account. GnuCash will ask you upon account deletion if you want to move the transactions as re-assigned to a different account (good for refactoring your tree) or if you want to delete the transactions entirely. Choose accordingly. But I’d still be interested in the original “why?” because you *may* be thinking deletion is an answer to a problem that might have a better solution. Regards, Adrien > On Mar 7, 2020 w10d67, at 10:03 PM, Gio Bacareza wrote: > > Thanks Tommy. This is a really interesting method and I can already think > of use cases. For my scenario though, as I mentioned earlier response, it > will add extra steps to what it is that I want to do. > > I want to be able to find transactions to/from expense accounts because I > need to delete them and I am looking for the fastest way to do that. Thanks ___ 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] Help Find Feature
Thanks Tommy. This is a really interesting method and I can already think of use cases. For my scenario though, as I mentioned earlier response, it will add extra steps to what it is that I want to do. I want to be able to find transactions to/from expense accounts because I need to delete them and I am looking for the fastest way to do that. Thanks On Sun, Mar 8, 2020 at 4:30 AM Tommy Trussell wrote: > On Sat, Mar 7, 2020 at 5:43 AM Maf. King wrote: > > > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: > > > Hi, > > > > > > I've read the manual, tried everything and searched the lists but can't > > > seem to figure out how you can search for ALL expense transactions > from a > > > certain account. > > > > > > Any help would be appreciated. > > > > Try the transaction report, (or possibly the account report.) > > > > I just happened to be wondering the same thing so here's what I did in > detail > > 1) Go to the Accounts page and select the top-level item you want to report > under. In this case: > Expenses > > 2) Edit--> Open SubAccounts [OR right-click --> Open SubAccounts] > > 3) A new register will open; GnuCash may warn you that it's read-only. In > this case the tab says "Expenses+" to indicate it includes SubAccounts. > > 4) I wanted to see JUST last month's expenses so I chose > View --> Filter By... > o Select Range > 2/1/2020 > 2/29/2020 > > 5) Now that you have the transactions filtered, open the Account report: > Reports --> Account Report > > 6) Play with the report settings till the report shows the detail you need. > (If you need to tinker further, you can copy the report contents and paste > into a spreadsheet.) > > - > > 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. > -- 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] Help Find Feature
Thanks Maf, I tried that but it doesn't let me do what I ultimately want to do. The goal is to be able to delete all transactions to expense account and all it's children. So example consider accountA. In it you would have transactions to/from: AccountB AccountC Expense:E Expense:F I want to be able to search so it will list Expense:E and F but NOT Accounts B and C. Then I can delete these expenses. Doing it with the report requires me to do 2 steps: 1 click the link, then 2 delete. Then I have to go back to the report and do it again. If I'm deleting many transactions, it will take so much time. So I'm looking for a better way. On Sat, Mar 7, 2020 at 7:41 PM Maf. King wrote: > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: > > Hi, > > > > I've read the manual, tried everything and searched the lists but can't > > seem to figure out how you can search for ALL expense transactions from a > > certain account. > > > > Any help would be appreciated. > > Try the transaction report, (or possibly the account report.) > > HTH, > Maf. > > > > -- 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] Help Find Feature
On Sat, Mar 7, 2020 at 5:43 AM Maf. King wrote: > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: > > Hi, > > > > I've read the manual, tried everything and searched the lists but can't > > seem to figure out how you can search for ALL expense transactions from a > > certain account. > > > > Any help would be appreciated. > > Try the transaction report, (or possibly the account report.) > I just happened to be wondering the same thing so here's what I did in detail 1) Go to the Accounts page and select the top-level item you want to report under. In this case: Expenses 2) Edit--> Open SubAccounts [OR right-click --> Open SubAccounts] 3) A new register will open; GnuCash may warn you that it's read-only. In this case the tab says "Expenses+" to indicate it includes SubAccounts. 4) I wanted to see JUST last month's expenses so I chose View --> Filter By... o Select Range 2/1/2020 2/29/2020 5) Now that you have the transactions filtered, open the Account report: Reports --> Account Report 6) Play with the report settings till the report shows the detail you need. (If you need to tinker further, you can copy the report contents and paste into a spreadsheet.) - > 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] Help Find Feature
On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: > Hi, > > I've read the manual, tried everything and searched the lists but can't > seem to figure out how you can search for ALL expense transactions from a > certain account. > > Any help would be appreciated. Try the transaction report, (or possibly the account report.) HTH, Maf. ___ 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] Help Find Feature
Hi, I've read the manual, tried everything and searched the lists but can't seem to figure out how you can search for ALL expense transactions from a certain account. Any help would be appreciated. -- 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.
