)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Coefficient provides superior custom field handling compared to native NetSuite export methods, though some field type limitations exist. Most custom field visibility issues stem from permission problems or using the wrong import method.
Here’s how to troubleshoot missing custom fields and ensure they appear correctly in your Google Sheets imports.
Access custom fields through Records & Lists imports
Native NetSuite CSV exports often exclude custom fields or show them inconsistently. Coefficient’s Records & Lists import method includes custom fields alongside standard fields, making them easily accessible during the import process.
How to make it work
Step 1. Verify NetSuite permissions for custom fields.
Ensure your NetSuite role has SuiteAnalytics Workbook permissions and access to custom fields at the record level. Your role also needs REST Web Services permissions enabled for Coefficient to access the field data through the API.
Step 2. Use Records & Lists import for custom field access.
Choose “Records & Lists” from Coefficient’s import options and select your record type. Custom fields appear in the field selection list alongside standard fields. Use the search function to find specific custom fields quickly if you have many fields to choose from.
Step 3. Try SuiteQL queries for complete custom field control.
If custom fields don’t appear in Records & Lists, use Coefficient’s SuiteQL Query feature. Access custom fields directly using their internal IDs with queries like: SELECT custfield_example, standard_field FROM transaction WHERE custfield_example IS NOT NULL.
Step 4. Import through saved searches as an alternative.
If your custom fields are visible in a NetSuite saved search, they’ll import correctly through Coefficient’s Saved Search import method. This preserves all field configurations and ensures custom fields transfer properly to Google Sheets.
Step 5. Handle field type limitations appropriately.
Some custom field types have restrictions – Date/Time fields import as Date only, and certain complex field types may not be available. Check the field’s internal ID in NetSuite and verify it’s accessible through the API if problems persist.
Get reliable custom field access every time
These methods ensure maximum custom field visibility while maintaining data integrity and avoiding manual CSV manipulation. Start using Coefficient to eliminate custom field export headaches and access all your NetSuite data reliably.
