Netsuite suiteql for balance sheet or REST API for balancesheet

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that both SuiteQL and REST API can be used to fetch balance sheet data from NetSuite, but there are some limitations and challenges with each approach. For the REST API, it is mentioned that the balance is stated as available in the REST API browser and the analytics browser, but test requests and queries show that they aren't available. However, the TransactionAccountingLine join appears to exist, so you may be able to use SuiteQL to get your data if you know how to write a SQL query with joins and aggregate functions. An example SuiteQL query to get account balances is provided:

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

For the SuiteTalk API, it is mentioned that the

getPostingTransactionSummary

SOAP endpoint is the NetSuite recommended way of doing this. However, most users in this community seem to dislike the SOAP API. You can also use SuiteQL or SavedSearches with RESTlets. To use SuiteQL, you will need to use the

transaction

,

transactionline

, and

transactionaccountingline

tables at a minimum. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******