Why is the Amount Cancelled and Amount Matched(Billed) Not Adding Up to the Total Amount of the Purchase Order

(Doc ID 2353136.1)

Last updated on JANUARY 31, 2018

Applies to:

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


We have either billed or cancelled the entire quantity of the shipments on the purchase order.


So on all of our shipments-quantity = quantity_cancelled + quantity_billed in the PO_LINE_LOCATIONS_ALL table for this PO


Why does the Amount Billed not = Amount of Purchase order less the Amount Cancelled?


or Why does the quantity on the PO SHIPMENTS equal the quantity invoiced but the  AMOUNT BILLED/MATCHED is greater than the Amount on the PO shipment?


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms