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