Adjust Spot Rate for Default Conversion Method

To maintain consistency between the exchange rates used by the credit card company and those used historically in other JD Edwards EnterpriseOne financial applications, you might want the system to automatically calculate the exchange rate based on the conversion method specified by the system, instead of the conversion method used by the credit card company.

You can use the Visual C++ business function, Adjust Spot Rate for Default Conversion Method (B09E0022), to retrieve and use the conversion method for the exchange rate specified in the Credit Card Transaction Interface Table (F09E150). The business function updates the exchange rate in table F09E150 according to the conversion method specified. This business function should be called for each credit card transaction that will be processed by your custom program when the exchange rate provided by the credit card company for the transaction is greater than zero.

To use business function B09E0022, you must provide:

Field Description	Alias	Field Type	Length	Use
Exchange Rate	CRR_IN	MATH_NUMERIC	8 leading numbers, 7 trailing decimals	The exchange rate from the credit card company
Spot Rate Conversion Method	CRCM_IN	JCHAR	1	The conversion method used by the credit card company: Y for multiplier Z for divisor
Currency Code From	CRCD_IN	JCHAR	3 characters terminated by a fourth NULL character	The currency code of the transaction from the credit card company
Currency Code To	CRDC_IN	JCHAR	3 characters terminated by a fourth NULL character	The domestic, billed currency of the credit card company
Date Effective Rates	EFT_IN	JDEDATE	6 character Julian date	The date of the credit card expense
Address Number	AN8_IN	MATH_NUMERIC	8	The address book number of the credit card company, if specified in the Exchange Rate Identifiers table (F09E114).
System Currency Conversion Method	CRCM_IN	JCHAR	1	Currency conversion method specified in the General Constants table (F0009): Y for multiplier Z for divisor

When the business function runs, it returns this information:

Field Description	Alias	Field Type	Length	Use
Adjusted Spot Rate Conversion Method	CRCM_OUT	JCHAR	1	The conversion method to use for the exchange rate. The system returns this information if your custom program requires debugging.
Adjust Spot Rate	CRR_OUT	MATH_NUMERIC	8 leading numbers, 7 trailing decimals	The adjusted exchange rate to account for the difference between the conversion method used by the credit card company and the JD Edwards EnterpriseOne Expense Management system. The business function returns an adjusted exchange rate only when the currency conversion method used by the Expense Entry program is different from the currency conversion method used by the credit card company The returned adjusted exchange rate should be used by your custom program to update the Exchange Rate field (CRR) in table F09E150.

Field Description

Alias

Field Type

Length

Use

Adjusted Spot Rate Conversion Method

CRCM_OUT

JCHAR

The conversion method to use for the exchange rate.

The system returns this information if your custom program requires debugging.

Adjust Spot Rate

CRR_OUT

MATH_NUMERIC

8 leading numbers, 7 trailing decimals

The adjusted exchange rate to account for the difference between the conversion method used by the credit card company and the JD Edwards EnterpriseOne Expense Management system.

The business function returns an adjusted exchange rate only when the currency conversion method used by the Expense Entry program is different from the currency conversion method used by the credit card company

The returned adjusted exchange rate should be used by your custom program to update the Exchange Rate field (CRR) in table F09E150.

Note: If you do not provide the exchange rate, the system retrieves information for the exchange rate from the Currency Exchange Rates table (F0015) when the credit card expense is applied to the expense report. The system uses the address book number, if provided, to locate a specific exchange rate for the credit card company. If the exchange rate is not set up with an address book number, the system retrieves the default exchange rate for the currency code pair. The system uses the currency conversion method specified for the currency pair to calculate an adjusted spot rate. If the exchange rate is set up for triangulation, or if the system cannot locate the exchange rate for the pair of currency codes, the system uses the currency conversion method specified in the General Constants table (F0009).However, the system does not update table F09E150 with the exchange rate used when the credit card expense is applied to the expense report. The system updates the Expense Report Detail table (F20112) only.