Curious if anyone has had luck with this without needing SuiteScript knowledge. In my custom Income Statement, I want to pull for my USD consolidated reporting entity, which is comprised of several entities which report in different functional currencies (not USD).
Income Statement by GL account, with columns for:
• A field for Amount (USD) for each GL account
• A field for Amount (Local Currency) for each GL account
◦ I see the transaction field “Amount (Foreign Currency)” but when I pull this in, it is returning the same amounts as “Amount (USD)“. Is there any specific feature I need to have enabled to have this field report in Local Currency?