SuiteQL

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

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

Understand Line ID vs. Line Sequence Number in NetSuite Transactions

NetSuite transaction lines feature multiple IDs e.g. Line ID and Line Sequence Number. In this article, we explain the differences between them and which...
Chidi Okwudire
4 min read

Learn How to Generate Meaningful Rev. Rec. Journal Entry Memo Lines

Do you find the default Rev. Rec. Journal Entry line memos "Rev Rec Source" and "Rev Rec Destination" unhelpful or slightly annoying? We've got...
Chidi Okwudire
5 min read

Learn How to Generate Meaningful Amortization Journal Entry Memo Lines

Do you find the default Amortization Journal Entry line memos "Amortization Source" and "Amortization Destination" unhelpful or slightly annoying? This article offers a scripting...
Chidi Okwudire
5 min read

Learn To Write Custom List Code That Works In All NetSuite Environments (Revised)

This article explains how to produce reliable behavior when working with custom list values by using their script IDs (environment-agnostic) instead of their internal...
Chidi Okwudire
11 min read
×