[GNC] How to create Report on Checking & Exclude one Entity ?

[Christopher Lam]

The good news is negate search (both simple substring and regex) will be
available on transaction-report based reports for 3.8 onwards due early
January.

Or you could try a recent build on
https://code.gnucash.org/builds/win32/maint/ -- these should have a bunch
of recent fixes, and no known regressions.

On Mon, 11 Nov 2019, 08:52 Fran_3 via gnucash-user, <
gnucash-user at gnucash.org> wrote:

>  Adrian, Thanks for the response.
> I have to admit I have done regular expressions... but I often tire of the
> fight... as I ultimately did in this case.
> My solution in this particular case was to port the gnuCash check register
> into a spreadsheet and manipulate it from there to exclude the target
> entity and ultimately get the desired result.
> Fran3
> PS - I did try running a Transaction Report on Checking and then hit Ctl F
> and searched the Description for the entity name using the "does not match
> regex" option... but the results were confusing to  me...
>
> Actually I was unsure if I should just enter the entity name in the "does
> notmatch regex" search field...
>  or if I should enter a regular expression...
>
> but just entering the entity name... Vendor X... didn't seem to return all
> checking transactions except those to/from Vendor X.
>
>
>
>
>
>
>
>     On Sunday, November 10, 2019, 6:37:23 PM EST, Adrien Monteleone <
> adrien.monteleone at lusfiber.net> wrote:
>
>  You have two options, but both require a negative regex, which while
> possible, might not be part of the regex library used by GnuCash. (I don’t
> know, you’d have to try it out)
>
> #1 - Transaction Report (as requested) with regex *not matching* a string
> in the Filter field. (it will return transactions that do not match that
> string in the Description, but also the Notes & Memo, which may or may not,
> be okay.)
>
> #2 - Find, followed by Account Report - same regex expression, but with
> the ability to *only* filter on the Description and not also the Notes and
> Memo fields.
>
> Which you use is up to you, or which one actually works at all. (if either)
>
> Please do let us know if you manage this as I’m sure others would be
> interested.
>
> Regards,
> Adrien
>
> > On Nov 10, 2019 w46d314, at 9:21 AM, Fran_3 via gnucash-user <
> gnucash-user at gnucash.org> wrote:
> >
> > I guess I suffering from project fatigue on this exercise as, all of a
> sudden, I cant run a Transaction Report on Checking and then exclude all
> transactions to a particular entity... Vendor X
> > I thought I had done this before but... maybe not.
> >
> > Without grinding through all the attempts I've made this morning would
> some kind soul just tell me how to do this...
> > And note... the entity name has two words in it... "Vendor X" in this
> example... both of which are necessary for unique identification.
> > Thanks for any help. Fran3
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>