Hi. I am trying to read the VAT number with SuiteQL I can do it with records, in

record.Type.CUSTOMER

the field is called

vatregnumber

But I can not find it with SuiteQL in tabel

customer

or

entity

I can see that the Custom Entity Field is added to

Project

and not

Customer

as I expected, but still dont understand what table to look in

Have you looked at

customertaxregistration

?

No. Is that a table ?

It is - you can see the SuiteQL schema available in your account at https://system.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=

I dont have a customertaxregistration

I found it through the customer table - do you see it here? https://system.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=#/record_ss/Customer/taxRegistration

Seems empty

Gotcha - it looks like it requires SuiteTax.

Ok. So suiteql might be difficult? Can I use search to find all with missing VAT?

Have you tried searching for "vat" in the Fields search of the Records Catalog link I sent you? Top left, toggle from Records to Fields

We had the same problem. The field was unavailable in SuiteQL. In saved searches is there

{vatregnumber}

We ended up creating a custom field to get that information in SuiteQL and REST API. At least for REST there is a disclaimer: "REST web services do not support legacy tax features"

Thanks @Edgar Valdes Are you using a user event script then, to sync the vat to a custom field so it’s accessible in SuiteQL?

Set in a Workflow, After Record Submit, we manually set the Custom Tax Number and it goes to the native field.

Thanks 👍