Find/Report invoices with a particular line in a description field

[Bob Brush]

After the find function returns results in what looks like a register select the report menu and run the report titled "account report" it will open up a nice search results report, now pick the file menu, export, and export report, name the file something  like searchresults.gnumeric and save somewhere probably your desktop or documents..  If you have gnumeric installed, if not use the extension Xml.  Now you can click on it and it will open in numeric, if you press save it will write a little code into the file defining the file type and setting up pages or worksheets and then compress the file using gzip.  But that's up to you.  Now you can sort the data and all the standard stuff..  I know it could be a little better, maybe some fine tuning in the future?

Bob

> On Dec 2, 2014, at 9:33 AM, R. Victor Klassen <rvklassen at gmail.com> wrote:
> 
> I had the same thought a few minutes ago.  I may well do this.   It would be a nice to have feature year round, but right now, I’m thinking of annual planning, and for that, a save-as approach would then let me write code to parse and extract anything I want to dump to a spreadsheet.
> 
> And one of these days I’ll get a working GNUcash development environment on my machine.  Failed to do so last year before the busy season came, but maybe this season…
> 
> 
>> On Dec 2, 2014, at 8:09 AM, Maf. King <maf at chilwell.net> wrote:
>> 
>> You could always "save as" out of your master sql format file to a temporary 
>> xml for the purposes of searching.... yeah, a bit kludgey.
>> 
>> Just a thought,
>> Maf.
>> 
>> 
>> 
>>> On Tue 2 December 14 07:37:12 R. Victor Klassen wrote:
>>> I gather you use xml.  I’m using sqlite, because, despite the issues with
>>> possible corner cases not being fully tested and debugged, I prefer to have
>>> transactions committed when I hit enter.  I tried XML for awhile, and then
>>> we had two power outages in a month.  Switched to sqlite, and the power has
>>> been relatively stable ;-)
>>>> On Dec 1, 2014, at 8:16 PM, Bob Brush <bobbrush3 at gmail.com> wrote:
>>>> I don't know if you are a Linux guy, but if so you can use a program
>>>> "zcat" and "grep" your file to find anything, it's a beautiful thing in
>>>> there, everything plain text, descriptions, so nice.. I had to once when
>>>> I was on a fishing trip for a customer name and I could only remember
>>>> part of the notes..> 
>>>>> On Nov 29, 2014, at 10:46 AM, R. Victor Klassen <rvklassen at gmail.com>
>>>>> wrote:
>>>>> 
>>>>> Greetings all,
>>>>> 
>>>>> To give a concrete example, suppose 40 or so different income accounts
>>>>> associated with different things I sell.  One of these might be widgets
>>>>> of type A.  And so I have an account for type A widgets, and can easily
>>>>> see how much I’ve made in type A widgets, although not how many (unless
>>>>> they are always at the same price), nor whether the red, green or yellow
>>>>> ones generated the most income.  There are limits to how bushy I want to
>>>>> make the account tree, so I don’t have a separate account for each
>>>>> colour of type A widget.
>>>>> 
>>>>> Oh, and I also sell these widgets singly, by the dozen, and by units of
>>>>> 100 and 1000, with the price each dropping as the volume goes up.   So
>>>>> it really doesn’t make sense to have an account for every way they get
>>>>> sold.
>>>>> 
>>>>> But here’s my question.   How do I find the invoices containing at least
>>>>> one entry for a red type A widget?  I know the information is in there,
>>>>> but can I get all the type A widgets reported by what it says in the
>>>>> invoice description?
>>>>> 
>>>>> This is a similar question to - I bought a case of bags in which to sell
>>>>> my widgets - once - and since it is a rare thing to do I recorded it
>>>>> under “supplies” - which isn’t at all rare - and now I don’t remember
>>>>> who the supplier was.  How do I search the bills to find one for bags?
>>>>> _______________________________________________
>>>>> gnucash-user mailing list
>>>>> gnucash-user at gnucash.org
>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>> -----
>>>>> 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
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> -- 
>> Maf. King
>> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
>