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!
Exchange Rate Conversion in Dataset Formulas for Transaction Lines
Looking for a bit of help using the #converted formula functionality for datasets to convert local transaction amounts to our base currency.
This works to convert the transaction based on the manually entered date.
TO_NUMBER({transactionlines.netamount#converted[1;2020-01-01]})
This works to format the date field independently.
TO_CHAR({trandate}, 'YYYY-MM-DD')
However, this produces a syntax error for the date formatting. Any ideas?
TO_NUMBER({transactionlines.netamount#converted[1;TO_CHAR({trandate}, 'YYYY-MM-DD')]})
Thank you in advance for any help!