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

[R. Victor Klassen]

I didn’t notice Bob’s reply only came to me - so I’m re-sending to the list.

Begin forwarded message:

> From: "R. Victor Klassen" <rvklassen at gmail.com>
> Subject: Re: Find/Report invoices with a particular line in a description field
> Date: December 2, 2014 at 7:31:39 AM EST
> To: Bob Brush <bobbrush3 at gmail.com>
> 
> Well, that more or less works.  
> 
> I certainly can’t understand why anyone would want to accumulate splits on post, so that’s not an issue.   And it comes to me as a surprise that it thinks the descriptions in an invoice are in the memo field, but there they are.   Of course that leaves me with a whole mess of raw invoices - I can’t for example, get the sum of the dollar values for red type A widgets without painfully extracting them from the list.  In other words it gives me the data, but still leaves a substantial manual step.
> 
> It will work in a pinch.   In the “I can’t remember where I got the bags” case, it should work fine.  But that was the simplest example.
> 
> Thanks.
> 
> 
> On Dec 1, 2014, at 8:10 PM, Bob Brush <bobbrush3 at gmail.com> wrote:
> 
>> You may or may not be able too!  There is a setting under preferences, business tab, it says accumulate splits on post, to be able to find stuff it needs to be off.  Under edit select find, then change description in the drop down to memo, type in the search term and hit find, it will bring up search results you need..  If it is set to accumulate then the odds it saved what you are looking for are slim, unless it was the first line, I think that is what it uses..   Also every time you post or unpost an invoice there is a check box on the do you really want to post dialog, so you can change old transactions for better or worse, just be careful not to change the dates accidentally, the default is to update for customers and stay the same for vendors..  I ran for a few years in accumulate mode, before I understood!
>> 
>> Bob
>> 
>>> 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.
>