The invoice Status is Open because the Discount Offered is different than the Discount Lost or Discount Taken.

Possible scenarios

Negative distributions

The discount amount on the Invoice record doesn't match the sum of the discount amounts on the Distribution records. It includes a negative distribution and discounts don't apply to negative amounts.

Discount amount changed

The discount amount was changed to a partial amount when recording a payment. Change the invoice to adjust the discount amounts.

Identify the discount amounts

Identify the Discount Offered, Discount Taken, and Discount Lost amounts on the invoice and distributions.

1. In Accounts Payable, select Inquiry, Invoice Inquiries, Invoice Register.
2. Select the Master file, then click OK.
3. Select the Register file, then click OK.
4. Find the vendor, then double-click on the vendor to drill down to the Invoices.
5. Find the Invoice.
6. Add columns for Status, Discount Taken, and Discount Lost. If the Discount Offered is missing, add the column back to the inquiry.
7. Verify the Original Amount and Amount Paid match but the Status shows as Open.
8. Compare the Discount Offered with the Discount Taken and Discount Lost.
   • Discount taken: The Discount Offered and Discount Taken should match
   • Discount not taken: The Discount Offered and Discount Lost should match
9. Make note of amounts that don't match.
10. Double-click on the invoice to drill down to the Distributions.
11. Add columns to the inquiry for Status, Discount Offered, Discount Taken, and Discount Lost.
12. Compare the Discount Offered with the Discount Taken and Discount Lost for each distribution.
    • Discount taken: The Discount Offered and Discount Taken should match
    • Discount not taken: The Discount Offered and Discount Lost should match
13. Make note of any distributions that don't match.
14. Total of the distributions' Discount Offered, Discount Taken, and Discount Lost. Confirm if the total matches the amounts on the invoice level.
15. For multiple distributions, use the Print button to send this inquiry view to a report that totals the distributions.

Alternate identification methods

You can use the attached reports to help identify the differences.

The AP Discounts Verification: Invoice vs Distribution report compares the sum of the discount amounts on the distribution level with the invoice level. It prints those that don’t agree.
Attachment: APDiscountsVerificationInvoiceVSDist.rpt

The AP Discounts Verification: Offered vs Taken or Lost report compares the Discount amount with amounts Taken or Lost on paid invoices. It prints those that don't agree.
Attachment: APDiscountsVerificationOfferedVSTakenLost.rpt

You can add the reports to your AP Reports menu.

Options to correct the invoices

Follow these steps if all these are true:

• The Discount Offered, Discount Taken, and Discount Lost match between the invoice level and the total of the distributions
• The Discount Offered doesn't match the Discount Taken/Discount Lost

1. Select AP Settings, Invoice Settings.
2. Check the Discount usage setting to determine if you need to make changes at the invoice or distribution level.
3. Select Tasks, Change Invoices.
4. Select the invoice.
5. Change the Discount amount to equal the Discount Taken/Discount Lost amount at the level determined in step 2.
6. Accept your invoice changes.
7. Click Finish.
8. Verify the invoice no longer appears on the Open Invoice Register report.

Follow these steps if all these are true:

• The Discount Taken/Discount Lost match between the invoice level and the total of the distributions
• The Discount Offered is incorrect on either the invoice or distributions

Sometimes, you can go into Change Invoices and correct the Discount amount. Change it at the invoice level to match the sum of the discounts on the distributions without having to change the AP Settings. If that doesn't work, then continue with the workaround below.

1. Select AP Settings, Invoice Settings.
2. Change the Discount level to Distribution.
   • The Discount won't prefill when set to Distribution level unless the Tax Usage feature is turned on.
3. Click OK to exit Invoice Settings.
4. Click OK to exit AP Settings.
5. Select Tasks, Change Invoices.
6. Select the invoice.
7. TAB or ENTER to get to the distributions.
8. If any distributions had an incorrect Discount Offered amount, go to those distributions and correct the Discount amount. If the Discount Offered amount was only incorrect at the invoice level, retype the Discount amount on any distribution. This forces a recalculation of the total Discount Offered and update the amount at the invoice level and update the invoice Status to Fully paid.
9. Click Accept Invoice.
10. Click Finish.
11. Verify the invoice no longer appears on the Open Invoice Register report.

AP fully paid invoice still has an Open status after recording a payment and taking a partial discount
Fully paid Accounts Payable invoice shows as open on task or report