Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Want Multiple Currencies to show on Financial Reports
Hello,
I am attempting to customize various Financial Reports to show both the base currency (US) and the Canadian currency. I have been told that this is possible to do but I can't seem to pull the right fields.
I've attempted adding a Formula but the formula doesn't provide for me to multiply the US figures by a Canadian exchange rate. It seems to want to pull the US base rate which is 1.0.
I've added the Foreign Exchange Rate but it seems to think this is the US base rate so the result is US dollar x 1.0 = US dollar.
What I want to have is enter today's exchange rate and have US dollars convert to Cdn but show both rates on the same report.