Invoice Match

R12: System Allows To Match Invoices To A Closed PO APP-SQLAP-10074 and APP-SQLAP-10080 Warning Messages (文档 ID 1331770.1) 转到底部转到底部

In this Document


Symptoms

Cause

Solution

References

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.  

 

For details on how to remove a Final Matching Hold please see Doc ID 1447955.1

 

Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.

 

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?
请使用浏览器的分享功能分享到微信等