Transaction Functional currency
Dear All,
Developing customized report trying to list the transaction in functional currency; the listed number dos not match with oracle transaction functional currency form:
Example:
From ORACLE Receivable Transaction Window:
Transaction amount in USD = 162092.400
Transaction amount in functional currency JOD = 114923.513.
Exchange rate = 0.709
Precision field in currencies setup window for both USD and JOD = 3.
In report; Amount = 114923.512.
Report calculate the functional amount as follows:
SELECT round(rac.AMOUNT_DUE_ORIGINAL * rac.EXCHANGE_RATE,3) amount
FROM ar_payment_schedules_all rac
where rac.CUSTOMER_TRX_ID = 289595
Result = 114923.512
162092.400 *0.709 = 114923.5116
Rounding up to 3 = 114923.512.
Thanks in advance;
Note: Checking thread:
1