14 Using Cost Object Tracking in Stock Valuation GL Update

This chapter contains the following topics:

14.1 Understanding Cost Object Tracking in Stock Valuation GL Update

The Stock Valuation GL Update program (R39130) updates the general ledger for the valuation methods that are defined as general ledger update methods. The program updates the general ledger based on one valuation method for each item number or item pool.

For each item or item pool, the system verifies the cost object type and the cost object edit code that you defined in the Account Master table (F0901). When you enter an item, the system edits cost object information against the Item Master table (F4101) only if you have installed the JD Edwards EnterpriseOne Inventory Management system.

The Period Build program calculates the amounts to be updated. Additionally, records for the next period are built for the Period Detail Work File (F39120W) and Additional Quantity Work File (F39121W) tables. These records contain the opening balance for the next period. For dual currency, the program writes a record for the stable currency to the general ledger.

After you approve the general ledger updates, you can post them to the general ledger. Posting completes the valuation process and posts the actual stock value for the period end.

14.2 Running the Stock Valuation GL Update Program (R39130)

Select Stock Valuation Updates (G3930), Stock Valuation GL Update.

14.3 Setting Processing Options for Stock Valuation GL Update (R39130)

Processing options enable you to specify the default processing for programs and reports.

14.3.1 Defaults

1. Update/Proof Mode

Specify whether to run the report in proof or update mode. Values are:

Blank: Proof mode. Updates do not occur.

1: Update mode. The system creates journal entries and sets the update flag on the period detail file.

14.3.2 Process

1. GL Date

Specify the date that the system uses to run the report. Values are:

Blank: Use the current date to run the report.

1: Use the GL date to run the report.

2. Document Type

Specify the document type (UDC 00/DT) that the system uses. If you leave this processing option blank, the system uses document type JE.

3. Domestic Ledger Type

Specify the domestic ledger type (UDC 09/LT) that the system uses. If you leave this processing option blank, the system uses the AA ledger type.

4. Dual Currency Ledger Type

Specify the ledger type (UDC 09/LT) that the system uses for dual currency when dual currency is activated. If you leave this processing option blank, the system uses the XA ledger type for dual currency.

5. Summarize Entries

Specify whether the system creates detailed or summarized entries by account. Values are:

Blank: Create detailed entries.

1: Summarize entries by account.

6. Version ID

Specify the version of the GL journal entry program that the system uses. If you leave this processing option blank, the system uses version ZJDE0001.

7. Roll Up FIFO Layers

Specify whether the system rolls up the remaining FIFO layers for year-end processing. For LIFO valuations, the system always rolls up all layers at the end of the year into a single layer for the opening balance for the next year. If you want the FIFO valuations to roll up into one layer, enter 1 in this option. Otherwise, the system does not roll up the FIFO valuations into one layer. Values are:

Blank: Do not roll up remaining FIFO layers.

1: Roll up remaining FIFO layers.

14.3.3 Setup

By Pass Date Edit

Specify whether the system bypasses date editing. Typically, you bypass date editing only during the initial setup of data (for example, when you load the previous year's data into a live environment). Values are:

Blank: Use date editing.

1: Bypass date editing.