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

General Notices