RE: Is there a BUILTIN function for Consolidated level currency as we have BUILTIN.CURRENCY_CONVERT() for normal currency conversion.
We are using BUILTIN.CURRENCY_CONVERT() function to get the converted amount. But in the case of consolidated entity level we have one table namesĀ ConsolidatedExchangeRate. Is there any built in function for consolidated convert amount? there are historical, current and average we are taking which is mapped for the general rate in the accounting period with the transaction.
Yes, there is, BUILTIN.CONSOLIDATE():
https://suiteanswers.custhelp.com/app/answers/detail/a_id/99191/loc/en_US