Sales report by item

[R. Victor Klassen]

Things I’d like to be able to do, and I’m sure I could if I knew how to formulate and run database queries on the sqlite database.

> On Oct 18, 2017, at 6:23 PM, Roger Oliver <rmomxtx at gmail.com> wrote:
> 
> Are the queries in your second paragraph thinks you can do now or something we'd like to see? Thanks
> 
> On Oct 18, 2017 5:13 PM, "R. Victor Klassen" <rvklassen at gmail.com <mailto:rvklassen at gmail.com>> wrote:
> This seems like something that ought to be doable by the database-savvy among us.  Especially if you have a database (sqlite) back end.
> Unfortunately I’m not one of those.   The information is certainly there.  Other useful queries along similar lines are “tell me, by customer, how much of X was sold”, where X might be the description line in an invoice, or even the account.  And give me a massive report of all sales by customer within item or item within customer, and so on.
> 
> > On Oct 18, 2017, at 3:43 PM, Roger Oliver <rmomxtx at gmail.com <mailto:rmomxtx at gmail.com>> wrote:
> >
> > Thanks. So I'm not losing my mind after all.
> >
> > On Oct 18, 2017 2:13 PM, "Derek Atkins" <derek at ihtfp.com <mailto:derek at ihtfp.com>> wrote:
> >
> >> Hi,
> >>
> >> On Wed, October 18, 2017 2:50 pm, rmomxtx at gmail.com <mailto:rmomxtx at gmail.com> wrote:
> >>> Is there a way to get a sales report by item? Total sales for a day by
> >>> item
> >>> for example. The only indicators I can find would be the description
> >> field
> >>> on the invoice or the income or other account credited for the sale.
> >>> Thanks!
> >>> Roger
> >>
> >> You would certainly have to write your own report to do that.  You would
> >> need to search through all posted invoices, and for each invoice line-item
> >> determine the date and amount, and then collect all those tuples.  Then
> >> you can display it out.
> >>
> >> There is definitely no existing report that would do this.
> >>
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>
> >> -derek
> >>
> >> --
> >>       Derek Atkins                 617-623-3745
> >>       derek at ihtfp.com <mailto:derek at ihtfp.com>             www.ihtfp.com <http://www.ihtfp.com/>
> >>       Computer and Internet Security Consultant
> >>
> >>
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user <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.
>