Find the Base Currency

Use the following function to find the base currency for the current accounting book using nlapiSearchRecord(type, id, filters, columns). For more information, see SuiteScript 1.0 API Reference.

             /* Returns internal id of base currency for specified subsidiary and accounting book combination */
   function getBaseCurrency(subsidiaryId, bookId)
   {

      var searchFilters = new Array();
      searchFilters[0] = new nlobjSearchFilter('internalid', null, 'is', subsidiaryId);
      searchFilters[1] = new nlobjSearchFilter('accountingbook', null, 'is', bookId);

      var searchColumns = new Array();
      searchColumns[0] = new nlobjSearchColumn('accountingbookcurrency');
      
      var searchResults = nlapiSearchRecord('subsidiary', null, searchFilters, searchColumns);

      if (searchResults!=null && searchResults.length > 0)
      {
         return searchResults[0].getValue('accountingbookcurrency');
      }
      
      throw "Subsidiary " + subsidiaryId + " or accounting book " + bookId + " not found";
} 

        

Related Topics

Multiple Currencies Examples
Base Currency from Accounting Book Record
Transaction-Specific Exchange Rates
Convert Currencies with SuiteScript

General Notices