Creation of ledger in dollars

Summary:

The primary ledger is in Colombian pesos (COP), The functional currency is also Colombian pesos (COP).

The client's requirement is the following:

Have a ledger in dollars with the following variables:

1. Use a historical rate – Modifiable Fixed (BS - HIST AOCI), for an owner´s equity accounting account
2. Use a historical rate – Modifiable Fixed (BS - HIST RE), for other owner´s equity accounting accounts
3. Use the month-end TRM (BS - M.CL) for the asset and liability accounting accounts
4. Use a TRM – Modifiable Fixed (BS - SC), for another owner´s equity accounting account
5. Use a TRM – average of the month (IS - M.AVE), for expense and revenue accounts