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

Trying to write a script to validate a unique "Tax Reg. Number" / *vatregnumber on new Vendor add.  Oddest thing...*
*I can't seem to find where to query that field from.  Not showing in Saved Search.  Also tried exploring with SuiteQL*
SELECT TOP 1* FROM vendor WHERE id = '5915'
The field is not present 

Has Anyone tried this before or offer insight as to how this vat field is tied to the vendor record? Any feedback is appreciated 

Screenshot_20250110_220251.png

In the schema browser it shows as a search column and filter. `vatregnumber`

it can be a different field name in different NetSuite TAX setup... I noticed that
vatregnumber
taxidnum

Forgot the exact names, but I remember that. And because of that, I have in a configuration record value for TAX ID field.
Did you check fieldid on the label?