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

Fran_3 mailbox0600 at yahoo.com
Sun Nov 10 19:50:33 EST 2019


 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.
  


More information about the gnucash-user mailing list