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

[R. Victor Klassen]

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
> 
> 
>