My Oracle Support Banner

E1: 31A: 31: Manufacturing Transaction Quantities Have an Incorrect Negative Unit Cost for a Weighted Average Cost Item (P31113/P31114/P4111) (Doc ID 2851381.1)

Last updated on MARCH 09, 2022

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version 9.2 and later
Information in this document applies to any platform.


After completing a Weighted Average (Sales/Inventory Cost Method 02) Manufactured sub-assembly item for an incorrect transaction IC quantity, the subsequent IM issued for this item has an incorrect unit cost. After more completions (P31114) and issues (P31113), the unit cost on IM entries is calculated as a negative value. Upon reviewing Cost Revisions (P4105), the 02 Cost Method shows a negative Unit Cost.

Below are steps on how this issue can occur:

1. Create weighted average cost item (P4101/P41026) (Sales/Inventory 02) with cost level = 2; the item will be a manufactured sub-assembly that is completed into stock and issued to another Work Order.

2. Create a Manufacturing Work Orders for the item to be both completed and issued to a parent work order. Enter transactions (IC and IM) at the correct quantities. At this point, the system calculates the weighted average cost for the item as expected.

3. Enter an incorrect IC (P31114) for the sub-assembly item (for example, 50.26 EA vs. 5026 EA); this causes the unit cost to be inflated.

4. Subsequently, issue the item (IM - P31113) to another Work Order at an inflated unit cost and for a quantity greater than what is on hand.

5. A new Work Order is created and a completion is recorded for the expected unit cost (5026 EA); at this time, the system does another re-calculation for the 02 cost.

6. Inquire on the P4105 for the sub-assembly item; at this point, the 02 cost has a negative value.

7. Material issues (P31113) for this sub-assembly item will be for a negative unit cost.





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.