My Oracle Support Banner

Prepayment Liquidation not Cancelling the Correct Amount on the Purchase Order (Doc ID 2068908.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Purchasing - Version 12.2 and later
Information in this document applies to any platform.


Prepayment Liquidation not cancelling the correct amount on the PO. When a Quantity Financed is recouped with a liquidating invoice that is not matched to the same PO, Cancelling a PO results in the entire amount being canelled and Quantity Billed is not being updated. Following is the scenario.

Quantity on PO: $1000
Quantity Billed = 0
Amount Financed = $600
Amount Recouped = 600 (Unmatched)

Since the Recouping Invoice is not matched, Quantity Billed on the PO remains 0. Cancelling the PO results in the PO cancelling 1000, and ignores the Recouped amount of 600. The PO should only cancel $400 and not a $1000

Steps to Reproduce :
1 - Create a PO 123 for 1000.
2 - Create a Prepayment Invoice ABC match to PO 123 for 600
3 - Pay the prepayment ABC advance. (Amount Financed $600)
4 - Create a unmatched standard invoice XYZ for 600
5 - Apply the Prepayment ABC to the standard invoice XYZ for 600

The advance has been recouped against an unmatched standard invoice.

Now when canceling the PO, the PO is getting cancelled only to extent of 400. it should allow cancelation for $1000 since the Prepayment amount has been recouped from the unmatched standard invoice.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.