RE: How can I fetch Account and Account Balances data from NetSuite’s SOAP requests using lastModifiedDate?
Search Account : SOAP request (unable to fetch it with LastModifiedDate)
<soapenv:Body>
<urn:search>
<searchRecord xsi:type=”ns1:AccountSearch”
xmlns:ns1=”urn:accounting_2019_2.lists.webservices.netsuite.com”>
<ns1:basic xsi:type=”ns2:AccountSearchBasic”
xmlns:ns2=”urn:common_2019_2.platform.webservices.netsuite.com”>
<ns2:isInactive xsi:type=”urn1:SearchBooleanField”>
<urn1:searchValue xsi:type=”ns2:RecordRef”>false</urn1:searchValue>
</ns2:isInactive>
</ns1:basic>
</searchRecord>
</urn:search>
</soapenv:Body>
DONT KNOW HOW TO FETCH ACCOUNT BALANCE RECORD ?
You won’t find account balance using a basic search. A basic search essentially does a search using the criteria you set and the results contains records. In this case an Account record which does not have a field for balance data.
Do an advanced search instead. It more closely matches what you can get from a saved search. Importantly it allows you to specify the columns returned in the response, one of which can be the balance. My advice here is to try it in the ui first to see what data you are working with. You will have a problem filtering by a last modified date, primarily because there is no field for that.
