[GNC] OFX Import Mappings

[Rob LaRose]

Per Kalpesh's suggestion, I deleted the online mapping for the fund that
has been importing incorrectly.
I removed the incorrect transaction to make GC think that this transaction
was new again and re-imported the QFX file that had caused the incorrectly
mapped transaction to be created.

As expected, GC did ask for the target account for this 'new' transaction,
but did not ask for the income account.
The result was a transaction in the desired account but with the income
source still being the inactive, placeholder account.

So my questions are:
How does GC map the income account to the asset account?
How do I change or delete the mapping so that I can map it to the proper
location?

It's also interesting that GC allowed the entry into the placeholder
account, but the new transaction didn't have an effect on the account
balance.

On Fri, Oct 6, 2023 at 1:56 PM Rob LaRose <rmlarose at gmail.com> wrote:

> I've already searched all the tabs for any occurence of the disabled
> account...there were none.
> I'm pretty sure that I've previously deleted all my Vanguard online
> mappings to get a clean slate, but still ended up with GC importing
> transactions to the placeholder account.
> I'll try deleting the online mapping again to make sure that I really have
> tried that approach to see if it will reset,
>
> FYI... GC has behaved this way for quite a while now, but frequently I
> just manually enter if there are just a few transactions.
> I only think about it when I do an import (like for an end-of-quarter)
>
> On Sun, Oct 1, 2023 at 8:04 PM Kalpesh Patel <kalpesh.patel at usa.net>
> wrote:
>
>> Rob - It is Import Map Editor. What you want to select is the 'Online' at
>> the top where you will see three total choices - Bayesian (selected by
>> default), Non-Bayesian and Online. Unfortunately you can only delete
>> entries here in the Import Map Editor so find the one that is errant as
>> mentioned below and delete it. Next time you import it, GNC will ask you to
>> map the account which is the opportunity you want to take to wire it up
>> correctly.
>>
>> Hope this helps.
>>
>> -----Original Message-----
>> From: Rob LaRose <rmlarose at gmail.com>
>> Sent: Saturday, September 30, 2023 11:54 AM
>> To: gnucash-user at gnucash.org
>> Subject: [GNC] OFX Import Mappings
>>
>> Sometime ago, Vanguard replaced one of their Money Market funds with a
>> new Money Market fund.
>> In GC, I created a new fund account to handle the change.
>> Once all the transfer transactions for the old fund account were complete,
>> I:
>> - Renamed the account: to move it to the bottom of any acct list as well
>> as identify it as an inactive account
>> - Set the account as a placeholder: to prevent accidentally creating
>> transactions
>> - Hid the account: so that I wouldn't have to look at it all the time.
>>
>> However, now when I import an OFX file from Vanguard, income transactions
>> for the new fund account are entered as being sourced from the renamed,
>> placeholder account instead of the appropriate income account for the new
>> fund.
>>
>> I figured this had something to do with the Import Map Editor.  I
>> searched for the renamed account that GC was using and found no matches.
>> I even deleted all the mappings figuring I would just rebuild the account
>> matches but for some reason, it keeps using the old account.
>>
>> There must be some other location where GC has stored this association.
>> How do I resolve the mapping issue so that transactions get associated to
>> the correct income account?
>>
>> GnuCash: Flatpak v5.4.1
>> OS: Ubuntu 23.04
>>
>> Thanks
>> Rob
>>
>>
>>