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!
Call a saved search from another saved search
Hi,
I need to write a report that will convert any open sales order's currency amount using the currency exchange rate that of today. The {netamount} will convert the currency amount, based on the exchange rate on the sales order (this will be the exchange rate when the Sales order was created).
I am thinking of having a saved search that will generate exchange rates as of today (the day the report is run) and then use this saved search in another saved search for sales orders. which multiplies foreign currency amount with today's exchange rate.
If this possible? Or is there any other way?