Deleted invoice shows credit balance on the Open Invoices with Cut-off Date report
Description
Cause

The Open Invoices w/Cut-off Date report shows the balance of an invoice as of the cut-off date you entered. If the transactions associated with the invoice include entries before the cut-off date, it affects the report. For example, an invoice with negative transactions before the cut-off date appears as a credit.

Example

  1. Invoice entered with 01/31/2025.
  2. Invoice deleted with 12/31/2024.
  3. You run the report with a cut-off date of 01/15/2025.
  4. The invoice shows as a credit because the report only picks up the deletion.

Scenarios

  • You paid the invoice before the cut-off date, but the invoiced and voided after the cut-off date
  • You entered the invoice after the cut-off date, but deleted it before the cut-off date
  • The invoice was a credit invoice entered in the past, but you deleted it to a current posting period
Resolution

Review the invoice

  1. Run the Report AP Transaction List report.
  2. Select the AP Master file.
  3. Enter the Invoice number.
  4. Review the transactions and use the appropriate solution.

No correction needed

You correctly deleted the invoice to an active accounting period and don't need to change it. Use the AP Transaction List Report to supplement your other reports.

Invoice voided after cut-off date

See steps to correct the void date for an Accounts Payable invoice.

Invoice deleted before the cut-off date

Determine if you need to correct the date or if you can leave it as is. The report will correct itself on the future date.

If you need to correct the date, see steps to correct an Accounts Payable invoice deleted with the wrong accounting date.

Steps to duplicate
Related Solutions

Multiple changes to invoices didn't post correctly