Skip to Content
0
Former Member
Aug 18, 2015 at 01:31 AM

Total sales query with name select

39 Views

Hi All

Trying to create a total sales query with following parameters -

Date from-to

Total invoice value less credit notes

Number of invoices

Where customer name contains xxxx

I can get to the point of individual invoices but would just like a sum of total value within that period.

Many thanks in advance.