My Oracle Support Banner

E1: 42: How to Determine Cancelled Quantities for Primary and Secondary UOM for Orders with Dual UOM Items ? (Doc ID 2733764.1)

Last updated on DECEMBER 03, 2020

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.

Goal

Client is using Dual UOM with Primary UOM being LB and secondary UOM being CA. Due to low inventory sometimes when Ship confirming orders are short shipped either just in the primary UOM (ordered number of cases at a lower weight) or in both primary and secondary UOM (lesser number of cases at a lower weight) and the remainder is cancelled in P4205. The problem is when the remainder is cancelled in Ship confirm there is no way to enter the cancelled quantity for both primary and secondary UOM and the split order detail line created only shows the cancelled quantity in the primary UOM (LB) in F4211.SOCN. In addition the Primary Quantity Ordered (PQOR) for the split line shows the cancelled primary quantity however the Secondary Quantity Ordered (SQOR) is blank.
Client needs to create report in order to notify customers about quantities shipped in both, primary and secondary UOM, as well as the shortage that was cancelled in both, primary and secondary UOM,
Is there any table or field that would contain that information especially the correct dual UOM quantities for the shortage?
 

Solution

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
Goal
Solution
References


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