How many and how much invoice paid in every month

Discussion in 'Plugins & Reports' started by shahidi, Jan 28, 2015.

  1. shahidi

    shahidi Active Member

    Joined:
    Aug 29, 2011
    Messages:
    562
    Likes Received:
    41
    Hello,

    Would you please tell me how we can find how many and how much invoice paid in every month ?
    for example we wanted know how much we have received in Jan2015 ?

    Thank you
     
    #1
  2. CE-Matt

    CE-Matt Administrator Staff Member

    Joined:
    Aug 27, 2011
    Messages:
    1,571
    Likes Received:
    274
    The income growth report will show how much per month.

    You could run something like the following to get the actual number of paid invoices: SELECT count(*) FROM invoice WHERE status=1 AND datepaid like '2014-01-%';

    You'd have to change the '2014-01-%' each month/year you want to check against.
     
    #2
    shahidi likes this.

Share This Page