Hi, I have a custom field on Inventory Number record, but can't get it via suiteQL query, its says that the field is not found in that record. Any idea how can I get custom fields in Inventory Number? the field is simple text field with store value.

Does the role you're querying with have access permissions to that field?

is the custom field display type editable?

The role is administrator, and the field is editable... all the custom fields in this record are not showing in sql

If it's a custom field that shows up on a Inventory Number record in the UI, it's probably a custom Item Number field. I don't know how to surface those via SuiteQL

I know its custom item number field, but still there is no way to get in ? very strange

Please make sure that filed had store value checked and was it a list type field?