[GNC] Help Find Feature

[Adrien Monteleone]

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