Re: [GNC] Which report to use?

2020-12-16 Thread Adrien Monteleone

Rich,

I'm still learning...

I'll add that the Transaction Report has a Filter option where you can 
choose to include or exclude transactions that have matching text in 
'Description, Notes, or Memo' fields. (you can't specify which though) 
And you can use Regular Expressions for a really complicated criteria. 
But simple text matches are easy.


Regards,
Adrien

On 12/16/20 5:30 PM, Rich Shepard wrote

I'll learn how to effectively use Find.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Which report to use?

2020-12-16 Thread Rich Shepard

On Wed, 16 Dec 2020, Adrien Monteleone wrote:


Sure it does, the first part of a criteria is the field to search. By
default, that is description. You have many options, including Notes
alone, or as part of 'Description, Notes, or Memo'.


Adrien,

Okay, I missed that ...


Be careful here though. You need to do your Finds from the Accounts tab.
It is possible to do them from a register, but results aren't always what
you might expect.


... and this is probably why I did.


You can either keep doing Finds from subsequent results tabs to narrow the
search (to include or exclude transactions that meet the new criteria) Or
you can craft a single multi-criteria Find.


I'll learn how to effectively use Find.

Thanks again,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Which report to use?

2020-12-16 Thread Adrien Monteleone
Sure it does, the first part of a criteria is the field to search. By 
default, that is description. You have many options, including Notes 
alone, or as part of 'Description, Notes, or Memo'.


Be careful here though. You need to do your Finds from the Accounts tab. 
It is possible to do them from a register, but results aren't always 
what you might expect.


You can either keep doing Finds from subsequent results tabs to narrow 
the search (to include or exclude transactions that meet the new 
criteria) Or you can craft a single multi-criteria Find.


Regards,
Adrien

On 12/16/20 4:31 PM, Rich Shepard wrote:

On Wed, 16 Dec 2020, Adrien Monteleone wrote:


Though a carefully crafted Find ...


Adrien,

Find apparently does not look in the Notes for the search string. That's
where the unique string is located.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Which report to use?

2020-12-16 Thread Rich Shepard

On Wed, 16 Dec 2020, Adrien Monteleone wrote:


Though a carefully crafted Find ...


Adrien,

Find apparently does not look in the Notes for the search string. That's
where the unique string is located.

Regards,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Which report to use?

2020-12-16 Thread Rich Shepard

On Wed, 16 Dec 2020, Adrien Monteleone wrote:


Though a carefully crafted Find (or series of them) should narrow down
those desired transactions, you also have View > Filter By... at your
disposal which might hide any undesirables that remain which meet the
available criteria. (but Find also allows you to choose to exclude
transactions from results, so it is probably more powerful)


Adrien,

Thanks very much.

Regards,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Which report to use?

2020-12-16 Thread Adrien Monteleone
Though a carefully crafted Find (or series of them) should narrow down 
those desired transactions, you also have View > Filter By... at your 
disposal which might hide any undesirables that remain which meet the 
available criteria. (but Find also allows you to choose to exclude 
transactions from results, so it is probably more powerful)


Regards,
Adrien

On 12/16/20 12:09 PM, David Carlson wrote:

You use the search function to do the editing, then simply print the
results with the account report. If you want to hide some of the details
you could print to PDF then open the PDF with a spreadsheet app and
manipulate the data there.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Which report to use?

2020-12-16 Thread Rich Shepard

On Wed, 16 Dec 2020, David Carlson wrote:


You use the search function to do the editing, then simply print the
results with the account report. If you want to hide some of the details
you could print to PDF then open the PDF with a spreadsheet app and
manipulate the data there.


Thanks, David.

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Which report to use?

2020-12-16 Thread David Carlson
You use the search function to do the editing, then simply print the
results with the account report. If you want to hide some of the details
you could print to PDF then open the PDF with a spreadsheet app and
manipulate the data there.

On Wed, Dec 16, 2020 at 11:19 AM Rich Shepard 
wrote:

> On Wed, 16 Dec 2020, David Carlson wrote:
>
> > From that description it sounds like you want to nearly arbitrarily pick
> a
> > few transactions to print out.
>
> David,
>
> That's true. Four transactions involving two accounts.
>
> > I would use the search function starting from the chart of accounts to
> > pick those needles out of the haystack then use the Account Report.
>
> I'll see if the Account Report can be edited to show only specific
> transactions in the two accounts.
>
> Thanks,
>
> Rich
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Which report to use?

2020-12-16 Thread Rich Shepard

On Wed, 16 Dec 2020, David Carlson wrote:


From that description it sounds like you want to nearly arbitrarily pick a
few transactions to print out.


David,

That's true. Four transactions involving two accounts.


I would use the search function starting from the chart of accounts to
pick those needles out of the haystack then use the Account Report.


I'll see if the Account Report can be edited to show only specific
transactions in the two accounts.

Thanks,

Rich

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Which report to use?

2020-12-16 Thread David Carlson
>From that description it sounds like you want to nearly arbitrarily pick a
few transactions to print out.  I would use the search function starting
from the chart of accounts to pick those needles out of the haystack then
use the Account Report.

On Wed, Dec 16, 2020 at 9:44 AM Rich Shepard 
wrote:

> I want to print a report that shows 4 transactions: an initial debit to
> checking account/credit to current liabilities, and 3 credits to checking
> account/debit to that current liability account.
>
> Which report on the Reports menu would be most appropriate for this task?
>
> TIA,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Which report to use?

2020-12-16 Thread Rich Shepard

I want to print a report that shows 4 transactions: an initial debit to
checking account/credit to current liabilities, and 3 credits to checking
account/debit to that current liability account.

Which report on the Reports menu would be most appropriate for this task?

TIA,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.