Jeff Greene
04/25/2025, 4:05 AMCeligo AI
04/25/2025, 4:05 AMAI generated answer (using internal Slack threads):The fastest way to fetch retained earnings via API would be to use SuiteTalk API. You can create a saved search in NetSuite that shows everything that adds up to the Retained Earnings on the Balance Sheet. Then, you can use the SuiteTalk API to fetch the results of this saved search. Here is a sample code snippet on how to fetch saved search results using SuiteTalk API:
javascript
var search = nlapiLoadSearch(null, 'customsearch_your_saved_search_id');
var resultSet = search.runSearch();
var results = [];
var index = 0;
var step = 1000; // max is 1000
do {
var subset = resultSet.getResults(index, index + step);
if (subset) {
results = results.concat(subset);
index += step;
}
} while (subset && subset.length === step);
Please replace 'customsearch_your_saved_search_id'
with the ID of your saved search.
Remember, if you are dealing with a large number of records, fetching the data might take some time. Also, if you need to track deleted transactions, you might want to use the getDeleted
operation.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
04/25/2025, 4:06 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.796754956
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.78819555
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.780275047
Celigo AI
04/25/2025, 4:06 AM