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

David Carlson david.carlson.417 at gmail.com
Mon Dec 1 15:30:34 EST 2014


On 12/1/2014 1:24 PM, Derek Atkins wrote:
> Hi,
>
> "R. Victor Klassen" <rvklassen at gmail.com> writes:
>
>> 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?
> Unfortunately right now so just search is available.
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> -derek
>


I do not use business features, so I cannot help with searching
invoices, but for your question about who you bought bags from, if you
remembered to put the word bags in the memo line when you recorded the
transaction purchasing the bags, you could go to the Accounts window,
type Ctrl+F, then select Memo Contains bags in the search criteria. 
When you start from that window, the search will go through all accounts
looking for that word.  If you use two-line register display you may
have put that word in the field named Notes, so you could change the
search to look for any criteria and add a criterion Notes contains bags.

David C


More information about the gnucash-user mailing list