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