aqbanking / ofx downloads to wrong account and can't straighten out

[Derek Atkins]

The mapping is done inside the account structure.
The best way to handle this is to create a fake OFX import with a bogus
account # -- then map that bogus account number to the account you want to
reset (the one that is currently bound to your real OFX account #).
Then, the next time you import the correct OFX account # it should ask you
to map it again.

-derek

On Tue, February 20, 2018 11:10 am, Bill Starrs wrote:
> Hello all,
>
> Still no dice.  I do have 4/5 accounts working properly, and used to
> have 5/5 until the fateful day I mis-assigned the one that received a
> new credit card number.
>
> The setup screen clearly shows that my aqbanking account is associated
> to the correct Gnucash account.  And that relationship holds up front
> when I perform a transaction download from that account in the GUI.  But
> once it pulls the transactions down, it still dumps them in the other
> account.
>
> I would think this has to be some kind of bug where there is a hidden
> setting that is set once and forgotten by the wizard for existing
> accounts?  Can anybody tell me where in the config files I can find
> these relationships?
>
> Thanks,
>
> Bill
>
>
> On Sun, Feb 18, 2018 at 02:20:26AM -0600, David Carlson wrote:
>>I think I found the WIKI page covering this.  It looks like just about
>> what
>>John remembers, but perhaps there is a subtle difference:
>>https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings.
>>
>>David C
>>
>>On Sat, Feb 17, 2018 at 10:17 PM, Bill Starrs <wjstarrsiii at gmail.com>
>> wrote:
>>
>>> Hi John,
>>>
>>> Thanks for your response. I followed this and have the same situation.
>>> The transactions and balance are correct for the account that I update
>>> from, but the transactions still go to the other account, as well as
>>> the
>>> reconciliation window opens for the other account.
>>>
>>> Still scratching my head.  There has to be a way to manually fix it.
>>>
>>> Thanks,
>>>
>>> Bill
>>>
>>>
>>>
>>> On Fri, Feb 16, 2018 at 02:05:02PM -0800, John Ralls wrote:
>>>
>>>>
>>>>
>>>> On Feb 16, 2018, at 12:08 PM, Bill Starrs <wjstarrsiii at gmail.com>
>>>> wrote:
>>>>>
>>>>> Hello,
>>>>>
>>>>> A few months ago I had to change a credit card # due to fraud and
>>>>> reconfigure it through aqbanking.  When I did this, I accidentally
>>>>> associated it with the wrong credit card account in gnucash.
>>>>>
>>>>> After re-configuring it again, and again, and again, in the wizard, I
>>>>> now have a situation where when I am sitting in the proper account
>>>>> and
>>>>> download transactions, I get the preview of the charges for that
>>>>> card,
>>>>> however in the "Account" column of the download reconciliation
>>>>> dialog,
>>>>> it shows the other, mistaken account.  When I accept the
>>>>> transactions,
>>>>> they are placed into that other account.  I then have to manually
>>>>> change
>>>>> them to put them in the right account.  Account balancing also does
>>>>> not
>>>>> work as it opens the balance dialog of the incorrect account.
>>>>>
>>>>> I gave up on fixing with the ui and started looking through the
>>>>> .gnucash
>>>>> and .aqbanking directories as well as the mariadb gnucash database to
>>>>> manually fix this setting but have given up here too.
>>>>>
>>>>>
>>>> I haven't had to do this in a while, but IIRC you run the Online
>>>> Banking
>>>> Setup assistant, start and close the AQBanking wizard, and click
>>>> "forward"
>>>> on the GnuCash assistant. The next screen is a list of your AQBanking
>>>> accounts. Double-click the one that you want to change and you'll get
>>>> a
>>>> Select Account dialog from which you can pick the new account. Once
>>>> you
>>>> have done that, the account name will appear in the middle column and
>>>> the
>>>> "New?" box will be checked. Click "Forward" and the "Apply".
>>>>
>>>> Regards,
>>>> John Ralls
>>>>
>>>>
>>>> _______________________________________________
>>> 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.
>>>
> _______________________________________________
> 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.
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant