Matt Bernstein
05/11/2022, 5:01 PMBUILTIN.CURRENCY_CONVERT(transactionLine.foreignamount, 1, transaction.trandate ) - works
BUILTIN.CURRENCY_CONVERT(transactionLine.foreignamount, 'DEFAULT', transaction.trandate ) - Search error occurred: Cannot build builtin function, validation failed. Target currency id is not NUMBER but STRING
BUILTIN.CURRENCY_CONVERT(transactionLine.foreignamount, subsidiary.currency, transaction.trandate ) - Search error occurred: Cannot build builtin function, validation failed. Invalid target currency id argument
tdietrich
05/11/2022, 5:31 PMMatt Bernstein
05/11/2022, 6:08 PMtransactionLine.foreignamount * transaction.exchangerate
Odd 'DEFAULT' wouldn't work though as the documentation says you can use it for any value except the amount