This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Does anyone know why I would be getting a record not found when querying `select * from inventorybalance`?

1. Is there a check box next to the fields in the "available" column?

2. does the role you are using have permissions? or is this done in code?

Can you post your code and the exact full text of the error message?

code: `query.runSuiteQL('select * from inventorybalance')`
error:
```{
    "message": "Search error occurred: Record 'inventorybalance' was not found.",
    "name": "SSS_SEARCH_ERROR_OCCURRED",
    "userFacing": true,
    "id": null
}```

image.png

I think that inventorybalance is only active if you have bin management turned on