Shipped Quantity Not Matching With AR Invoiced Quantity
(Doc ID 1505038.1)
Last updated on JANUARY 07, 2022
Applies to:Oracle Shipping Execution - Version 11.5.10.CU1 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Order Management - Version 220.127.116.11 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
On : 12.1.1 version, Ship Confirm
There is a difference in the Shipped Quantity(qty) displayed on Shipping Transaction Form under Lines/LPN tab and that of
AR invoice - Quantity field. For eg. shipped quantity shows 31.86 and on AR invoice it shows 32.
Based on the HTMomse12 order output, the table OE_ORDER_LINES (LIN) shows:
- Order Qty = 32
- Shipping Qty = 31.86
- Shipped Qty = 32
- Invoiced Qty = 32
In the table WSH_DELIVERY_DETAILS (DET), the picked and shipped qty is 31.86 UOM = TON with 0.14 qty as 'Cancelled'.
MTL_MATERIAL_TRANSACTIONS (TRN) - PICKED LINES
Inventory issue with qty 31.86 , 'Staging Transfer' for qty as 32.
There should not be a discrepancy in the quantity invoiced.
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