There’s an “openingBalance” field in the Account type in the Schema Browser. how can I fetch that value via API?

AI generated answer (using internal Slack threads):

To fetch the "openingBalance" field in the Account type via API, you can use SuiteTalk API or SuiteQL. For SuiteTalk API, you can use the

get

operation to retrieve a single record or the

search

operation to retrieve multiple records. The

get

operation requires the internalId of the account you want to fetch. Here is a sample request:

xml
<get xmlns="urn:messages_2017_1.platform.webservices.netsuite.com">
  <baseRef xmlns="urn:core_2017_1.platform.webservices.netsuite.com" type="account" internalId="1"/>
</get>

For SuiteQL, you can use a SQL-like query to fetch the data. Here is a sample SuiteQL query:

sql
SELECT AcctType, AcctNumber, FullName, Description, Balance
FROM Account
ORDER BY AcctType ASC, FullName ASC

Please note that the "openingBalance" field might not be directly available via the REST API. You might need to calculate it by summing the amount of transaction accounting lines that are posting, grouped by the account's id. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******