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:
|
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):
|
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. |