I am trying to get the value of my custom item number field from the inventoryNumber table but I cant seem to get it. is it possible to get custom item number fields thru suiteql? is it a limitation?

@tech_ph2019 Custom fields are generally accessible through SuiteQL. I don't know if there are any limitations specifically for the inventoryNumber table. Have you checked that there are no access/permission conflicts between the custom field and the role you're using to access it?

@Clay Roper I am using the suiteql query tool suitelet running as admin

How did you create the custom field?

from customization > List, Records & Fields > Item Number Fields > New

I ran a test, and Netsuite doesn't add a custom field created in this way to the inventorynumber table. I'm not sure where it's stored, or whether it's just that they don't provide access to it through SuiteQL

thanks @Clay Roper for verifying it on your end. its probably a limitation

I think so, especially considering that it's referenced differently as Item Number and Inventory Number in different places, and knowing that the tables we have access to via SuiteQL are generally computed tables or views, and not actual direct database tables.