Daily invoicing totals report

I would like a report that shows me our daily sales invoice and credit note totals, doesn’t matter about any other details, just the total sum, preferably ex and inc vat but either would do. I have scoured the internet and sage city but do not seem to be able to find anyone else who has done or who is looking to do this.  I also do not know enough about report building to have a go without some pointers. Any advice gratefully received!

  • 0

    I've created an invoice summary report that sums Gross and Net for a range of dates set by the user  but can't get rid of the detail line otherwise it doesnt summarise.

    Open Report Designer ; Click - File -New - Report  - Select Invoice - click next . Select FIelds box - click the plus next to INVOICE. SCroll down  to INVOICE_GROSS , click ther single right hand arrow then do the same for INVOICE_NET. Click Next. CLick Next. CLick Next. CLick Next. Type something meaninigful in the Report Name , Click Finish. CLick Report Click Criteria . Click INvoice_Date and click modify. Click Status box. Select Enabled. Click OK Click OK. CLick View. Click Preview. CHange date criteria. Click OK . See waht comes up. If OK save the report as something meaniningful.

    If really required I can supply my test report