System Flow

The JD Edwards EnterpriseOne Advanced Stock Valuation system uses the F4111 table as the base for its processing. The system extracts the inventory activities from the Cardex by document number, type, and item. Based on the valuation methods, the system then determines the various balances and updates the valuation files. When you post the valuation, the system updates the general ledger and the Valuation Period Table (F39061).

This table describes the tasks performed by the system:

Table

Description

Item Ledger File table (F4111)

The system retrieves records by specific document number, document type, and item for a given date range.

Item Pool Valuation Master table (F3904)

The system retrieves the item or pool valuation method and unit of measure.

Valuation Method Master table (F3905)

The system retrieves attributes of the valuation method.

Valuation Period Table (F39061)

The system retrieves the closing balance and other necessary information from the previous period's record.

Period Build report (R39120)

This batch application:

  • Updates the Historical Valuation Period Detail Table (F390619) with current information.

  • Builds layers in detail or summary, based on the valuation method, in the Valuation Layers Table (F39062).

  • Accumulates totals by document type to the Valuation Document Summary Table (F39064).

  • Writes and updates current information to the Period Additional Quantity Table (F39063).

Company G/L Update Method Master table (F39042)

The system retrieves the valuation method that is used to update the Account Ledger (F0911) table.

Valuation Layers Table (F39062)

The system updates layer information and combines layers at year-end.

General Ledger Post report (R09801)

Run this batch application to update the general ledger from journal entries.

Stock Valuation GL Update report (R39130)

This batch application:

  • Updates the general ledger based on the valuation method that you defined.

  • Updates the F39061 table, as posted.