Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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!
Tagged:
0