If running the Open Invoice Report for reconciliation purposes, and it is incorrect because it does not match General Ledger follow the steps in How to reconcile to General Ledger.

If running the Open Invoice Report in the Reconciliation Reports section it is designed to only include Posted and Do not post invoices.

Try each of the following steps in order until the issue is resolved:

  1. Verify the dates on the report match the dates of the incorrect transactions
    1. Open the report and note the dates for:
      • Show invoice open as of
      • Transaction Date Range
      • Post Date Range
      • Due Date Range
    2. Open the invoice that is showing incorrectly on the Open Invoice Report
      1. Note the Transaction Date, Post Date and Due date.
        If these do not match the parameters of the report either:
        • The report is correct and no changes need to be made.
        • The report is being run incorrectly, and we need to modify the report parameters
        • The invoice was entered with the incorrect dates, and it needs to be adjusted.
  2. Verify that the invoice meets the criteria for being open
    1. Open the Invoice record and verify the status
      • If the invoice is pending or approved it should be appearing on the Open Invoice Report.
      • If the invoice is Paid by a check verify the check dates
        • On the Payments/Credits tab note the payment date.
        • If this is before the dates on the report the invoice should not be showing. If it is after it should be showing.
      • If the invoice is Paid by a Credit Memo verify the credit memo dates.
        • On the Payments/Credits tab open the credit memo.
        • Click Application History and note the application post date.
        • If this is before the dates on the report the invoice should not be showing. If it is after it should be showing.
      • If the invoice is deleted verify the reversed on date
        • If this is before the dates on the report the invoice should not be showing. If it is after it should be showing.
    2. Based on what is found, if needed make the appropriate adjustment to the report, invoice or payment.
  3. If running a saved report create a new report parameter.
  4. Verify the filters are all set as desired.
    Note: To test change the all filter selections to All, and run the report