My Oracle Support Banner

E1: 39: Understanding Advanced Stock Valuation (P39042, P3904, P39060, R39120, R39130) (Doc ID 625488.1)

Last updated on MAY 14, 2021

Applies to:

JD Edwards EnterpriseOne Advanced Stock Valuation - Version XE and later
Information in this document applies to any platform.



You use the JD Edwards EnterpriseOne Advanced Stock Valuation system from Oracle to determine the current value of a company’s stock. Stock is also referred to as inventory. Stock value is based on the total cost of the stock owned by a company at a specific time. The value of stock can vary, depending on the different methods used to calculate the total cost and the method used to value the stock. You can value stock using one of these methods:

First In, First Out (FIFO)
Last In, First Out (LIFO)
Average weighted cost.
Replacement cost.

The systems that integrate with JD Edwards EnterpriseOne Advanced Stock Valuation store all inventory activity in a central table, the Item Ledger File table (F4111), which is known as the Cardex. The Cardex is the central repository of all inventory and cost movements. Programs from other systems that handle inventory create records in this table whenever inventory and cost are affected. The JD Edwards EnterpriseOne Advanced Stock Valuation system uses inventory information from the Cardex to ensure that the correct inventory is valued.


 Value stock in different ways and compare this to the on hand value of stock. Everything is based on the Item Ledger (F4111). All transactions written to the Item Ledger (F4111) can be used for Advanced Stock Valuation.


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
 First In, First Out (FIFO)
 Last In, First Out (LIFO)
 Weighted Average
 Average Cost in Advanced Stock Valuation
 Replacement Cost
 Setup Programs
 Update and Review Programs
 Reviewing Valuation Results
 Reporting Programs
 Purging Advanced Stock Valuation Records

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.