Hi all! Is it possible to get Balance sheet and/or Profit loss using the Suitetalk API? Thanks!

Yes but not easily

Hi @Marc Reicher, We are looking out for data associated with assets, liabilities, equity accounts data for a particular date range. Is there a way to retrieve this information via the API or SuiteQL that you can suggest please?

The

getPostingTransactionSummary

SOAP endpoint is the NetSuite recommended way of doing this. Most users in this community hate the SOAP API though. You can also use SuiteQL or SavedSearches with RESTlets.

Thanks @Marc Reicher. How would you recommend using SuiteQL for this information. We are not too skilled with SOAP API's

You will need to use the

transaction

,

transactionline

, and

transactionaccountingline

tables (at a minimum).

@tdietrich shared some examples here of financial reports using SuiteQL https://timdietrich.me/blog/netsuite-custom-financial-portal-reports-charts/.