[GNC] Help Find Feature

[Gio Bacareza]

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.monteleone at 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 <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.
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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