Tuesday 13 March 2012

How to delete Old Invoices from AP_INVOICES_ALL which are no more required by organization

You can purge invoices, provided following conditions should match:
If you are purging invoices, the Purge program purges related invoice distributions, invoice approvals, and invoice batches. You can purge invoices that meet the following criteria:
- Last Update Dates of the invoice and its distributions, and the Invoice Date, is less than or equal to the Last Activity Date.
- Invoice is fully paid or is a zero–amount invoice.
- Invoice is fully posted.
- Invoice does not have any 1099 distributions, and is not for a 1099 supplier.
- Invoice was not generated by a recurring invoice template.
- Invoice is not a prepayment, and no prepayments have been applied to the invoice.
- All of the invoice’s payments meet the Payment Purge Criteria.
- No open encumbrances are associated with the invoice.
- Invoice is not Oracle Projects related.
- All purchase orders referencing the invoice meet the Purchase Order Purge Criteria (this condition applies only when you
choose Matched Invoices and POs for the purge category).
- If Oracle Assets is installed, all of the invoice’s distributions were tested by Mass Additions.
Notes:
If we have few invoices pending from a long which are not paid, and the Suppliers are vanished from Market from 5 years.
They will never be paid, Can we Purge them also.
Or do you advice back end delete for those invoices!
Avoid deleting the invoices.
- Create a credit memo from the supplier.
- Apply it to this invoice.
That will close it. 

No comments:

Post a Comment