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!
Transaction search in base currency
Hi guys,
Sorry if this has been answered before but I have trawled past posts and can't seem to find an answer.
We have multiple Subsidiaries with a Consolidated currency of USD. I am creating a transaction search for a subsidiary with base currency of GBP. The transactions are all for different currencies (GBP, EUR, USD, CAD etc.).
A transaction search in all the separate currencies is not very useful. I can get the search on the consolidated currency of USD but the local finance team need to see this in GBP. How can I do this? I don't think it is possible using a standard field so what formula can I use to get this?