E1: 41: Negative Weighted Average Cost For Reverse Receipt With Cost Method 02 (Doc ID 2191207.1)

Last updated on DECEMBER 05, 2016

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

When 02 Weighted Average Cost is overridden on an application, the cost can go negative. Even though the quantity on hand is positive for the item, the Weighted Average Cost calculation can become negative. See the following example below:

1. Create a Purchase Order
1a. 4 units with WAC = 100
2. Receive the Purchase Order
3. Create a Purchase Order
3a. 5 units with WAC = 100
4. Receive the Purchase Order
5. Create a Purchase Order
5a. 5 units but change the unit cost on the line to 500
6. Receive the Purchase Order
7. Create an Inventory Issue for a quantity of 4
8. Reverse the receipt on the last Purchase Order that was created (In Step 5)
9. Go to the Cardex (P4111). Notice the Quantity on Hand is positive but the value is negative

Cause

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