The report client needs is u201CExchange Rate report - transaction rate, reval rate, completed rate".
The user wants to see the rate that a transaction has been captured with. If the transaction is not completed, it would be revaluated at month-end and then he wants to see the reval rate in the next column. Then when transaction is completed, he wants to see the rate at which it was completed.
Please advice from which tables and fields we need to look in to suggest .