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

Hi,
I am running suiteQL query to get custom field from InventoryNumber record and I get an error of 'field not found' but the field is exists. Any idea what can block me to see the field through SQL query?

image.png

Should still appear in the Setup &gt; Records Catalog (not to be confused with the SuiteScript Records Browser)

Navigate there, then switch over to the “Fields” search and see if it is missing

If so, likely it is not storing a value or there is some sort of permissions issue

If it is a Non Store Value field, you have to repeat the lookup in the query (for example, sourcing and filtering is set to Customer : Field, you have to join on the entity and pull in that field in the query from the Customer table, and not rely on the custom field you created

its store value field, I cant find it in records catalog - Inventory Number record

:shrug:

I see this was asked before too

<https://netsuiteprofessionals.com/blog/question/can-the-rest-api-be-used-to-get-custom-fields-from-inventory-numbers/>

https://&lt;accountid&gt;.<http://app.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=#/record_ss/inventorynumber|app.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=#/record_ss/inventorynumber>

but no custom fields show there… the question is why - or how you can get access to them via SuiteQL. May be more appropriate for that channel

So basicly there is no option to get custom fields...

<@U022AH86RB7> did you try posting to <#C01FBBZ8PQC|>?

Posting now, didnt know that there is suiteql channel