E1: 31: Enhancement for 09 Actual Costing To Enable Allocation of Quantities Basd on Standard BOM and Routing (Doc ID 1954026.1)

Last updated on MARCH 08, 2017

Applies to:

JD Edwards EnterpriseOne Product Data Management - Version 9.1 and later
Information in this document applies to any platform.

Goal

Enhancement Required as follows:

Requirement of 09 Actual costing functionality as Finished Goods and COGS need to reflect the actual cost of completion, but with added functionality as follows:

When a completion takes place (P31114), the allocation of costs to the completion needs to be pro-rated based on the original BOM and Routing, so that costs are only accumulated based on standard material issue quantities
and labour/machine hours per unit of completion, but using the flexibility of Actual Costs of the material and labour/machine.

The specific use case is that there is a two year lifecycle on a Work Order for cable and the customer calls-off in batches over the two years.


Material is issued to the shopfloor to cover a few call-offs. With current 09 costing, the first few call-offs are overstated due to the material being issued to cover a few call-offs. R31804 Variances will correct this, but this would be two years down the line, so FG and COGS are inaccurate for two years.

Example:

FG item PARENT.

BOM has 1 per of COMP @ $10/each
Routing has 1 hour per item @ $10/hr

Raise WO for 100.

Warehouse - issues 40 ($400)
Book 10 hrs labour ($100)

Complete 10 to stock.

09 cost of completion = $500/10 = $50

This is overstated by $30/unit based on pro-rate consumption of 1 EA COMP $10) and 1 HR Labour ($10).

Item is shipped at $50 and COGS processed at $50. If item has a list price of $25, this shows as a $25 loss per item, when in truth it is a $5 profit. This imbalance is only rectified when the WO is finally completed and R31804 is run.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms