SuiteQL EXTRACT: Get the Year and Month From a Date
Use EXTRACT(YEAR FROM date) and EXTRACT(MONTH FROM date) in SuiteQL to filter, group and compare NetSuite date fields, with alternatives using TO_CHAR.
Netsuite
18 notes in this thread.
SuiteScript Standard vs Dynamic Mode: Which Sublist APIs to Use
Choose the correct SuiteScript sublist APIs for standard and dynamic record modes, with working examples, field-sourcing differences and a debugging checklist.
Build Dynamic SuiteQL WHERE Clauses Without Breaking Bind Parameters
Keep optional SuiteQL filters and positional parameters synchronized, handle dates safely, and avoid malformed WHERE clauses and invalid bind types.
Why Suitelet FILE Fields Cannot Be Added to Subtabs
NetSuite FILE fields must remain in a Suitelet’s main area. Here is why native subtabs and upload controls conflict, plus practical layout alternatives.
How to Read Suitelet Sublist Values After a POST
Use ServerRequest.getLineCount and getSublistValue to process submitted Suitelet rows, with notes on validation, checkboxes and NetSuite’s raw sublist encoding.
SuiteScript Search Filter Expressions: AND, OR, NOT, Joins and Empty Values
A practical guide to composing N/search filter expressions, including nested OR conditions, NOT, joined fields, formula filters and NetSuite special values.
How to Stack Multiple Sublists on One Suitelet Subtab
Sharing a NetSuite tab does not make Suitelet sublists appear one beneath another. The missing piece is a shared subtab. Here is the working serverWidget pattern and its layout caveats.
SuiteQL Empty Strings Are NULL: Why Optional Filters Return No Rows
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.
Fix 'SuiteScript 2.1 Entry Point Scripts Must Implement One Script Type Function'
Diagnose the SCRIPT_OF_API_VERSION_2X_MUST_IMPLEMENT_A_SCRIPT_TYPE_INTERFACE error by checking script annotations, client-script paths and exported entry points.
SuiteQL Edit Column Name to Make It More 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…
SuiteCloud: Import a Custom Record and Its Custom Fields
Import a NetSuite custom record type into an SDF project with SuiteCloud CLI and understand how customrecordcustomfields appear in the generated XML definition.
SuiteQL Generate Numbers from 1 to N Using DUAL
There are times when I want to generate a list of numbers from 1 to n in Netsuite and it usually involves dates. For example, if I wanted to calculate the number of actual work day…
SuiteQL: My Default Query Template
When creating a SuiteQL query in SuiteScript I'm finding my query starts with the following structure: What I'm finding with my SuiteQL queries is that I want to place all my input…
SuiteQL Query to 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'
SuiteQL LISTAGG can fail with an invalid or unsupported search when its VARCHAR2 result exceeds the available size. Here are practical ways to reduce or truncate it.
Suitescript Reference File Without Domain
How do you reference images that are stored in your Filing Cabinet when trying to embed them into HTML. For example, when using logos in your emails how do you reference them? When…
Suitescript Object Script Deployment Recurrence
When creating an XML object definition for your Suitescript deployment I noticed the schedule for the deployment was different to what I had coded. Here's a snippet of the XML obje…
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.