My Oracle Support Banner

E1: 42: 46: Sales Order Header Order Amount (F4201.SHOTOT) Not Updated with Warehousing Pick Confirmation Phase 2 Quantity Override for Dual UOM/ Dual Picking - P4617 (Doc ID 2959310.1)

Last updated on NOVEMBER 01, 2023

Applies to:

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


For set up of a Dual Unit of Measure (UOM) item with Dual Picking and there is a Quantity Override on Phase 1 & Phase 2 Pick Confirmation (P4617), the sales detail and ledger tables (F4211/F42199) show the quantity and the extended price updated. The Sales Order Header Order Amount field (F4201.SHOTOT) does not update with the newly updated extended amount line total of the sales detail lines.

Steps to Duplicate:
1. Item Master (P4101) setup item / Dual UOM and Dual Picking and primary UOM = LB.
2. UOM conversions 52 LB = 1 CA (case).
3. Item Profile Revisions (P46010)/ flag for 2 phase picking (PKPH) = L.
4. Enter a Warehousing sales order (P4210) for 104 LB/ 2CA for $5 per LB.
5. The OTOT in Sales Order Header table (F4201) = 520.00.
6. Process Pick Request (R46171) / R46171 selects proper location.
7. Check item quantity in Item Availability to see the quantity.
8. Process Pick Confirmation (P4617), phase 1.
    Override the qty = 110 as is variable / Override weight from 104 to 110 LBS.
9. Check item quantity in Item Availability and note it is updated.
10. Check Customer Service inquiry/ No change to SO.
11. Override the qty/weight to 110 again on Phase 2 Pick Confirm (P4617) as was not updated on the Phase 1 override.
12. Process Pick Confirm (R4617).
13. Check Sales Order Header (F4201) and the Order Amount - SHOTOT is not updated. It is still 550.00.
14. Check SO Detail and Sales Ledger table (F4211/ F42199) / Weight of 110LB updated on the sales order and the extended cost is updated to $550.00.



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

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