Technically you can, *if* you don't 'accumulate splits' when posting.
Then those line items will show up in all affected registers and you can
use the Transaction Report's filtering options to get what you want. (or
do a Find and then an Account Report)
I wouldn't recommend un-posting and re-p
The query I showed in the previous email will show you what you paid for
whatsits, and this code will show you what you charged for dinguses,
limiting to a customer called Mycustomer
SELECT invoices.date_posted, invoices.id, invoices.notes,
customers.name AS customer,
description, quantity_num
While you can't do this directly from gnucash, if you use the sqlite
backend (or other sql backend) you can write your own queries
fairly easily. For example, you could save your gnucash file as an sqlite
file and use sqlitebrowser to view it and write queries
https://sqlitebrowser.org/dl/ (I'm sug
Hi,
Sorry, there is no way to search Invoice Line-Item data.
Unclear if PieCash can do that or not.
-derek
On Wed, August 25, 2021 2:51 pm, R. Victor Klassen wrote:
> I’m looking for a report or means of searching all bills/invoices for a
> specific pattern in the description field of any line. I
I’m looking for a report or means of searching all bills/invoices for a
specific pattern in the description field of any line. I would further like to
restrict it (optionally) by date range or customer/vendor.
For example I might want to know what we paid for whatsits last year and from
whom
