E1: 49: Partial Ship Confirm (P4205) Split and Backorder Corrupts Sales Order Header Cost (F4201.TOTC)
(Doc ID 2803413.1)
Last updated on AUGUST 30, 2021
Applies to:JD Edwards EnterpriseOne Transportation Management - Version 9.2 and later
Information in this document applies to any platform.
When user partially ship confirm a transportation sales order line and that makes the line split where the additional line goes to back order, the Order Header Total Cost (F4201.TOTC) gets recalculated.
The issue can be reproduced at will with the following steps:
- Create a new Item (P4101) with a primary UOM of EA and Secondary and Pricing UOM of CA.
- Setup Item UOM Conversions (P41002) as follows
a. 1 CA = 10 GA
b. 1 CA = 85 LB
c. 1 PL = 2 CA, Structure Code = 1
d. 1 CA = 85 LB, Structure Code = 2
- Set the Item Cost to $1.00 per EA
- No inventory is on-hand in the Item Availability Inquiry (P41202)
- In USC 49/SD, order type S4 with S line type is a transportation order.
- Create a version of Sales Order Entry (P4210) with the following settings:
a. Order Type = S4
b. Line Type = S
c. Default Transaction Unit of Measure = 1 (Pricing Unit of Measure)
d. Activate Availability Checking = Blank (off)
- Create a Transportation Sales Order for 10 CA (85 EA) Extended Cost = 850.00. Quantity Backordered is Zero. Save the order.
- Check Customer Service Inquiry and note Shipment Number is 8949. Quantity Backordered is zero.
- Using Databrowser look for the order header total cost (F4201.TOTC). It is 850.00 same as the order line.
- Make an inventory adjustment (P4114) Qty 6, which will allow partial shipment
- P4915 – Work with Shipments, take row exit to approve shipment
- P4915 > P49645 > P4205 – Partial Ship Confirm. P4205 – Adjust the quantity for partial Qty shipment, 6 CA which is available on hand
- P4210 – See that line split, Qty = 6 has been shipped and Qty = 4 has been backordered
- Using Databrowser look for the order header total cost (F4201.TOTC). It is changed from 850.00 to 514.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