After Pay on Receipt Autoinvoice(POXPOIV), Quantity Invoiced Does Not Match Quantity Received if the Transaction UOM/PO UOM Differs From the Primary UOM
(Doc ID 2357602.1)
Last updated on OCTOBER 24, 2018
Applies to:Oracle Purchasing - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Oracle Payables - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Oracle Inventory Management - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.
After running Pay on Receipt Autoinvoice(POXPOIV),
PO_LINE_LOCATIONS_ALL.QUANTITY_BILLED and AP_INVOICE_DISTRIBUTIONS_ALL.QUANTITY_INVOICED are not matching with PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED and RCV_TRANSACTIONS.QUANTITY by a decimal.
PO_LINE_LOCATIONS_ALL.QUANTITY_BILLED = 9.99999999999999999999999999999999999999
AP_INVOICE_DISTRIBUTIONS_ALL.QUANTITY_INVOICED = 9.99999999999999999999999999999999999999
PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED = 10
RCV_TRANSACTIONS.QUANTITY = 10
After Pay on Receipt Autoinvoice(POXPOIV) runs,
it is expected that PO_LINE_LOCATIONS_ALL.QUANTITY_BILLED and AP_INVOICE_DISTRIBUTIONS_ALL.QUANTITY_INVOICED should match with the PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED and RCV_TRANSACTIONS.QUANTITY
- Define UOM conversion from UOM1 to UOM2 on ItemA which primary UOM is UOM1
Inventory(N) > setup > unit of measure > conversions > Intra-class
Item : ItemA
Source Unit : UOM1
Conversion : 1440
Destination Unit : UOM2
- Crete new Standard Purchase Order for ItemA which UOM is UOM2 and quantity is 10 and set the invoice match option to Receipt.
Purchasing(N) > Purchase Orders > Purchase Orders
- Approve it
- Receive this PO
- Run the 'Pay on receipt autoinvoice'
- Note that the QUANTITY_BILLED is not matching the QUANTITY_RECEIVED
After applying Patch.21213054.
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