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 <gbacar...@gmail.com> 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.
