Hi we’re trying to get the vendor name, using suiteql but Vendor.AltName Vendor.CompanyName Vendor.EntityTitle are all empty

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you are trying to retrieve the vendor name using SuiteQL but the fields

Vendor.AltName

,

Vendor.CompanyName

, and

Vendor.EntityTitle

are all empty. One possible reason for this could be that these fields are not populated in your NetSuite instance. In NetSuite, the vendor name is usually stored in the

entityid

field of the Vendor record. You can try using the

entityid

field in your SuiteQL query to retrieve the vendor name. Here is an example of how you might structure your SuiteQL query:

sql
SELECT entityid FROM Vendor WHERE internalid = 'your_vendor_internal_id'

Please replace

'your_vendor_internal_id'

with the actual internal ID of the vendor you are trying to retrieve. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******