NULLIF: Syntax: NULLIF(expr1, expr2) Description: Compares expr1 and expr2. If they are equal, then the function returns null. If they are not equal, then the function returns expr1. Example: NULLIF({price}, 0) NVL: Syntax: NVL(expr1, expr2) Description: Lets you replace null with the second parameter. Example: NVL({quantity},’0′) NVL2: Syntax: NVL2(expr1, expr2, expr3) Description: If expr1 is… Continue reading The NULLIF, NVL & NVL2 SQL Functions in Saved Search.
Author: Vishnudas P S
SOAP Web Services vs. REST Web Services Operation Mapping.
The following table maps SOAP operations to their corresponding REST equivalents.
Deferred Expense & Deferred Revenue Account Register.
Deferred Expense Account Register: A deferred expense register lists expenses that have been capitalized on a balance sheet and are to be expensed to the income statement later, in accordance with the nature of the expense. For example, a prepaid expense account is an example of a deferred expense account. Expenses are typically deferred and… Continue reading Deferred Expense & Deferred Revenue Account Register.
N/auth Module
Use the N/auth module to change your NetSuite login credentials. N/auth Module Members: Member Type Name Return Type / Value Type Supported Script Types Description Method auth.changeEmail(options) void Server scripts Changes the current user’s NetSuite email address (username). Method auth.changePassword(options) void Server scripts Changes the current user’s NetSuite password. auth.changeEmail(options): Method Description Changes the current… Continue reading N/auth Module
record.transform(options)
Transforms a record from one type into another, using data from an existing record. You can use this method to automate order processing, creating item fulfillment transactions and invoices off of orders. Returns record.Record Supported Script Types Client and server scripts Governance Transaction records: 10 unitsCustom records: 2 unitsAll other record types: 5 units Module… Continue reading record.transform(options)
Supported Transformation Types in record.transform(options)
Original Record Name Original Record Type Transformed Record Name Transformed Record Type Assembly Build assemblybuild Assembly Unbuild assemblyunbuild Build/Assembly assemblyitem Assembly BuildNote: You cannot use SuiteScript to create an Assembly Build for an Outsourcing Work Order. assemblybuild Build/Assembly assemblyitem Work Order workorder Cash Sale cashsale Cash Refund cashrefund Cash Sale cashsale Custom Sales Transaction customsalestransaction Cash… Continue reading Supported Transformation Types in record.transform(options)
NetSuite Transaction Status Codes
When working with NetSuite, transaction Statuses are one of the trickiest parts. The following are the transaction status and the respective status codes that can be used for attaching it. Bill:Open VendBill:A Bill:Paid In Full VendBill:B Bill Payment:Voided VendPymt:V Bill Payment:Online Bill Pay Pending Accounting Approval VendPymt:Z Cash Sale:Unapproved Payment CashSale:A Cash Sale:Not Deposited CashSale:B… Continue reading NetSuite Transaction Status Codes
Concept of Isolates in Dart
Dart was traditionally designed to create single-page applications. And we also know that most computers, even mobile platforms, have multi-core CPUs. To take advantage of all those cores, developers traditionally use shared-memory threads running concurrently. However, shared-state concurrency is error-prone and can lead to complicated code. Instead of threads, all Dart code runs inside of… Continue reading Concept of Isolates in Dart
Fall Through Condition in Dart
Fall through is a type of error that occurs in various programming languages like C, C++, Java, Dart …etc. It occurs in switch-case statements where when we forget to add break statement and in that case flow of control jumps to the next line. “If no break appears, the flow of control will fall through… Continue reading Fall Through Condition in Dart
Creating a Bundle with the Bundle Builder
You can use the Bundle Builder to create bundles. Bundles are packages of customization or configuration objects that can be installed in other NetSuite accounts. The Bundle Builder is available at Setup > Customization > SuiteBundler > Create Bundle if the SuiteBundler feature is enabled in your account and you have the SuiteApp Marketplace permission.… Continue reading Creating a Bundle with the Bundle Builder