Rounding / Prescission of Functional currency on AR Transactions Form
I am developing a report to list down all AR transactions entered into the system for certain selection criteria.
I am calculating "Functional original amount" as -
amount_due_original * exchange_rate from table -> ar_payment_schedules_all
But this amount is not matching with the total amount of functional currency in the application/front end.
Navigation> Query AR transaction>Balances>
click on radion button"Functional Currency" , see the total amount.
This amount is not matching with "Functional original amount" in my custom report.
Not sure what basis this amount is rounded in oracle form/application.
Can anyone give hint on this.