Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-22 Thread Chris Good
m: Fran_3 > > To: Gnucash Users , Adrien Monteleone > > > > Subject: Re: [GNC] How to compare 2 Transaction Reports to find orphan > >transactions > > Message-ID: <1766876513.1811024.1573323422...@mail.yahoo.com> > > Content-Type: text/plain; charse

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-10 Thread Adrien Monteleone
You’re welcome. Note as well, the Help Guide documents each menu in each context. While it may seem rather mundane at first, there are a few gems to glean from looking it over. This was one I stumbled on a while back and noticed that the menu entries change depending on the current tab.

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Fran_3 via gnucash-user
Christopher said "You've stumbled upon a limitation SFX of regular expressions on filtering the transaction report." My Question: Wikipedia list numerous definitions for SFX... in this case what? (Self Extracting Software or what?) Greg Francis suggested NotePad++ My Response: Yes, I am a

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Fran_3 via gnucash-user
Adrian, you said... "instead do a Find operation then run an Account Report instead of a Transaction Report. (since Find can filter on more fields)" My comment: I did not know about the "Account Report"  option... It seems it only appears under the Reports Menu if you are looking at a register

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Christopher Lam
Oops. The regex filter is a late addition from 2017. Unfortunately regex negate string match (I.e. match not containing a string) is a general weakness of POSIX regex. May I suggest file an enhancement request in Bugzilla? On Sat, 9 Nov 2019, 23:38 Christopher Lam, wrote: > Hi Fran > > You've

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Greg Feneis
If the reports you're interested in comparing are text based, and your computer's OS allows you to use Notepad++, you might consider using Notepad++ to compare the two files. Notepad++ is a free open source text editor that has a great file comparison tool. Kind regards, Greg Feneis On

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Christopher Lam
Hi Fran You've stumbled upon a limitation SFX of regular expressions on filtering the transaction report. You may be aware that the transaction report was, for many years, the most versatile report to extract information from a Gnucash data file. It had severe limitations and bugs and On Sat, 9

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Adrien Monteleone
I forgot to mention, when trying to craft a better resulting report, ask yourself, “What makes the transactions on either report not show up on the other?” Then use *that* info to craft the intended report. (as it is the set of transactions you are looking for) Regards, Adrien > On Nov 9,

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Adrien Monteleone
I would say consider the criteria you used to create the set of transactions for each report, then try to craft a report using the options that gives you only those that don’t lie in the joint set. If *every* transaction on both reports is between two and only the *same two* accounts then you

[GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Fran_3 via gnucash-user
I want to compare Transaction Report A to Transaction Report B and find transactions that appear on one report but not on the other... aka orphan transactions In past I have either... - Done a screen capture of each, pasted them side by side in PC Paint and marked off matching transactions one