[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