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