Sales History Query

unknown

I am trying to duplicate the "Receivables" - "Invoice Entry" - "Print Invoice Register" report. I need the information in this report in an Excel sheet, which Visual does not allow enough.

I want a query that will run all sales/invoices by customer in a certain date range.

Does anyone already have something like this?

 

Thank you,

Todd

 

unknown

I was able to get a query to work, showing the correct information. I need to be able to add a TO and FROM date to narrow the search. Does any one know how to get a date range into this?

SELECT RECEIVABLE.INVOICE_DATE, RECEIVABLE.INVOICE_ID, RECEIVABLE.CUSTOMER_ID, RECEIVABLE.TOTAL_AMOUNT
FROM RECEIVABLE

Todd