Re: Sales report by item

2017-10-18 Thread 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 wrote: > > Are the queries in your second paragraph thinks you can do now or something > we'd like to see? Thanks > >

Re: Sales report by item

2017-10-18 Thread Roger Oliver
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" 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. > U

Re: Sales report by item

2017-10-18 Thread R. Victor Klassen
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

Re: Sales report by item

2017-10-18 Thread Roger Oliver
Thanks. So I'm not losing my mind after all. On Oct 18, 2017 2:13 PM, "Derek Atkins" 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 wou

Re: Sales report by item

2017-10-18 Thread Eduardo Estefano Neto
I have no skills to write such report. If someone eventually does write one, please let me know. It would be greatly appreciated. At the moment we are doing the report manually. On Wed, Oct 18, 2017 at 4:21 PM Derek Atkins wrote: > Hi, > > On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wro

Re: Sales report by item

2017-10-18 Thread Derek Atkins
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. > Thank