R12: AP: PO Shipment Qty Bill & Amount Billed Do not Match With Invoice Distribution (Doc ID 1559587.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

AP Invoice line amount and match qty mismatch distribution, PO shipment qty billed and amount billed also mismatch po distribution quantity invoiced and amount invoiced,

It is expected that AP Invoice line amount and match qty should be matched with distribution

The issue can be reproduced at will with the following steps:
 ** Suggesting  an example to clarify the data

1. Create new PO with order qty = 1298 and approved
2. Create receipt to receive and inspect 1298.
3. Return to supplier with qty = 30
4. Deliver the remaining to Inventory as qty = 1268
5. cancel at po shipment
6. Create standard Invoice and invoice match with PO with qty 1298 (overbilled)
7. validate the invoice successfully.
8. Create Credit Memo and invoice match with PO with qty = -30
9. Validate failed with invoice hold name "Total of invoice distributions does not equal invoice amount"

Changes

Cause

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