My Oracle Support Banner

E1: 42: Unit Cost Calculating Incorrectly On Direct Ship Kit Order Change (Doc ID 2535221.1)

Last updated on JUNE 20, 2019

Applies to:

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


Sales Order Entry (P4210)

After creating a kit order with direct ship components, if the user goes back into the order and adds an optional component in the kit selection window, the unit cost of the original components are deducted from the unit cost of the parent kit.

This causes the cost to be understated and the profitability to be overstated when the sales order is processed by sales update. We do not know how often the kit orders will be changed after initial entry because their customer did not know what they wanted, but we know that it is not uncommon.

Steps to duplicate

  1. A typical item bill of material has 18 components, 16 of which are line type D (Direct Ship) items.
  2. All 18 kit components are "O - Optional" not "R - Required".
  3. All 18 components have a Quantity per parent item of 0.
  4. Enter a Sales Order for the kit. Components to be selected and quantities per parent for each component are determined during order entry and entered in the kit selection window.
  5. The unit cost field on the kit parent record is rolled up from the sum of the component costs.
    1. In the example tested unit cost on the parent was 18,491.5648 after order entry.
  6. Go into the kit order after it is saved and select an additional component in the kit selection window and save the changes
  7. Reinquire on the order after the change and review the unit cost on the kit parent line of the order.
  8. Observe that the costs from the prior components were dropped from the kit parent unit cost and only the cost of the added component is included in the rolled up parent unit cost.
    1. In the example tested the unit cost on the parent was changed to 2,995.2000.

The issue is occurring in the production environment for a new business unit that uses kits with direct ship components for 100% of their orders.

The costs of components initially added on the kit order should not be dropped if new lines are added later.




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.