Home

Not able to fetch balance for Accounts using SuiteQL or SOAP search request

I am referring to the Analytics browser for fetching Account record
https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/account.html
I am retrieving them using suiteql, but some fields metioned on that page like balance,availablebalance – I am not able to retrieve
For ex : when I add balance in my suiteqlquery, it throws the following error
{
“type”: “https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1“,
“title”: “Invalid search query Search error occurred: Field ‘balance’ for record ‘Account’ was not found. Reason: REMOVED – Field is removed\n.”,
“status”: 400,
“o:errorCode”: “INVALID_PARAMETER”
}
similarly I am trying to fetch the account data using SOAP request which retrieves all the data with a basic search
https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/schema/record/account.html
Now this page also has openingBalance, but in the results it is not returned,
Can  someone please help me how to retrieve this data for accounts, Thanks in advance.
Rookie Asked on August 16, 2020 in SuiteTalk.
Add Comment
Cancel
1 Answer(s)

Have you double checked the permissions for the role that you’re using to run the query?

Cancel
Intermediate Answered on August 16, 2020.

sreenath

@abbott, I am running these queries as administrator, am I doing something wrong? Were you able to get the above data using the REST API using suiteql or SOAP requests. Kindly let me know if there are any specific permissions I need to give to get this data. Thanks.

on August 16, 2020.
Cancel
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor