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

Untitled.sql

I have this query that works fine in two different, unrelated accounts, but when running in a third account, I get:  `Field 'consolDaysOverdueSearch' for record 'Customer' was not found. Reason: REMOVED - Field is removed`.  Any idea why this might be?  In the table reference of Tim's SuiteQL tool, the field is shown.

It's because the "Consolidated Payments" feature is not enabled in the target account. :shrug:

Tim is using the built in Records Catalog found at Setup > Records Catalog.

You will notice in that UI, you have a choice whether to display 'Unavailable' fields or not.

e.g. some Payroll related fields on the Employees record may not be available, to the Analysis tool, or the SuiteQL Tool, even as an Administrator.