Trial Balance with Reporting Currency and Ledger Currency Balances

Summary:

We have a structure where we have Primary Ledger in IDR Currency. For the same Primary ledger we have Secondary Ledger in IDR currency. For Secondary ledger we have Reporting Currencies Ledger in MYR currency. We have a requirement where user wants to see amount in IDR and MYR currency in the Reporting Currencies Trial Balance Report.

Is there anyway by which we can achieve this?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):