I'm trying to create a report from our Accounts Receivable database that shows all invoices within a parameter period. So I set up the parameters based on invoice date. I have the following fields selected:
Invoice.inv_no
Invoice.inv_dt
customer.cus_name
Invoice.inv_pd_dt
receipt.rct_no
receipt.ck_no
I want the report show the Invoice Number, Invoice Date, Customer Name, Invoice Paid date, receipt no and check no.
The problem is that as soon as I insert any field from the receipt database, it will only show invoices that are paid. I want it to show all invoices regardlesss if they are paid. Is this possible?
IP Logged
