My Oracle Support Banner

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.

Symptoms

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:

  1. Create a new Item (P4101) with a primary UOM of EA and Secondary and Pricing UOM of CA.
  2. 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
  3.  Set the Item Cost to $1.00 per EA
  4. No inventory is on-hand in the Item Availability Inquiry (P41202)
  5. In USC 49/SD, order type S4 with S line type is a transportation order.
  6. 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)
  7. Create a Transportation Sales Order for 10 CA (85 EA) Extended Cost = 850.00. Quantity Backordered is Zero.  Save the order.
  8. Check Customer Service Inquiry and note Shipment Number is 8949. Quantity Backordered is zero.
  9. Using Databrowser look for the order header total cost (F4201.TOTC). It is 850.00 same as the order line.
  10. Make an inventory adjustment (P4114) Qty 6, which will allow partial shipment
  11. P4915 – Work with Shipments, take row exit to approve shipment
  12. P4915 > P49645 > P4205 – Partial Ship Confirm. P4205 – Adjust the quantity for partial Qty shipment, 6 CA which is available on hand
  13. P4210 – See that line split, Qty = 6 has been shipped and Qty = 4 has been backordered
  14. Using Databrowser look for the order header total cost (F4201.TOTC). It is changed from 850.00 to 514.00.

Cause

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
Symptoms
Cause
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.