[GNC] How to reorganize the account tree

[Christopher Lam]

Some users have intuitively suggested using Account Codes, which is the
right answer: the default sorting within the account tree has *always*[1]
prioritised account codes over other fields e.g. account type and name.
However there was an undocumented base-36 sort[2] which was removed without
fanfare a few years ago, causing unexpected sorting.

[1] current sorting of account codes
https://github.com/Gnucash/gnucash/blob/65eae554bec2d360600c7ff62ac72d92665c1f59/libgnucash/engine/Account.cpp#L2362

[2] base-36 account code sorting
https://github.com/Gnucash/gnucash/blob/f47b53a310d9e40020846043c31f0400a79b6308/src/engine/Account.c#L1259
results
in: 0010..0019, 001A-001Z, 0020 etc.

On Tue, 14 Jun 2022 at 08:45, john <jralls at ceridwen.us> wrote:

> Account type is a number, not a string. You can see what number goes with
> what type at
> https://github.com/Gnucash/gnucash/blob/65eae554bec2d360600c7ff62ac72d92665c1f59/libgnucash/engine/Account.h#L105
> .
>
> That shouldn't have anything to do with anything if you assign codes to
> accounts, display the account code column in the Accounts tab, and click on
> its header to sort by it. You can easily tell which column is used for
> sorting and in which direction by the arrow icon that appears on the right
> of the column's header.
>
> Regards,
> John Ralls
>
>
> > On Jun 13, 2022, at 12:09 PM, Gyle McCollam <gmccollam at live.com> wrote:
> >
> > Alan,
> > I noticed that the accounts under assets are not sorted in alpha order
> when I assign account codes to the major cats, namely the Assets (1),
> Liabilities (2), Equity (3), Income (4), and Expense (5).  I have
> determined this is due to the Asset account type being broken down into
> Assets, Bank, and Cash.  For some reason Cash comes before Asset, which
> comes before Bank.  I was thinking it was sorting on Type even though I
> didn't have "Type" displayed, but having Cash before Asset types negates
> that reasoning.
> >
> > Also, wanted to let you know that sorting this way also put the
> Imbalance and Orphaned account as the first 2 entries.  I have my accounts
> filtered by View/Filter By.../Other and I removed all the check marks.  The
> accounts only display when they have a balance, which since they are at the
> top of the list really makes them stand out.
> >
> >
> > Thank You,
> > Gyle McCollam
> >
> > Gyle McCollam
> >
> > 609.680.2326                     Mobile
> >
> > gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email
> >
> > ________________________________
> > From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org>
> on behalf of Alan A Holmes <gnucash at alanaholmes.me.uk>
> > Sent: Sunday, June 12, 2022 3:12 AM
> > To: jaypj at comcast.net <jaypj at comcast.net>; gnucash-user at gnucash.org <
> gnucash-user at gnucash.org>
> > Subject: Re: [GNC] How to reorganize the account tree
> >
> > As Adrien said in his reply if you sort on the Account Name column it
> should
> > be okay.
> >
> > Personally, I sort on the Hidden column which I have displayed, mainly
> > because it puts the Imbalance and Orphan accounts together at the bottom
> of
> > the list and enables me to find errors in transactions quickly.
> > What I do notice sorting this way is that within the top level accounts
> > (Assets, Expenses, Income, etc.) that the 2nd and subsequent level
> Accounts
> > under Assets AREN'T sorted alphabetically, while those under Expenses and
> > Income ARE. I have insufficient sub-accounts under Equity and
> Liabilities to
> > be able to say.
> >
> >
> > Alan A Holmes
> >
> > -----Original Message-----
> > From: gnucash-user
> > <gnucash-user-bounces+gnucash=alanaholmes.me.uk at gnucash.org> On Behalf
> Of
> > jaypj at comcast.net
> > Sent: 11 June 2022 12:29
> > To: gnucash-user at gnucash.org
> > Subject: [GNC] How to reorganize the account tree
> >
> > I have been using gnucash for nearly 20 years. My account lists were a
> mess
> > until this spring when somehow I spent a day or two reorganizing
> everything
> > into a new and very well organized account tree.  For the life of me, I
> > don't remember how I was able to do that without losing the 20 years of
> data
> > stored in my accounts.  I would like to reorganize the order in which my
> > bank accounts are listed to make them in alphabetical order but I cannot
> > find a way to move the accounts in the account tree. I can go to the
> parent
> > account but that does not give me control to move the accounts around.
> >
> >                Can someone tell me how to move accounts around in the
> > account list.  Thank you.  Chin00kie
> >
> > _______________________________________________
> > 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.
> > _______________________________________________
> > 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.
>