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 <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. > -- 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.
