Functional Description
Purpose
This business function will fetch the current Exchange Rate from the F0010 Table, for company
'00000'. It will then call a business function to retrieve Currency Conversion Rate. The tolerance allowed
between the override Exchange Rate and Current Exchange Rate will be calculated. If the override
Exchange Rate is over or below the tolerance, an error is given. The override Exchange Rate must be sent
into this business function as a percentage (e.g. 2% must be sent in as 0.02).
This function will also return a warning if an exchange rate is keyed in when currency spot rates are
not allowed. The correct exchange rate will be returned in the mnExchangeRate parameter. If the
currency code from and to go through a triangulation currency for currency conversion, and an exchange
rate is passed in, a warning will also be set. An exchange rate of zero will be passed back in the
mnExchangeRate parameter. If your application allows the entry of an exchange rate, this function
should be called in order to edit for spot rates and triangulation, even if your application does not
necessarily edit for tolerance.
Setup Notes and Prerequisites
Related Functions - B0000033 Get Exchange Rate
Special Logic
Technical Specification
D0000026 - Edit Exchange Rate Tolerance
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| jdTransactionDate | TRDJ | JDEDATE | NONE | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
| mnExchangeRate | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
| szCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
| szCurrencyCodeTo | CRDC | char | NONE | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
| mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| mnToleranceLimit | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
| B0000033 Get Exchange Rate |
| None |