Journal entered currency conversion to constant reporting currency

Summary:

We have a requirement to report on a specific currency and constant exchange rate, i.e. we have to convert and report all the entered currency journal posting in a period in the primary ledger to this constant currency.

If I setup a reporting currency at “Balance” level it will convert the ledger currency balances to the new currency through translation process, the entered currency values are not converted with this option. i.e. for a GBP ledger, a 100 USD Dr line => converts to ledger currency using the Corp rate to GBP => Translation at balance level will convert this GBP amount to the reporting currency at a constant rate.