Is there a way to create a custom Trial Balance showing the: GL ACCOUNT TOTAL TRANSACTION CURRENCY AMOUNT TRANSACTION CURRENCY CONSOLIDATED EXCHANGE RATE BASED ON THE AS OF PERIOD SELECTED (DYNAMIC) BASE CURRENCY AMOUNT (if calculated, this should be total currency amount per currency x consolidated exchange rate) I tried adding the Amount Current Rate but it does not show up at consolidated level.

@Luis So do recall that when dealing with consolidations between multiple subsidiaries (which it sounds like you're doing) there's a separate consolidated exchange rate that governs those currency conversions distinct from the spot/transaction rate within the subsidiary. In the single subsidiary instance, I think you're looking for the 'Foreign Currency Amount' (or maybe 'Amount (Foreign Currency)') and 'Exchange Rate' fields. You'd have to do a little more research on the consolidated exchange rates to figure out what you need if that's your situation.