Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

Op vrijdag 23 februari 2018 09:50:02 CET schreef Colin Law: > On 22 February 2018 at 18:36, Fran_3 via gnucash-user < > > gnucash-user@gnucash.org> wrote: > > Scott, > > > > Thanks for your comments. As I mentioned to Adrien, I don't think I'm > > going to charge off and start developing my own

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

On 22 February 2018 at 18:36, Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote: > Scott, > Thanks for your comments. As I mentioned to Adrien, I don't think I'm > going to charge off and start developing my own gnuCash queries using any > tool. We are going to just use it out of the box

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

Thank you Adrien. Your comments have been very helpful. I'm running IIS and MySQL on my PC as I do some database work... having moved from Micrsoft Access... but I don't want to make all our small staff to have to be running a server and mysql. The way we have it setup is the gnuCash file is

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

Hi, Fran_3 via gnucash-user writes: > Re: Converting to MySQL... > When I develop in MySQL on Windows I install IIS localhost server and > MySQL... but that is not practical on other office computers. > 1 - I'm not familiar with sqLite but a quick Google makes me

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

I stand corrected and humbled. Perhaps I should be more careful to verify what I read, certainly before passing it along. Thanks for the lesson. Regards, Adrien > On Feb 21, 2018, at 3:41 PM, Fred Bone wrote: > > https://en.wikipedia.org/wiki/SQLite#History

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

On 21 February 2018 at 14:04, Adrien Monteleone said: [...] > SQLite is a flat-file db using SQL principles. It has some limitations and > doesn’t work well for all situations. iTunes is probably the most widely > used app to employ it. (I think it was even designed by Apple especially > for

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

If you need MySQL, you have to install a MySQL server. (on any platform that doesn’t have it included) IIS is one way to do that on Windows. You can also install a WAMP stack. (Windows, Apache, MySQL, PHP) There are one-click installs available online. I would highly recommend installing

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

Re: Converting to MySQL... When I develop in MySQL on Windows I install IIS localhost server and MySQL... but that is not practical on other office computers. 1 - I'm not familiar with sqLite but a quick Google makes me think it is a way to run MySQL on a local PC without running server

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

In order to use SQL on the Gnucash data, it needs to be saved in that format. This requires the particular backend drivers (sqlite3, MySQL) be installed already for the format to be available as a choice in the Save As dialog. See the installation notes on the wiki for more info. There is no

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

Thanks Adrien, Regarding custom reports... I do SQL but am having gnuCash save account files in it's default XML format. Where would I get a list of the tables in gnuCash and their associated fields/columns? Is there a window I can open to just put in an SQL query or what? Can I create an SQL

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

You could leverage a multi-column report perhaps with a customer report in each column, that will get you invoice & payment detail, but no aggregate totals across all customers. (but each customer would have it’s own total) Then there is the P/Income Statement, but it will show you revenue by

Monthly Billings Report ? (How much business did we book/Invoice during month X)

I'm sure there is a way but I haven't found it yet... How do we run a report to see how much business we booked/invoiced for a particular month?Total and/or including a list of customers and amounts? Ditto for  a specified period of time... current quarter, last quarter, so far this year... so