simple find transactions report
Elmar
etschme at gmail.com
Thu Nov 2 12:05:31 EDT 2017
Thanks - I missed the transaction report option. Oops.
On 11/2/2017 11:28 AM, Christopher Lam wrote:
> Hi Elmar
>
> From the default Transaction Report, choose:
>
> Accounts/Accounts: select the Expenses:Discretionary:Travel, click
> 'Select children' which will select
> Expenses:Discretionary:Travel:Lodging etc
>
> Sorting/Primary Key: Date
> Sorting/Primary Subtotal: none
> Sorting/Secondary Key: Description
>
> or
>
> Sorting/Primary Key: Description
> Sorting/Secondary Key: Date
> Sorting/Secondary Subtotal: none
>
> Good luck!
>
> Next release 2.7 onwards will have arbitrary string searching.
>
> On 2 November 2017 at 22:59, Elmar <etschme at gmail.com
> <mailto:etschme at gmail.com>> wrote:
>
> Getting a report by payee/description for a set of dates across a
> set of accounts, is still opaque to me, though. I have a "travel"
> account under expenses-discretionary, that is itself split into
> lodging, travel, fees, etc. I am trying to retrieve all
> transactions from all these subaccounts sorted by payee and date to
> dump into a spreadsheet. Doing a "find" on the placeholder account
> "travel" gives me nothing at all. Do I have to go and learn SQL to
> get what I need?
>
> - Elmar
>
> On 10/10/2017 11:17 AM, Geert Janssens wrote:
>
> Heh, sorry. I'm not near a computer to verify my directions and
> won't be until next week...
>
> Glad you managed to decode my terse answer.
>
> Geert
>
> Elmar <etschme at gmail.com <mailto:etschme at gmail.com>> schreef op
> 9 oktober 2017 21:37:57 GMT+01:00:
> >Perfect! Thanks, although I had to translate this to the
> menu entry
> >"edit/find" (not "search")
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
More information about the gnucash-user
mailing list