Searching for Statistical Journal Entry Records

To search for a statistical journal entry record, use any of the following: TransactionSearchBasic, TransactionSearch, or TransactionSearchAdvanced. Use the type field to restrict the search to journal entries. Set the statistical field to true to further narrow the search to statistical journal entries. The following example would return all statistical journal entry records that exist in the account.

C#

          private void searchStatisticalJournalEntry()
{

   // Create the search object.

   TransactionSearchBasic myStatisticalJournalEntrySearch = new TransactionSearchBasic();


   // Restrict the search should to journal entry records.

   myStatisticalJournalEntrySearch.type = new SearchEnumMultiSelectField();
   myStatisticalJournalEntrySearch.type.@operator = SearchEnumMultiSelectFieldOperator.anyOf;
   myStatisticalJournalEntrySearch.type.operatorSpecified = true;
   myStatisticalJournalEntrySearch.type.searchValue = new string[1];
   myStatisticalJournalEntrySearch.type.searchValue[0] = "_journal";


   // Restrict the search to statistical journal entry records.

   myStatisticalJournalEntrySearch.statistical = new SearchBooleanField();
   myStatisticalJournalEntrySearch.statistical.searchValue = true;
   myStatisticalJournalEntrySearch.statistical.searchValueSpecified = true;


   // Execute the search.

   SearchResult searchResult = _service.search(myStatisticalJournalEntrySearch);

}

SOAP Request

          <soap:Body>
   <search xmlns="urn:messages_2017_1.platform.webservices.netsuite.com">
      <searchRecord xmlns:q1="urn:common_2017_1.platform.webservices.netsuite.com" xsi:type="q1:TransactionSearchBasic">
         <q1:statistical>
            <searchValue xmlns="urn:core_2017_1.platform.webservices.netsuite.com">true</searchValue>
         </q1:statistical>
         <q1:type operator="anyOf">
            <searchValue xmlns="urn:core_2017_1.platform.webservices.netsuite.com">_journal</searchValue>
         </q1:type>
      </searchRecord>
   </search>
</soap:Body>

SOAP Response

          <soapenv:Body>
   <searchResponse xmlns="urn:messages_2017_1.platform.webservices.netsuite.com">
      <platformCore:searchResult xmlns:platformCore="urn:core_2017_1.platform.webservices.netsuite.com">
         <platformCore:status isSuccess="true"/>
         <platformCore:totalRecords>9</platformCore:totalRecords>
         <platformCore:pageSize>1000</platformCore:pageSize>
         <platformCore:totalPages>1</platformCore:totalPages>
         <platformCore:pageIndex>1</platformCore:pageIndex>
         <platformCore:searchId>WEBSERVICES_1013519_0220201413371589901781611728_80125163d91</platformCore:searchId>
         <platformCore:recordList>
            <platformCore:record internalId="6713" xsi:type="tranGeneral:JournalEntry" xmlns:tranGeneral="urn:general_2017_1.transactions.webservices.netsuite.com">
               <tranGeneral:postingPeriod internalId="315">
                <platformCore:name>Jan 2014</platformCore:name>
               </tranGeneral:postingPeriod>
               <tranGeneral:tranDate>2014-01-20T15:00:00.000-08:00</tranGeneral:tranDate>
               <tranGeneral:currency internalId="1">
                  <platformCore:name>US Dollar</platformCore:name>
               </tranGeneral:currency>
               <tranGeneral:exchangeRate>1.0</tranGeneral:exchangeRate>
               <tranGeneral:tranId>GJ10051</tranGeneral:tranId>
               <tranGeneral:subsidiary internalId="1">
                  <platformCore:name>Parent Company</platformCore:name>
               </tranGeneral:subsidiary>
               <tranGeneral:approved>false</tranGeneral:approved>
               <tranGeneral:createdDate>2014-01-21T09:09:45.000-08:00</tranGeneral:createdDate>
               <tranGeneral:lastModifiedDate>2014-02-11T08:21:16.000-08:00</tranGeneral:lastModifiedDate>
               <tranGeneral:customFieldList>
                  <platformCore:customField internalId="562" scriptId="custbody_adjustment_journal" xsi:type="platformCore:BooleanCustomFieldRef">
                     <platformCore:value>false</platformCore:value>
                  </platformCore:customField>
                  <platformCore:customField internalId="505" scriptId="custbody_report_timestamp" xsi:type="platformCore:StringCustomFieldRef">
                     <platformCore:value>21/01/2014 09:08:41</platformCore:value>
                  </platformCore:customField>
            </tranGeneral:customFieldList>
               </platformCore:record>
           ...
         </platformCore:recordList>
      </platformCore:searchResult>
 </searchResponse>
</soapenv:Body>

C#

SOAP Request

SOAP Response

Related Topics