Invoice not found for distributions that still exist in Accounts Payable
Description
Cause

An invoice with multiple distributions had a payment that paid the full amount of the invoice but paid only one or some of the distributions. The remaining distributions are positive and negative amounts that net to zero. When the payment was voided, Restore open invoices was unmarked, and since the payment amount was the same as the invoice amount, the invoice record is deleted even though there are distributions that still exist.

For example, an invoice for $1000 has the following distributions:

  • Dist 1: $1000
  • Dist 2: -$500
  • Dist 3: $500

Distributions 2 and 3 were entered to reallocate amounts to a different expense account or job, etc.

Distribution 1 was paid with one check. Distributions 2 and 3 were paid with a 0.00 check.

The $1000 check, which paid distribution 1, is voided and Restore open invoices is not selected. Because the payment paid the full amount of distribution 1, distribution 1 will be deleted, and since the invoice amount will be reduced to 0.00, the invoice record is also deleted.

This leaves distributions 2 and 3 without an invoice record.

Resolution
You may need to review the AP Transactions to determine what occurred with this invoice. Refer to How can I view transaction detail of a deleted invoice in Accounts Payable?

If distribution 1 is one of the distributions that was not restored when the payment was voided, you can use the following workaround:

  1. In AP Tasks, Enter Invoices, re-enter the invoice for 0.00 amount and distribution 1 for 0.00 amount.
  2. After finishing and posting the invoice, the other payment(s) can be voided if needed.
    • WARNING: If you void the other payments, leave Restore open invoices selected. If it is not selected, the invoice record will be deleted again except you will not be able to use this workaround again because distribution 1 already exists. The re-entry of the invoice will reject with the error: "Error while writing, replacing or deleting distribution." This then becomes a file fix situation.

If distribution 1 was not one of the distributions that was deleted when the payment was voided, then a file fix is needed. Contact Sage 300 CRE Support to request a file fix with Sage Professional Services Group (there is a fee associated with these services).

TIP: To avoid this situation, it is best practice to always leave Restore open invoices selected when voiding payments. Then make adjustments to the invoice in Change Invoices if needed.


[BCB:156:Chat 300 CRE US:ECB]

Steps to duplicate
Related Solutions

How can I view transaction detail of a deleted invoice in Accounts Payable?
Error: "Invoice not found in the master file. Payment not voided"
An Accounts Payable invoice appears in Select Invoices to Pay with "Invoice not found" displayed