This chapter contains the following topics:
Section 13.1, "Changing Plan Exchange Rates for Postconversion Programs"
Section 13.2, "Suppressing Audit Records for Postconversion Programs"
Section 13.4, "Converting Multicurrency Intercompany Transactions"
This section provides an overview of plan exchange rate revisions and discusses how to change the exchange rate for a plan.
Before you run an ordered or additional conversion program, you must decide which records you want to convert to the new base currency and what exchange rate to use. Based on that decision, you enter a plan name in the processing option and, if applicable, specify certain criteria in the data selection for the program.
The ordered and additional conversion programs use the plan name to determine:
The currency to which to convert the records.
The conversion rate to use when converting the records.
If there is no exchange rate assigned to the plan, the system uses the exchange rate in the F0015 table if there is a company and currency code from on the record that is being converted.
Two postconversion programs — Multicurr Interco Conversion (R890911EB) and Price Variable Conversion (R894075EB) — use the exchange rate in the F0015 table regardless of whether there is an exchange rate on the plan.
Depending on the ordered or additional conversion program that you run and the records that you want to convert, you might need to run a program multiple times for a plan and change the plan exchange rate each time.
Before you run an ordered or additional conversion program, you must also decide whether you want to create audit records for the table that the ordered or additional conversion program converts. To change the plan exchange rate and prevent audit records from being created, you use the Conversion Constants (P0087) and Audit Record Maintenance (P0085E) programs.
The Price by Item Conversion program (R894207EB) is an additional conversion program that converts two amounts in the F4207 table. Assume that at your company, certain price rules correspond to certain currencies, which means that you set up standard price adjustments by currency. To convert records for the different currencies, you run the Price by Item Conversion program for a plan multiple times, entering the plan name in the processing option once and changing the exchange rate for the plan each time that you run the program to coincide with the currency on the records that you convert.
If you set up the conversion plans by currency, simply change the plan name in the processing option each time that you run an ordered or additional conversion program; you do not have to manually change the plan exchange rate.
|
Note: Change the plan exchange rate, if applicable, and complete all remaining tasks in this guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live. |
Access the Work with Conversion Plans form.
To change the plan exchange rate:
Select Find to view a list of conversion plans on the Work with Conversion Plans form.
The rate in the Exchange Rate field is used by all of the ordered and additional conversion programs, except the Multicurr Interco Conversion (R890911EB) and Price by Item Conversion (R894207EB) programs, to convert amounts to the new base currency. The Multicurr Interco Conversion and Price by Item Conversion programs use the exchange rate in the F0015 table, based on the companies being converted.
Select the plan and click Select to change the exchange rate for a specific conversion program.
Change the amount in the Exchange Rate field and click OK on the Conversion Plan Revisions form.
Verify the new exchange rate on the Work with Conversion Plans form.
This section provides an overview of suppression of audit records and discusses how to prevent audit records from begin created for ordered or additional conversion programs.
All ordered and additional conversion programs automatically create audit records for a table and write the records to the F0086 table. If you want the system to create audit records for all tables that the ordered and additional conversion programs convert for a plan, skip the task for Suppressing Audit Records for Postconversion Programs. If you do not want the system to create audit records, you must complete the steps in the task for Suppressing Audit Records for Postconversion Programs.
Depending on the size of the tables to be converted, creating audit records can require a substantial amount of disk space.
|
Note: Prevent audit records from being created for an ordered or additional conversion program, if applicable, and complete all remaining tasks in this guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live. |
You can prevent audit records from being created for an ordered or additional conversion program.
Access the Work with Audit Definitions form.
To prevent audit records from being created for a postconversion program:
Select the plan and click Select.
On the Audit Definition Revisions form, change the value in the Audit Record Flag field to 1 for each table in which you do not want the system to create audit records.
If the plan does not appear on the Work with Audit Definitions form:
Click Add.
Complete the Plan Name and File Name fields on the Audit Definition Revisions form.
Enter the table that corresponds to each ordered and additional conversion program that you plan to run.
Complete the Audit Record Flag field for each table.
Enter 0 to create an audit record and 1 if you do not want to create an audit record.
Click OK.
This section provides an overview of the ordered conversion programs, lists a prerequisite, and discusses how to run the ordered conversion programs.
After you run the Control Table Workbench program (P98413) and verify that the conversion has successfully finished, you must run the ordered conversion programs. The ordered conversion programs are designed to run separately from the workbench programs so that you can control the exchange rate and the records to convert.
For example, the workbench programs do not convert amounts on records without a currency code, company, or business unit. To convert these amounts, you must run several ordered conversion programs. Alternatively, you can manually modify the records.
Each time you run an ordered conversion program, you specify a plan name in the processing option. The system uses the exchange rate that is assigned to that plan to convert amounts for all ordered conversion programs except the Multicurr Interco Conversion program (R890911EB), which uses the exchange rate in the F0015 table. You also specify which records to convert in the data selection.
|
Important: Do not run an ordered conversion program multiple times over the same data. Ordered conversion programs convert amounts every time you run them, regardless of whether the amounts have already been converted. |
Each ordered conversion program is dependent on the successful completion of one or more other ordered conversion programs, so you must run the programs in the sequence in which they appear on the Ordered Conversion Jobs menu (G97UE90).
The ordered conversion programs are:
Configuration Management
Multicurrency Intercompany
Distribution and Product Data Management
Company Currency Codes (required)
Multicurrency Intercompany Post
You must run only the ordered conversion programs that apply to the systems that you use. All clients must run the Company Currency Codes Conversion program (R890010E).
The ordered conversion programs are described in a checklist. The checklist has one check-off (√) column to indicate that the task is complete.
|
Note: Run the ordered conversion programs and complete all remaining tasks in this guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live. |
Ensure that the exchange rate that is assigned to the plan is correct in the Conversion Constants program (P0087).
Select Ordered Conversion Jobs (G97UE90), and then select an ordered conversion program.
You must run the ordered conversion programs in the sequence in which they appear on the Ordered Conversion Jobs menu. Each ordered conversion program depends on the successful completion of one or more of the previous ordered conversion programs.
This checklist discusses ordered conversion programs for the Sales Order Management system:
| Ordered Conversion | Program Description | Complete |
|---|---|---|
| Assembly Inclusion Conversion (R893293EB) | To convert the price and cost amount fields in the F3293 table, you must run the Assembly Inclusion Conversion program or change the fields manually on the x-rule record. If most of the price and cost fields contain factor values (which use a derived calculation) and not monetary amounts, you can manually change the factor values instead of running this program. Alternatively, if you run this program, manually change the converted factor amount on the x-rule records back to their original value afterwards.
The Assembly Inclusion Conversion program converts amounts as follows:
Use the data selection to specify which records to convert. Each time that you run the Assembly Inclusion Conversion program, it converts records with a blank branch/plant. If you run this program multiple times, exclude blank branch/plants in the data selection. Otherwise, amounts without a branch/plant are converted again. |
|
| Rules Table Detail Conversion (R893283EB) | To convert the price amount field in the Rules Table Detail table (F3283), you must run the Rules Table Detail Conversion program or manually change the field on a record.
The Rules Table Detail Conversion program converts amounts as follows:
Use the data selection to specify which records to convert. Each time that you run the Rules Table Detail Conversion program, it automatically converts records with a blank branch/plant. If you run this program multiple times, exclude blank branch/plants in the data selection. Otherwise, amounts without a branch/plant are converted again. |
This checklist discusses the ordered conversion programs for the JD Edwards EnterpriseOne General Accounting system:
| Ordered Conversion | Program Description | Complete |
|---|---|---|
| Multicurr Interco Conversion (R890911EB) | To convert multicurrency intercompany transactions that are automatically generated by the system, you must run the Multicurr Interco Conversion program one time only and for all plans. | |
| Multicurrency Intercompany Post (R8909801EB) | Prerequisites: Run the Multicurr Interco Conversion program one time only for all plans and run the Company Currency Codes Conversion program one time for each plan. |
This checklist discusses the ordered conversion program for the JD Edwards EnterpriseOne Product Data Management system:
| Ordered Conversion | Program Description | Complete |
|---|---|---|
| Item Cost Components Add-Ons (R8930026EB) | To convert item cost component add-on records, you must run the Item Cost Components Add-Ons conversion program. This program converts the simulated factor, rate amount, or both. It also converts the net added-simulated cost. The simulated values are stored in the Item Cost Component Add-Ons table (F30026).
Unlike the other ordered conversion programs, this program has processing options that you use to specify:
The Item Cost Components Add-Ons conversion program does not convert frozen values. You convert those values when you complete the postconversion tasks and run the Simulate Rollup (R30812) and Frozen Update (R30835) programs. |
This checklist discusses the ordered conversion program that applies to all JD Edwards EnterpriseOne systems:
| Ordered Conversion | Program Description | Complete |
|---|---|---|
| Company Currency Codes Conversion (R890010E) | Prerequisites: Complete all other ordered conversion programs, except Multicurr Interco Conversion Post (R8909801EB), if applicable.
You must run the Company Currency Codes Conversion program for each plan. (If you have completed the task for Converting Multicurrency Intercompany Transactions, you already ran the Company Currency Codes Conversion program in step 3 and should not run the program again.) This program changes the existing base currency in the F0010 table to the new base currency for all companies in a conversion plan. To determine the new base currency, this program uses the currency code in the To Currency Code field on the Conversion Plan Revisions form of the Conversion Constants program (P0087). Enter the plan name in the processing option only; do not enter any data selection. Note: Instead of running this conversion program, you can manually change the base currency of a company in the Company Names & Numbers program (P0010). |
This section provides overviews of the multicurrency intercompany conversion and the multicurrency intercompany post and discusses how to convert multicurrency intercompany transactions.
If the Allow Multicurrency Intercompany Trans check box is selected in the General Accounting Constants program (P0000), you must run the Multicurr Interco Conversion program (R890911EB).
The base currency conversion does not convert multicurrency intercompany transactions that are automatically generated by the system. To convert these transactions, you run the Multicurr Interco Conversion program one time only for all plans after you have converted all companies. If you run this conversion program multiple times, the system converts all records on a transaction each time, which results in inaccurate amounts.
Unlike other ordered conversion programs, the Multicurr Interco Conversion program can convert multiple currencies at the same time because the program retrieves conversion rates from the F0015 table, based on the companies in the plan that you are converting.
The Multicurr Interco Conversion program converts amounts in the F0911 table for all intercompany transactions in which the base currency of the company associated with the transaction is being converted. To convert these intercompany transactions, the program first locates all AA transactions with 1 in the GLALT1 field (the value 1 indicates that a multicurrency intercompany transaction was automatically generated). It then:
Converts all transaction amounts on a journal entry if the company on the first line (which determines the base currency of the transaction) is the company that you are converting.
Deletes the corresponding AE (offset) and AM (adjusting) entries for companies that you are not converting.
|
Note: The Convert F0911 Base Currency conversion program (R890911E), which runs during the base currency conversion, deletes corresponding AE and AM entries for all companies converted. The Multicurr Interco Conversion program, which you run after the base currency conversion, deletes corresponding AE and AM entries only for those companies that are not converted. (The AE and AM entries are re-created later during the post.) Review this example for further clarification.If the first line of a journal entry is for a CAD company and the second line is for a USD company, this applies: The Convert F911 Base Currency conversion program deletes the corresponding AE and AM entries for the CAD company (which is being converted). The Multicurr Interco Conversion program deletes the corresponding AE and AM entries for the USD company (which is not being converted) and: |
Clears the posted code and the GLALT1 field on the original transactions and resets the batch to an approved (unposted) status so that you can post the batch again.
Prints a report that lists the batches that were reset to an approved (unposted) status.
The Multicurr Interco Conversion program, along with the Multicurrency Interco Conversion Post program (R8909801EB), makes the necessary adjustments to keep the multicurrency intercompany transactions in balance.
The Multicurr Interco Conversion Post program (R8909801EB) is a version of the General Ledger Post program (R09801) that creates all entries in the F0911 table, including AE offset and AM adjusting entries, based on the new base currency in the F0010 table. However, unlike the General Ledger Post program, the Multicurr Interco Conversion Post program does not:
Post to the F0902 table, which saves valuable processing time.
Instead, it marks the entries as posted so that when you run the Repost Account Ledger program (R099102) later in the base currency conversion process, the system selects entries and posts them to the F0902 table.
Create reversing entries.
To determine the exchange rate, the Multicurr Interco Conversion Post program uses the historical date (HDGJ), if applicable, or the general ledger date (DGJ). The program marks all entries as posted, even though they are not actually posted, so that when you run the Repost Account Ledger program later in the conversion process, the system selects the entries and updates them in the F0902 table.
|
Note: The Multicurr Interco Conversion Post program does not convert a transaction if the account or business unit was changed from a blank to a nonblank posting edit code after the original transaction was posted. This applies only to posting edit codes that were originally blank and have since changed to a nonblank value such as I (inactive), M (machine-generated), or N (nonposting). |
The report produced by the Multicurr Interco Conversion Post program:
Prints batches that posted successfully.
Prints batches that are in error, along with a description of the error message at the end of the report.
You can also review the workflow messages to see information about batches that are in error.
Inserts a page break before each new batch. The page heading for each batch clearly indicates whether the batch is in error.
Prints batches that are out of balance and the entries and multicurrency intercompany adjustments that the system automatically created for the out-of-balance batches.
Out-of-balance batches appear consecutively on the report.
Before the Multicurr Interco Conversion Post program finishes processing, it deletes any entries that the system automatically creates so that only the original transactions remain.
Mixes posted and unposted batches on the report.
If the company that you are converting to a new base currency has intercompany transactions, you must complete these steps to successfully convert the multicurrency intercompany transactions.
To convert multicurrency intercompany transactions:
Verify that all companies and all plans have been converted successfully.
Select and run the Multicurr Interco Conversion program (R890911EB) from the Ordered Conversion Jobs menu (G97UE90). Do not run this program multiple times.
Select and run the Company Currency Codes Conversion program (R890010E), one time for each plan, from the Ordered Conversion Jobs menu (G97UE90).
This program updates the base currency code in the F0010 table for all companies in a plan.
Review the intercompany accounts for any manual multicurrency transactions.
These transactions are converted when you run the Convert F0911 Base Currency conversion program (R890911E), which is part of the base currency conversion; however, you must verify and, if necessary, correct any amounts.
Select Company Names & Numbers from the Organization & Account Setup menu (G09411).
In the Company Names & Numbers program (P0010), reset the fiscal period and year for accounts receivable, accounts payable, and general ledger so that you can post to prior years.
Use the report generated by the Multicurr Interco Conversion program (step 2) to identify the different batch types that you need to post.
Select Multicurr Interco Conversion Post (R8909801EB) from the Ordered Conversion Jobs menu (G97UE90).
Designate the batch type in the processing option and run this post separately for each batch type that you identified in the previous step.
Review the report created by the Multicurr Interco Conversion Post program.
If all batches posted, continue to step 12. If some batches did not post, review the following to determine the cause:
Batch is out of balance.
Slight rounding differences occur when the Multicurr Intercompany Conversion program converts transactions such as invoices and vouchers that do not have an associated F0911 transaction to balance to. The rounding differences, which are typically less than a cent, cause a batch to be out of balance and, as a result, the batch does not post. Continue to step 9.
Posting edit code on an account or business unit changed after the original transaction was posted.
If you changed the original posting edit code on an account or business unit from a blank to a non-blank value after you posted the original transaction, the Multicurrency Intercompany Post does not post the batch. Continue to step 10.
Complete one of the following steps for out-of-balance batches:
To correct an out-of-balance batch, review the batch and revise the amount of the entry for each document that is out of balance.
Approve the batch and rerun the Multicurr Interco Conversion Post program.
To correct an out-of-balance batch, create a one-sided adjustment at the document level or at the batch level.
For each batch, remember to set the option on the Batch Overrides form of the General Journal Review program (P0011) that enables you to post an out-of-balance batch. Approve the batch and rerun the Multicurr Interco Conversion Post program.
To post out-of-balance batches, set the option on the Batch Overrides form that enables you to post an out-of-balance batch.
Approve the batch and rerun the Multicurr Interco Conversion Post program. After you rerun the post, create a final adjustment to balance all batches or, if applicable, run an integrity report that creates the final adjustment. Remember to set the post out-of-balance option for each batch and post the final adjustments.
Change the posting edit code back to blank on the account or business unit.
Approve the batch and rerun the Multicurr Interco Conversion Post program. After you rerun this program, change the posting edit code back to the previous value.
Select Company Names & Numbers from the Organization & Account Setup menu (G09411).
In the Company Names & Numbers program, reset the fiscal period and year back to their original values.
This section provides overviews of additional conversion programs and additional conversion program checklists, lists prerequisites, and discusses how to run additional conversion programs.
After you run and successfully complete the conversion tasks and the ordered conversion programs, you must run the additional conversion programs. The additional conversion programs are designed to run separately from the base currency conversion so that you can control the exchange rate and the records to convert.
For example, the conversion workbench does not convert amounts on records if certain fields are not in a table or if certain values on a record are invalid or blank. To convert these amounts, you must run several additional conversion programs. If records do not include a company or business unit, the additional conversion programs assume that the associated amounts are in the domestic currency of the company.
Each time you run an additional conversion program, you specify a conversion plan name in the processing option. The additional conversion program uses the exchange rate assigned to that plan to convert amounts for all additional conversion programs except the Price Variable Conversion program (R894075EB), which uses the exchange rate from the F0015 table. Some of the additional conversion programs also have a processing option that enables you to select the from currency code in which to convert records. For all additional conversion programs, you can also use data selection to specify records to convert.
|
Important: Do not run an additional conversion program multiple time s over the same data. The additional conversion programs convert amounts every time you run them, regardless of whether the amounts have already been converted. |
The additional conversion programs are for these JD Edwards EnterpriseOne systems from Oracle:
Localization
Expense Management
Real Estate Management
Customer Relationship Management
Sales Order Management
Advanced Pricing
Procurement
Grower Management
Operational Sourcing
Blend Management
Agreement Management
Advanced Transportation Management
Service Billing and Contract Billing
Equipment and Plant Management
Product Data Management
Contract Management
Stock Valuation
Run only the additional conversion programs that apply to the systems that you use.
The additional conversion programs are described in a checklist. The checklist has one check-off (√) column to indicate that the task is complete.
|
Note: Run the additional conversion programs and complete all remaining tasks in this guide in the test environment first, correcting any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live. |
Before you complete the tasks in this section:
Make sure that you successfully ran the Company Currency Codes Conversion program (R890010E), which updates the currency code for the companies in a plan to the new base currency.
You can verify the new currency codes using the Company Names & Numbers program (P0010).
Ensure that the exchange rate assigned to the conversion plan is correct.
If necessary, change the rate using the Conversion Plan Revisions program (P0087).
You must run additional conversion programs for the systems that you use.
All additional conversion programs are available as of release Xe, unless noted otherwise.
Select Additional Conversion Jobs (G97UE901), and then select an additional conversion program.
This checklist discusses the additional conversion program for the JD Edwards EnterpriseOne Localization system, release 8.11 and above:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Convert F76V4581/F76V4583 Base Currency (R8976V6E) | This program recalculates the following amounts in the Withholding Historical (F76V4581) and Withholding I.S.L.R. Fee 2 (F76V4583) tables to the currency code of the conversion plan specified in the processing option, based on the previously converted Gross Amount and Non-Taxable Amount fields in the Accounts Payable Ledger table (F0411):
|
This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Expense Management system:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Credit Card Information Currency Conversion (R890075EB) | If the currency code on the credit card record is the same as the from currency specified in a processing option, this program converts the Currency Code field (CRCRCY) in the Credit Card Information table (F0075) to the currency code of the conversion plan specified in a processing option.
There are no amounts stored in the F0075; therefore, this program does not write audit records to the F0086 table. |
|
| Policy Edit Rules Currency Conversion (R8909E108E) | If the currency code on the policy is the same as the from currency specified in a processing option, this program converts the Policy Currency field (POLCRCY) in the Policy Edit Rules table (F09E108) to the currency code of the conversion plan specified in the other processing option. This program converts amounts in these fields:
|
|
| Credit Card Transaction Currency Conversion (R8909E150E) | If the currency code on the transaction is the same as the from currency specified in a processing option, this program converts the Expense Currency (EXPCRCD) or Build Currency Code (BILLCRCD) field in the Credit Card Transaction Interface table (F09E150) to the currency code of the conversion plan specified in the other processing option. This program converts amounts in these fields:
The conversion program recalculates the rate in the Exchange Rate field (CRR) if the expense currency is not the same as the build currency. |
|
| Employee Profile Definition Currency Conversion (R8920103EB) | If the currency code on the employee record is the same as the from currency specified in a processing option, this program converts the Reimbursement Currency (REIMCRCY) or Credit Card Reimbursement Currency (CCRCRCY) field in the Employee Profile Definition table (F20103) to the currency code of the conversion plan specified in the other processing option.
There are no amounts stored in the F20103 table; therefore, this program does not write audit records to the F0086 table. |
|
| Expense Report Group Profiles Currency Conversion (R8920104EB) | If the currency code on the group profile record is the same as the from currency specified in a processing option, this program converts the Reimbursement Currency (REIMCRCY) or Credit Card Reimbursement Currency (CCRCRCY) field in the Expense Report Group Profiles table (F20104) to the currency code of the conversion plan specified in the other processing option.
There are no amounts stored in the F20104; therefore, this program does not write audit records to the F0086 table. |
|
| Expense Report Currency Conversion (R8920111EB) | If the currency code on the expense report is the same as the from currency specified in a processing option, this program converts currency and amount fields in the tables indicated to the currency code of the conversion plan specified in the other processing option:
This additional conversion program divides the Foreign Expense Amount (EXPFAMT) by the number of units to calculate the rate in the RATE1 field in the F20112 table. This program also updates the exchange rate in the F20112 table as follows:
|
This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Real Estate Management system:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Tenant/Lease Master Euro Conversion (R891501BE) | If the from currency code specified in a processing option is different from the currency code of the conversion plan specified in the other processing option, this program converts amounts in the Tenant/Lease Master table (F1501) for the following fields:
|
|
| Revenue Fee Generation History – Euro Conversion (R891505HEB) | This program converts amounts for the following fields in the Revenue Fee Generation History table (F1505H), based on the currency code of the conversion plan specified in the processing option:
|
|
| A/R Fee Interest – Euro Conversion (R891525BE) | This program converts amounts for the following fields in the A/R Fee Interest table (F1525), based on the currency code of the conversion plan specified in the processing option:
|
|
| Expense Participation Class Adjustment – Euro Conversion (R891531EB) | This program converts amounts for the Class Adjustment Amount field (CLAA) in the Expense Participation Class Adjustment table (F1531), based on the currency code of the conversion plan specified in the processing option. | |
| Legal Clause Amounts Currency Conversion (R8915703EB) | Release 8.0 and above.
If the from currency code specified in a processing option is different from the currency code of the conversion plan specified in the other processing option, this program converts the Amount Gross field (AG) in the Legal Clause Amounts table (F15703). The AG field, which is a user-defined amount type, might not contain a currency amount. Therefore, you can specify in a processing option which Amount Type (TYAM) from UDC table 15/TA to convert. |
|
| AREF Building Constants Models Currency Conversion (R89151001E) | Release 8.10, and 8.11 SP1 and above. If the from currency code specified in a processing option is different from the currency code of the conversion plan specified in the other processing option, this program converts the following amount fields in the AREF Building Constants Models table (F15L1001):
Currently, only the MIND and DMAX fields are used by the system. The other fields are converted, but are for future use. |
|
| Building E.P. Caps Currency Conversion (R8915151EB) | Release 9.0. If the from currency code specified in a processing option is different from the currency code of the conversion plan specified in the other processing option, this program converts the following fields in the Building E.P. Caps table (F15151):
|
|
| Lease E.P. Caps Currency Conversion (R8915152EB) | Release 9.0. If the from currency code specified in a processing option is different from the currency code of the conversion plan specified in the other processing option, this program converts the following fields in the Lease E.P. Caps table (F15152):
|
|
| Tenant Account Exclusions Currency Conversion (R891533BEB) | Release 9.0. If the from currency code specified in a processing option is different from the currency code of the conversion plan specified in the other processing option, this program converts the following fields in the Tenant Account Exclusions table (F1533B):
|
|
| EP Class Adjustments Audit File Currency Conversion (R891539CEB) | Release 9.0. If the from currency code specified in a processing option is different from the currency code of the conversion plan specified in the other processing option, this program converts the following fields in the EP Billing Class Adjustments Audit File (F1539C):
|
|
| EP Adj Factor Lease Audit File Currency Conversion (R891539FLE) | Release 9.0. If the from currency code specified in a processing option is different from the currency code of the conversion plan specified in the other processing option, this program converts the following fields in the EP Billing Adj Factor Lease Audit table (F1539FL):
|
This checklist discusses the additional conversion program for the JD Edwards EnterpriseOne Customer Relationship Management system, release 8.11 and above:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Competitor-Venezuela Conversion (R89CA060EB) | If the currency code on the record in the Competitor table (F90CA060) is the same as the from currency specified in a processing option, this program converts the Annual Rev Currency Code (ARCRCD) and Annual Revenues (ANNREV) fields in the F90CA060 table to the currency code of the conversion plan specified in the other processing option. | |
| Convert F90CB020/F90CB02I Base Currency (R890CB021E) | If the currency code on the record in the Opportunity table (F90CB020) is the same as the from currency specified in a processing option, this program converts the Currency Code – From (CRCD), Budget Amount (BDAMT), Line Item Total (LITOT), and Potential Amount (PTAMT) fields in the F90CB020 table to the currency code of the conversion plan specified in the other processing option.
This program also selects related records in the Opportunity Item table (F90CB02I) and converts these fields:
|
|
| Convert F90CB02M Base Currency (R890CB02ME) | If the currency code on the record in the Cost table (F90CB02M) is the same as the from currency specified in a processing option, this program converts the Currency Code – From (CRCD) and Total Expense (TTLEXP) fields to the currency code of the conversion plan specified in the other processing option. | |
| CRM Forecast Currency Conversion (R8990CB06E) | If the currency code on the forecast record is the same as the from currency specified in a processing option, this program converts currency code and amount fields in the tables indicated to the currency code of the conversion plan specified in the other processing option:
|
This information applies to the additional conversion programs for the JD Edwards EnterpriseOne Sales Order Management system:
If the domestic amounts for the records are in the same currency, enter the plan name that corresponds to that particular currency in the processing option, specify all records in the data selection, and run the additional conversion program one time only.
If the domestic amounts for the records are in multiple currencies, determine which orders represent a particular currency.
Then do one of the following:
Enter the plan name that corresponds to a particular currency in the processing option, specify the records to convert in the data selection, and run this program separately for each currency.
Modify selected records manually.
This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Sales Order Management system:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Commission Const. Conversion (R8942004EB) | For clients who use the commission-related features. This program converts the fixed cost and minimum gross margin amounts in the Commission Constants File table (F42004) to the currency code of the conversion plan specified in the processing option. A currency code is not stored in this table. | |
| Price by Item Conversion (R894207EB) | For clients who use the standard price adjustment features. This program converts the override list price and related price amounts in the PF4207 table to the currency code of the conversion plan specified in the processing option. The system does not update the currency code in this table. | |
| Batch Receiver Header/Detail Conversion (R894001ZEB) | For clients who have unprocessed batch records. This program converts amounts on unprocessed orders without a business unit to the currency code of the conversion plan specified in the processing option:
|
|
| EDI Purchase Order Header/Detail Conv (R8947011EB) | For clients who have unprocessed inbound EDI transactions for purchase orders. This program converts amounts on unprocessed orders without a business unit to the currency code of the conversion plan specified in the processing option:
|
|
| EDI Request for Quote Conversion (R8947091EB) | For clients who use the EDI Request for Quote Inbound or the EDI Request for Quote Edit/Create features. This program converts amounts on unprocessed orders without a business unit to the currency code of the conversion plan specified in the processing option:
|
This checklist discusses the additional conversion program for the JD Edwards EnterpriseOne Advanced Pricing system:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Price Variable Conversion (R894075EB) | For clients who use the price variable feature. This program converts the Unit Price amount in the Price Variable Table (F4075). The F4075 table, unlike the tables for other additional conversion programs, contains a currency code. This program retrieves exchange rates from the F0015 table, which means that you can convert multiple currencies at the same time. It also updates the currency code in the table with the new base currency code.
Specify the records to convert by currency code or price variable in the data selection and run this program. |
Two of the additional conversion programs for the JD Edwards EnterpriseOne Procurement system—R894322E and R8941291E—have two versions:
Version 1 (XJDE0001) runs during the base currency conversion and converts records with a branch/plant and company.
Do not run this version.
Version 2 (XJDE0002) is the additional conversion program that you must run to convert records without a branch/plant or company.
Alternatively, you can create a new version and run it to convert these records.
This information applies to the additional conversion programs R894322E and R8941291E:
If the domestic amounts for the unprocessed orders are in the same currency, enter the plan name that corresponds to that particular currency in the processing option, specify all records in the data selection, and run the additional conversion program one time only.
If the domestic amounts for the unprocessed orders are in multiple currencies, determine which orders represent a particular currency.
Then do one of the following:
Enter the plan name that corresponds to a particular currency in the processing option, specify the records to convert in the data selection, and run this program separately for each currency.
Modify selected records manually.
This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Procurement system:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Tolerance Rules Conversion (R894322E) | This program converts amounts on records without a company. Do not run this program if the tolerance rules are based only on percentages. This program converts the unit price tolerance and extended tolerance amounts in the Purchasing Tolerance Rules table (F4322) to the currency code of the conversion plan specified in the processing option. | |
| Item Cost Comp. Conversion (R8941291E) | This program converts amounts on records without a branch/plant. It converts the cost add-on amount, freight add-on rate, and volume add-on rate amounts in the Item Cost Components table (F41291) to the currency code of the conversion plan specified in the processing option. | |
| Shopping Cart Detail (R8943E20EB) | If the currency code (CRDC) for the shopping cart detail is the same as the from currency specified in a processing option, this program converts the Unit Cost (PRRC), Extended Price (AEXP), Taxable Amount (ATXA), Tax Amount (STAM), and Shipping Charge Amount (SCAMT) fields in the Shopping Cart Detail table (F43E20) to the currency code of the conversion plan specified in the other processing option. |
This checklist discusses the additional conversion program for the JD Edwards EnterpriseOne Grower Management system, release 8.12 and above:
| Additional Conversion | Program Description |
|---|---|
| F40G02 Currency Conversion (R8940G02EB) | If the currency code (CRCD) for the grower block is the same as the from currency specified in a processing option, this program converts the Grower Default Price field (GPRC) in the Grower Block table (F40G02) to the currency code of the conversion plan specified in the other processing option. |
| F40G03 Currency Conversion (R8940G03EB) | If the currency code (CRCD) for the grower harvest is the same as the from currency specified in a processing option, this program converts the following fields in the Grower Harvest table (F40G03) to the currency code of the conversion plan specified in the other processing option:
|
| F40G032 Currency Conversion (R8940G032E) | If the currency code (CRCD) for the freeze detail is the same as the from currency specified in a processing option, this program converts the Freeze Unit Price field (FRZPRRC) in the Harvest Estimate Freeze Detail table (F40G032) to the currency code of the conversion plan specified in the other processing option. |
This checklist discusses the additional conversion program for the JD Edwards EnterpriseOne Operational Sourcing system, release 8.12 and above:
| Additional Conversion | Program Description |
|---|---|
| Currency Conversion for table F43Q60 (R8943Q60E) | This program converts amounts the Worst Amount (WSAMT) and Best Amount (BESTAMT) in the Bid Questions table (F43Q60), based on the currency code of the conversion plan specified in the processing option. |
This checklist discusses the additional conversion program for the JD Edwards EnterpriseOne Blend Management system, release 8.12 and above:
| Additional Conversion | Program Description |
|---|---|
| F31B211 Currency Conversion (R8931B211E) | This program converts the Unit Cost Amount field (UNCS) in the Cost Groups Detail table (F31B211) to the currency code of the conversion plan specified in the processing option. |
| F31B31C Currency Conversion (R8931B31CE) | This program converts the Unit Cost Amount (UNCS) and Amount (AA) fields in the Blend Lot Costs table (F31B31C) to the currency code of the conversion plan specified in the processing option. |
| F31B66 Currency Conversion (R8931B66EB) | This program converts the Unit Cost Amount (UNCS), Amount (AA), Standard Unit Cost Amount (STUNCS), and Standard Cost Total Amount (STDAA) fields in the Blend Transactions table (F31B66) to the currency code of the conversion plan specified in the processing option. |
The additional conversion program for the JD Edwards EnterpriseOne Agreement Management system converts the currency code for records in the Agreement Quantities table (F38011). This program does not run during the base currency conversion because most clients do not want to convert the currency code on all agreement records.
You can manually modify agreement records; however, the advantage of running the additional conversion program is that it automatically updates records that are associated with the F38011 record in five other Agreement Management tables.
This checklist discusses the additional conversion program for the Agreement Management system:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Distribution Contract Quantities (R8938011E) | This program converts the currency code in the F38011 table on records with a business unit. The system uses the business unit to retrieve the correct exchange rate when it calculates amounts on the associated records.
When no errors exist, the conversion program updates currency codes, amounts, or both to the currency code of the conversion plan specified in the processing option for all associated records in these tables:
|
The additional conversion programs for the JD Edwards EnterpriseOne Advanced Transportation Management system have an additional processing option that enables you to either convert the records or bypass converting them.
This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Advanced Transportation Management system:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Routing Entries Conversion (R894950EB) | This program converts freight rate amounts on domestic-only transactions in the Routing Entries table (F4950) to the currency code of the conversion plan specified in the processing option. It converts the Freight Rate and Currency Code From fields, based on the route number. | |
| Rate Detail Conversion (R894972EB) | This program converts freight rate amounts on domestic-only transactions in the Rate Detail table (F4972) to the currency code of the conversion plan specified in the processing option. It converts the Freight Rate and Currency Code From fields based on the unique internal key ID. | |
| Spot Quote Detail Conversion (R8949721EB) | This program converts freight rate amounts on domestic-only transactions in the Spot Quote Detail table (F49721) to the currency code of the conversion plan specified in the processing option. It converts the Freight Rate and Currency Code From fields based on the rate name, shipment number, routing step number, cost center, load number, and delivery number. | |
| Rate Structure Definition Conversion (R894973EB) | This program converts monetary lookup values on domestic-only transactions in the Rate Structure Definition table (F4973) to the currency code of the conversion plan specified in the processing option. It converts the Lookup From Value and Lookup To Value fields for records with a lookup type of B, C, F, or S only. | |
| Rate Parameters Conversion (R894977EB) | This program converts amounts on domestic-only transactions in the Rate Parameters table (F4977) to the currency code of the conversion plan specified in the processing option for these fields:
|
|
| Customer Freight Conversion (R8949332EB) | This program converts amounts on domestic-only transactions in the Preference Profile - Customer Freight table (F40332) to the currency code of the conversion plan specified in the processing option for these fields:
|
This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Service Billing and JD Edwards EnterpriseOne Contract Billing systems:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Invoice Summary Table Conversion (R894822EB) | This program converts and rebuilds the F4822 table to the currency code of the conversion plan specified in the processing option, based on the converted F4812H table. | |
| Rebuild Invoice Summary Access Table (R8948520EB) | This program rebuilds the Invoice Summary Access table (F48520) to the currency code of the conversion plan specified in the processing option, based on the F4812H table.
Use the data selection to select the same companies that you converted during the base currency conversion. |
|
| Billing Rate/Markup - Conversion for Euro (R8948096E) | If the currency code on the record in the Billing Rate / Mark up table (F48096) is the same as the from currency specified in the processing option, this program converts the Currency Code From (CRCD) and Amount (AA) fields to the currency code of the conversion plan specified in the processing option. | |
| Component Table Detail Currency Conversion (R894861E) | If the currency code on the record in the Component Table Detail (F4861) is the same as the from currency specified in the processing option, this program converts the Currency Code From field (CRCD) to the currency code of the conversion plan specified in the other processing option. | |
| Burden Rates - Currency Conversion (R8948S85E) | Release 8.11 and above.
If the currency code on the record in the Burden Rates table (F48S85) is the same as the from currency specified in a processing option, this program converts the Currency Code From field (CRCD) to the currency code of the conversion plan specified in the other processing option. |
|
| Contract Master/Detail Table Conversion (R895202EB) | This program restates amounts to the currency code of the conversion plan specified in the processing option in these tables:
If you decide to create new contracts instead of restating amounts, close the existing contracts and enter new ones with the negotiated amount in the new base currency. |
|
| ACRN Detail – Conversion for Euro (R8952G05E) and ACRN History - Conversion for Euro (R8952G05HE) | Release 9.0.
If the currency code on the records in the ACRN Detail (F52G05) and ACRN History (F52G05H) tables is the same as the from currency specified in a processing option, these two programs convert the following fields to the currency code of the conversion plan specified in the other processing option:
|
|
| Government Contract Limit Summary Conversion (R8952G200E) | Release 9.0.
If the currency code on the record in the Government Contract Limit Summary table (F52G200) is the same as the from currency specified in a processing option, this program converts the following fields to the currency code of the conversion plan specified in the other processing option:
|
This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Plant and Equipment Management system:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| License Fee File Conversion (R891206EB) | This program converts records without a branch/plant and company to the currency code of the conversion plan specified in the processing option. It converts the License Fee Amount field in the Equipment License Master table (F1206). | |
| Rental Rate Conversion (R891301EB) | This program converts records without a branch/plant and company to the currency code of the conversion plan specified in the processing option. It converts the replacement cost and rate component (01–10) amounts in the F1301 table. |
This checklist discusses the additional conversion program for the JD Edwards EnterpriseOne Product Data Management system:
| Additional Conversion | Program Description | Complete |
|---|---|---|
| Work Center Conversion (R8930008E) | Depending on how the manufacturing constants are set up for a branch/plant, this program converts overhead costs in the Work Center Rates File table (F30008) to the currency code of the conversion plan specified in the processing option as follows:
Unlike other additional conversion programs, this program has an additional processing option that is required to be set and is used to specify the branch in which you want to convert overhead costs. You control whether you convert some or all work centers within a branch. To specify which work centers (business units) within a branch that you want to convert, use the data selection. This program includes two versions (XJDE0001 and ZJDE0001). These versions are the same, so you can run either one. |
This checklist discusses the additional conversion program for the JD Edwards EnterpriseOne Contract Management system:
| Additional Conversion | Program Description |
|---|---|
| Contract Header, Block, and Harvest Currency Conversion (R8943C01EB) | This program converts the Contract Currency Code field (CNTRCRDC) in the Contract Header table (F43C01) to the currency code of the conversion plan specified in the processing option. The Contract Amount field (CNTRAMT) is converted; however, the field is not used in the application. The program also converts the following prices in the Contract Block (F43C10) and Contract Detail (F43C11) tables:
|
| Assessment Donations Currency Conversion (R8943C30EB) | This program converts the Assessment Donation Currency Code field (ADCRDC) in the Assessment Donations table (F43C30) to the currency code of the conversion plan specified in the processing option. The program also converts the Flat Amount (CNTRTAMT) and the Amount per (CAMTPER). |
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 | Complete |
|---|---|---|
| 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:
|
|
| 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:
|
|
| 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:
|
|
| 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:
|
|
| 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:
|
|
| 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. |