SuiteQL

How to Effectively Query Multiple Select Fields in SuiteQL

Struggling with querying multiple select fields in NetSuite using SuiteQL? Using an easy-to-understand example, this article explores advanced SuiteQL techniques for querying multiple...
Chidi Okwudire
6 min read

Master How To Auto-Assign Subsidiaries to Vendors in NetSuite: Part 2

Thinking about the problem of auto-assigning vendors to subsidiaries in NetSuite differently resulted in a more elegant solution. Learn patterns that will broaden your...
Chidi Okwudire
7 min read

Master How To Auto-Assign Subsidiaries to Vendors in NetSuite: Part 1

This article describes a common solution for auto-assigning vendors to subsidiaries in NetSuite. The challenge: Can you come up with a simpler solution?
Chidi Okwudire
4 min read

NetSuite 2024.2: Breaking Change to External Suitelet URLs and How to Handle It

NetSuite recently announced breaking changes to the external (a.k.a. anonymous) Suitelet URLs in 2024.2. This article will help you understand the impact on your...
Chidi Okwudire
5 min read

Learn to Query and Reuse Script Audience Configuration

In this article, I illustrate how to query script audience configuration for reuse in other contexts using a real-life client situation. This approach localizes...
Chidi Okwudire
4 min read

Learn How to Programmatically Attach a User Note to a Custom Record Without Hardcoding the Record ID

In this article, Chidi Okwudire shares how to attach a user note to a custom record entry using SuiteScript without hardcoding the record type's...
Chidi Okwudire
5 min read

How to Query NetSuite’s State/Country List

Learn how to get NetSuite's country/state lists using SuiteQL and the permissions required to access those tables via a custom role.
Chidi Okwudire
52 sec read

How to Script Unit of Measure Conversions

Learn how to leverage SuiteQL to perform unit of measure conversions in scripting and overcome known limitations of the N/search module in this area
Chidi Okwudire
4 min read

Tip: Learn How to Isolate Bounced Email Addresses When a Multi-Recipient Email Fails

This article describes three ways to find out which specific email addresses bounced when a multi-recipient email shows status "Not Sent" (although the email...
Gaurav Ahluwalia
3 min read

Learn How to Generate Meaningful Amortization JE Memo Lines When Using Native or No JE Approval

Do you find the default Amortization Journal Entry line memos "Amortization Source" and "Amortization Destination" unhelpful or slightly annoying? This article offers an adaptation...
Michoel Chaikin
4 min read
×