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

[Adrien Monteleone]

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