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 <rmom...@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" <rvklas...@gmail.com > <mailto:rvklas...@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 <rmom...@gmail.com > > <mailto:rmom...@gmail.com>> wrote: > > > > Thanks. So I'm not losing my mind after all. > > > > On Oct 18, 2017 2:13 PM, "Derek Atkins" <de...@ihtfp.com > > <mailto:de...@ihtfp.com>> wrote: > > > >> Hi, > >> > >> On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com > >> <mailto:rmom...@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 > >> de...@ihtfp.com <mailto:de...@ihtfp.com> www.ihtfp.com > >> <http://www.ihtfp.com/> > >> Computer and Internet Security Consultant > >> > >> > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org <mailto:gnucash-user@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. > _______________________________________________ gnucash-user mailing list gnucash-user@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.
