Account numbers in a Report

Wm... tcnw81 at tarrcity.demon.co.uk
Wed Feb 3 03:01:51 EST 2016


Tue, 2 Feb 2016 09:33:20 
<2440254.NSnkVYGmCF at calufrax.nottingham.standbyevents.co.uk>
Maf. King <maf at chilwell.net> wrote...

>On Sun 31 January 16 17:20:20 John R. Sowden wrote:
>> How do I display the account number in a report? When a Trial Balance is
>> open and I click on edit->report options, I don't get an option to
>> select column titles and data.
>>
>> Since I tried to enter a sample transaction for paying the rent, when I
>> entered rent under transfer, I got a message telling the the account
>> does not exist.  First I thought that gc was expecting me to enter Rent
>> vs. rent, but, no.  When I went to the Accounts list, where I have
>> entered my chart of accounts, rent was there. So when I entered 6130, in
>> the transaction transfer column, up popped rent.  By the way, when I had
>> entered rent, which could not be found, I clicked on the button in the
>> transfer column, where I expected to be shown those accounts with the
>> word rent in them. Not a chance.  I got my complete chart of accounts,
>> which I had to scroll through to find rent.
>>
>> This is why the Account Numbers (Account Code in GC) is so important.

GnuCash doesn't care much about human assigned account codes because it 
has unique internal IDs for each account (and other stuff too).  If you 
are really bugged about this use the account code as the account name in 
GnuCash.  Otherwise move on and accept that accounting systems don't 
need account codes AND account codes are just an outdated mechanism for 
forming accounting structures, aka, a CoA which GnuCash does in a much 
more natural way.

>> If it is important, I am running xubuntu 15.04 LTS and GC 2.6.1 (build
>> date 2/19/14), the most recent version that Unbuntu has in the repository.
>>
>> John
>>
>
>Hi John,
>
>I don't know about getting the account code in a report, as I don't use
>account codes.
>
>To directly address your issue of the "Rent" account and not being able to
>type it in the transfer column,  it sounds to me that you are not typing the
>full account name -  which would be something like "Expenses:Rent", rather
>than just "Rent"?
>
>If, in the transfer box, you type the following sequence of keys:  e x : r e
>then GC  is clever enough to limit your typing and help find the account for
>you.
>
>YMMV, of course, eg you might not have the account delimiter as a colon...

There's also
Edit / Preferences / Register defaults / Other defaults / Only display 
leaf account names
(phew)

Thing is I think it only works perfectly if you have one rent rather 
than say
Expenses:Home:Rent
and
Expenses:FolksHouse:Rent

in which case you may as well have
Expenses:Home:Rent.5100
and
Expenses:FolksHouse:Rent.6001
or some other combination

-- 
Wm...



More information about the gnucash-user mailing list