My Oracle Support Banner

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

Last updated on AUGUST 30, 2023

Applies to:

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


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


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.