Note: To run a detailed report for reconciliation purposes which shows outstanding invoices, run the Open Invoice report

To create a query:
  1. In Query, create a new Query
  2. Select Invoice as the Type and Dynamic as the Format and click OK
  3. Select the Criteria Tab > Expand Invoice
  4. Under Invoice, double click Invoice Status > Select an operator of does not equal and select paid for the value
  5. Under Invoice, double click Invoice Status again on the left hand side > Select an operator of does not equal and select deleted
  6. Enclose the 2 invoice status lines in parenthesis using the parenthesis at the bottom of the window.
  7. The right hand side of the Criteria tab should now appear as so:enclosed in parenthesis
  8. Additionally on the Criteria tab, select Invoice > Invoice date > select an operator of between and enter the start and end dates
  9. Select the Output Tab > Expand Invoice and add any desired fields, such as Invoice number, Invoice Amount, Remaining Balance (from under Summary), etc.
  10. Sort as desired
  11. Select the Results Tab or click Run