Extracting Advanced Stock Valuation Records

Select Stock Valuation Updates (G3930), Stock Valuation Extraction to access the Available Versions form.

Use the Stock Valuation Extraction program (R39600) to retrieve data from these tables:

  • Item Ledger File (F4111).

  • Agreements Transaction Ledger (F38111).

  • Load In-transit Ledger (F49631).

With the data from the previously listed tables, the Stock Valuation Extraction program updates these tables:

  • Period Detail Work File (F39120W).

  • Additional Quantity Work File (F39121W).

You can also use this program to automatically update the JD Edwards EnterpriseOne Advanced Stock Valuation tables, rather than turning on the stock valuation triggers.

Before you begin using the JD Edwards EnterpriseOne Advanced Stock Valuation system, you must run Stock Valuation Extraction program to gather information from the item transaction tables.