1. Base Currency Conversion Implementation Guide
  2. Expense Management

Expense Management

This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Expense Management system:

Additional Conversion

Program Description

√

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:

  • Audit Amount (AUDITAMT)

  • Receipt Amount (DOMRCTAM)

  • Daily Allowance (DLYALLOW)

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:

  • Expense Amount (EXPAMT)

  • Build Amount (BILLAMT)

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:

  • Currency Code From (CRCD) and Foreign Expense Amount (EXPFAMT) in the Expense Report Detail table (F20112).

  • Reimbursement Currency (REIMCRCY) and Total Expense (TOTEXP), Reimbursement Total (REIMBTOT), Non-billable Total (NBILLTOT), and Cash Advance (CASHADV) in the Expense Report Header table (F20111).

  • Reimbursement Currency (REIMCRCY) and Domestic Expense Amount (EXPDAMT) and Reimbursable Amount (REIMAMT) in the F20112 table.

  • Credit Card Reimbursement (CCRCRCY) and Credit Card Reimbursement Amount (CCREAMT) in the F20111 table.

  • Currency Code To (CRDC) in the F20112 table. This field corresponds to the currency code of the company and has no associated amounts.

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:

  • If a foreign currency transaction becomes a domestic currency transaction after the conversion, updates the exchange rate in the CRR field to 1 between the Currency Code From (CRCD) and Reimbursement Currency (REIMCRCY).

  • If the Currency Code From (CRCD) or Reimbursement Currency (REIMCRCY) for a foreign currency transaction changes after the conversion, recalculates an exchange rate in the CRR field.