SuiteQL Metadata vs SuiteCloud XML
Choose SuiteQL analytics metadata or SuiteCloud SDF XML for custom-record field definitions—and avoid treating them as interchangeable schemas.
SuiteQL
29 notes in this thread.
Export NetSuite Custom Field Data Dictionary
Build a SuiteScript export of custom-field definitions with SuiteQL pagination, CSV escaping and columns adapted to your Records Catalog.
Why CustomRecordCustomField Is Missing in SuiteQL
Diagnose why CustomRecordCustomField does not appear or query in SuiteQL: Records Catalog channel, role permissions, features and common false leads.
NetSuite Custom Field Metadata Tables
Map NetSuite custom-field families to SuiteQL metadata records, clarify definition versus instance data, and use the Records Catalog as the source of truth.
Find a Custom Field List or Record Type in SuiteQL
Use SuiteQL and the Records Catalog to identify which list or record a SELECT custom field references, without guessing analytical field IDs.
Join CustomRecordCustomField to CustomRecordType
Confirm the SuiteQL relationship between custom-record field metadata and its owning custom-record type using the Records Catalog.
CustomRecordCustomField SuiteQL Columns
A practical column checklist for SuiteQL against CustomRecordCustomField: which analytical fields to confirm in the Records Catalog and how to select them safely.
Preserve Journal Credits When Updating Invoices
Safely update a NetSuite invoice without losing its applied journal credits by snapshotting applications and restoring missing amounts through a zero-dollar customer payment.
SuiteQL Customer Address Tables Explained
Understand Customer, CustomerAddressBook and CustomerAddressBookEntityAddress and join them correctly in SuiteQL.
Why SuiteQL Address Joins Return Duplicates
Diagnose duplicate customer rows in SuiteQL address queries and choose the correct result grain instead of relying on DISTINCT.
SuiteQL Default Billing and Shipping Address
Return a customer default billing address, default shipping address or both with SuiteQL while retaining customers without an address.
SuiteQL Time Zones: Why Dates Shift by a Day
Diagnose SuiteQL dates that appear one day early or late by separating date-only values, timestamps and JavaScript time-zone conversion.
SuiteQL Accounting Period and Fiscal Year Queries
Query NetSuite accounting periods with SuiteQL and avoid confusing transaction dates, posting periods and fiscal calendars.
SuiteQL GROUP BY Month, Quarter and Year
Group SuiteQL results by calendar month, quarter or year while keeping the output correctly sorted across multiple years.
SuiteQL Date Binds: TO_DATE and TO_TIMESTAMP
Pass dates and timestamps safely to N/query SuiteQL using bind parameters, TO_DATE and TO_TIMESTAMP with explicit formats.
SuiteQL Date Filters: Current and Previous Month
Filter SuiteQL records by the current month, previous month or a custom date range without losing rows at time boundaries.
NetSuite API With Python: REST and RESTlets
Connect Python to NetSuite using OAuth 2.0, REST Web Services, SuiteQL and RESTlets, with pagination, retries, error handling and secure configuration.
Find SuiteQL Table and Field Names
Use the NetSuite Records Catalog to find SuiteQL record, field and join IDs, understand role-specific availability and diagnose unknown identifier errors.
SuiteQL Result Limits and Pagination
Understand the 5,000-row runSuiteQL limit, runSuiteQLPaged page sizes, deterministic ordering, governance and the 100,000-row paged-result ceiling.
Query Custom Record Fields With SuiteQL
Find CustomRecordCustomField metadata in the NetSuite Records Catalog and query custom-record field IDs, labels and relationships safely with SuiteQL.
SuiteQL EXTRACT(YEAR FROM): Year and Month
Use EXTRACT(YEAR FROM date) and EXTRACT(MONTH FROM date) in SuiteQL to filter, group and compare NetSuite date fields, with TO_CHAR alternatives.
Dynamic SuiteQL WHERE Clauses and Bind Parameters
Keep optional SuiteQL filters and positional parameters synchronized, handle dates safely, and avoid malformed WHERE clauses and invalid bind types.
SuiteQL Empty Strings Are NULL
A blank SuiteQL parameter is not equal to an empty string. Learn why optional filters silently remove every row, how to reproduce the problem, and two reliable ways to fix it.
Make SuiteQL Result Column Names Readable
If you're using Tim Diedrich's SuiteQL suitelet in your Netsuite instance to generate a table of results and want to present this result but don't like the column headers, or if yo…
SuiteQL: Generate 1 to N Series With DUAL
Generate a number or date series in SuiteQL using DUAL, CONNECT BY or portable digit sets for working-day calculations and missing-period reports.
Reusable SuiteQL Query Template
A practical SuiteQL starting template for named columns, bind parameters, optional filters, deterministic ordering and N/query execution.
SuiteQL: Get Customer Address Details
Join Customer, CustomerAddressBook and CustomerAddressBookEntityAddress to retrieve billing, shipping and street-address details with SuiteQL.
Fix SuiteQL LISTAGG Invalid or Unsupported Search
LISTAGG is currently listed as unsupported in SuiteQL. Diagnose the generic error and replace string aggregation with grouped rows or JavaScript processing.
Optimise a Slow SuiteQL Query With a CTE
A SuiteQL budget query fell from almost nine minutes to five seconds by filtering the required category in a CTE before joining the larger result set.