In this Document
APPLIES TO:
Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.
SYMPTOMS
-
Error trying to match PO that has already been fully matched
-
APP-SQLAP-10074: This purchase order line is closed. You may want to review the purchase order before continuing with this match.
-
User is allowed to click OK
-
After entering the match qty/amount clicking Match results in another error
-
APP-SQLAP-10080: This match will result in an overbill
-
User can complete the match
-
System allows matching Invoices to a Closed PO
CAUSE
Intended and expected behavior
SOLUTION
This is the intended functionality of the application intended to stop the user or warn the user that the purchase order/receipt has already been fully matched to another invoice.
This is a warning. users can still proceed by pressing ok button to match the invoice.
System will allow overmatching but applies a hold according to the tolerance defined. (Setup > Invoice > Tolerances)
To prevent this PO from being available for matching, and remove it from the LOV, the status needs to be changed to Finally Closed.
System allows a Closed PO to be matched to an Invoice.
System does NOT allow a Finally Closed PO to be matched to an Invoice.
If users are able to match to a Finally Closed PO then please see
Doc ID 1158087.1 for a solution.
In Payables Options you will need to setup the following:
Allow Final Matching - Select this option to allow final matching of purchase order matched invoices. You can indicate a final match when you match an invoice to a purchase order during invoice entry or when you adjust a matched invoice distribution. Select this option only if you want to allow the option of permanently closing the purchase orders. Once a purchase order is permanently closed, you cannot reopen the purchase orders
How to remove a final matching hold
If you have an invoice distribution which has been matched to a final closed PO, the invoice will get a FINAL MATCHING hold.
There are 2 ways of final closing a PO line:
1. When you match an invoice to the PO line, you can set the field "final match" to Yes. This is on the same form where you enter the amount and quantity you are matching.
2. You can manually Final Close a PO through purchasing. The form is called Control Purchase Orders. Once you have final closed a PO, the very NEXT time that you try to match an invoice to the PO, you will get the final matching hold. The hold is placed on the invoice when you run AutoAapproval.
REFERENCES
NOTE:1158087.1 - R12: System Allows To Match Invoices To A Finally Closed PO
NOTE:1447955.1 - R12: Why Is Final Match Hold Applied On An Invoice and How Can It Be Released?