1. Base Currency Conversion Implementation Guide
  2. Stock Valuation

Stock Valuation

The additional conversion programs for the JD Edwards EnterpriseOne Stock Valuation system convert dual currency records only.

Do not run these conversion programs if these situations apply to you:

  • You do not process dual currency records.

  • You do not want to convert the dual currency records.

To convert dual currency records to a currency that is different from the currency to which you converted the domestic records (that is, the new base currency), you must set up a new conversion plan. Review this example for further clarification:

Before the conversion, a Canadian company has dual currency records in the Japanese yen (JPY). The company converts their base currency to U.S. dollars (USD), so their dual currency records are in USD and JPY. Now the company wants their dual currency records to be in the euro (EUR) instead of JPY. To convert the JPY records to EUR, the company must first set up a conversion plan with a JPY to EUR exchange rate and then run the additional conversion programs for that conversion plan.

Access the conversion programs for Stock Valuation from the Additional Conversion Jobs menu (G97UE901).

This checklist discusses the additional conversion programs for JD Edwards EnterpriseOne Stock Valuation:

Additional Conversion

Program Description

√

F39061 Valuation Period DUAL Currency Conversion (R8939061EB)

This program converts dual currency records in the Valuation Period table (F39061) to the currency code of the conversion plan specified in the processing option for these amount fields:

  • Amount Opening Cost (OPAM)

  • Amount Period Purchases (PEPA)

  • Amount Period Outgoing (POAM)

  • Amount Closing (CLAM)

  • Amount Cost of Goods Sold (CGAM)

  • Amount COGS Adjustment (CGAD)

  • Amount Inventory Adjustment (IVAD)

  • Amount LIFO Adjustment Cost (LICS)

F39062 Valuation Layers DUAL Currency Conversion (R8939062EB)

This program converts dual currency records in the Valuation Layers Table (F39062) to the currency code of the conversion plan specified in the processing option for these amount fields:

  • Unit Cost Purchasing (AMC3)

  • Amount Current (CRAM)

  • Amount Last Allocation (ALAM)

F39063 Period Build Additional Quantity DUAL Currency Conversion (R8939063EB)

This program converts dual currency records in the Period Additional Quantity Table (F39063) to the currency code of the conversion plan specified in the processing option for these amount fields:

  • Amount Opening Cost (OPAM)

  • Amount Period Incoming (PIAM)

  • Amount Period Outgoing (POAM)

  • Amount Closing (CLAM)

  • Amount Period Adjustment (ADAM)

F39064 Valuation Document Summary DUAL Currency Conversion (R8939064EB)

This program converts dual currency records in the Amount Current SV(CRRA) field of the Valuation Document Summary Table (F39064) to the currency code of the conversion plan specified in the processing option.

F3910 G/L Adjustment DUAL Currency Conversion (R893910EB)

This program converts dual currency records in the Amount (SCAA) field of the G/L Adjustment table (F3910) to the currency code of the conversion plan specified in the processing option.

F390619 Historical Valuation Period DUAL Currency Conversion (R8939619EB)

This program converts dual currency records in the Historical Valuation Period Detail Table (F390619) to the currency code of the conversion plan specified in the processing option for these amount fields:

  • Amount Opening Cost (OPAM)

  • Amount Period Purchases (PEPA)

  • Amount Period Outgoing (POAM)

  • Amount Closing (CLAM)

  • Amount Cost of Goods Sold (CGAM)

  • Amount COGS Adjustment (CGAD)

  • Amount Inventory Adjustment (IVAD)

  • Amount LIFO Adjustment Cost (LICS)

F390639 Historical Additional Qty DUAL Currency Conversion (R8939639EB)

This program converts dual currency records in the Historical Additional Quantity Table (F390639) to the currency code of the conversion plan specified in the processing option for these amount fields:

  • Amount Opening Cost (OPAM)

  • Amount Period Incoming (PIAM)

  • Amount Period Outgoing (POAM)

  • Amount Closing (CLAM)

  • Amount Period Adjustment (ADAM)

F390649 Historical Value Doc Summary DUAL Currency Conversion (R8939649EB)

This program converts dual currency records in the Amount Current SV (CRRA) field of the Historical Valuation Document Summary Table (F390649) to the currency code of the conversion plan specified in the processing option.