Understanding the Stock Valuation GL Update Program

You run the Stock Valuation GL Update program (R39130) after you review the data from the Stock Valuation Period Build program. The R39130 program updates the general ledger for the valuation method that is defined as the general ledger update method. The program updates the general ledger based on the valuation method that you set up in the Stock Valuation Constants record for the company.

Note: If the Processing Mode in the Stock Valuation Constants is set to Period, you can run the Stock Valuation GL Update program in proof mode at any time. You will normally run the program in final mode only at the end of each period.If the Processing Mode in the Stock Valuation Constants is set to Annual, you can run the Stock Valuation GL Update program in proof mode at any time to print the valuation report. When you set the processing option to final mode, the system selects data for processing only when the run date is at the end of the fiscal year.

The Period Build program calculates the amounts to be updated. The Stock Valuation GL Update program performs the update after you have reviewed the data. Additionally, records for the next period are built for the F39061 table and the F39063 table. These records contain the opening balance for the next period. For dual currency, the program writes a record to the general ledger for the stable currency.

You can run proof and final versions of the Stock Valuation GL Update program. When you run the proof version, the system does not update the general ledger. After you review the proof version, you run the final version to update the general ledger.

Before you update the general ledger, you can review and approve batches produced by the system. After you approve the general ledger updates, you can post them to the account ledger. Posting completes the valuation process and posts the actual stock value for the period end.

Note: The Stock Valuation GL Update program writes accumulations and depletions to separate accounts. If the offset amount for the LIFO accumulation or depletion amount is positive, the program writes a journal entry to the Asset for LIFO AAI. If the offset is negative, the update writes a journal entry to the Liability for LIFO AAI.