[GNC] Understanding Transaction Report options

brb msi1 at earthlink.net
Fri Jan 10 16:16:47 EST 2020


I have top level accounts Banks and Credit Cards.  Under Banks I have
sub-accounts Checking and Money Fund.  Under Credit Cards I have
sub-accounts Discover, Master Card, and Visa.

I may pay phone charges from any of these sub-accounts, recording the
entries under the Transfer account Expenses:Telephone.

At year end I want a transaction report on Expenses:Telephone.  I do the
following:

- Select the Accounts tab, then Reports>Transaction Report
- Click Edit report options in the Transaction Report tab
- On the Account tab, Expand the Bank and Credit Card accounts and use
Ctrl^Click to select the Checking, Money Fund, Discover, Master Card, and
Visa sub-accounts.  Select Filter Type> Include Transaction... and select
the Bank and Credit Card sub-accounts again in the Filter by box.
- On the Filter tab, enter :Telephone in the Account Name Filter
- On the General tab I select Start and End of Previous Year, as I am
reporting on 2019.

The report returns no data, as shown below:

-----

Telephone Transaction Report:

No accounts selected

This report requires accounts to be selected in the report options.

Edit report options

Display / Account Code : Enabled
Display / Other Account Name : Enabled
Accounts / Filter By... : RMBT Checking, RMBT Money Fund, Discover, Master
Card, Visa
Accounts / Accounts : RMBT Checking, RMBT Money Fund, Discover, Master Card,
Visa
Accounts / Filter Type : include
General / End Date : relative . end-prev-year
General / Report name : Telephone Transaction Report
General / Start Date : relative . start-prev-year
Filter / Account Name Filter : :Telephone

-----

I can obtain the data I want in a round-about way by turning off
Account>Filter Type and Filter> Account Name and sorting on Other Account
Name.  Expenses:Telephone will subtotal in the report that covers all
transactions for the year.  The report parameters are:

Display / Account Code : Enabled
Display / Other Account Name : Enabled
Display / Use Full Other Account Name : Enabled
Sorting / Secondary Key : none
Sorting / Primary Key : corresponding-acc-name
Accounts / Accounts : RMBT Checking, RMBT Money Fund, Discover, Master Card,
Visa
General / End Date : relative . end-prev-year
General / Report name : Telephone Transaction Report
General / Start Date : relative . start-prev-year

If I add the Filter>Account Name ':Telephone" to this report, I get no data.

What am I doing wrong?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


More information about the gnucash-user mailing list