Invoice id:
Customer id:

Start date:Enable search by date
End date:


Show query statements

<h3>List of invoices from $startdate to $enddate monthly<h3> select a.invoiceid,a.description,a.amount,a.dateentered,a.payed,c.name,c.emailaddress, c.streetaddress,c.city,c.state,c.zip,c.phonenumber from invoices a,customers c where a.cid=c.cid select c.name,i.* from invoices i,customers c where i.dateentered>=$startdate and i.dateentered<=$enddate and c.cid=i.cid and i.suspend="N" and c.suspend="N" and i.payed!="Y" select sum(amount) as "Total overall",count(invoiceid) as "Count overall" from invoices where dateentered>$startdate and suspend="Y"