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 <david.carlson....@gmail.com> 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 <gbacar...@gmail.com> 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 <tommy.truss...@gmail.com> >> wrote: >> >> > On Sat, Mar 7, 2020 at 5:43 AM Maf. King <m...@chilwell.net> 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 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.
