Author: Bibin Babu

Saved Searches are powerful, but when dealing with large datasets, performance issues arise. This article covers best practices to optimize Saved Searches for faster reporting. Optimization Techniques Use Indexed Fields in Criteria Filtering on indexed fields (like internalid, datecreated) speeds up queries. Minimize Use of Joins Avoid excessive joins (Created From, Parent Transaction), as they… Continue reading Optimizing NetSuite Saved Searches for Faster Data Retrieval

Manual journal entries can be tedious and error-prone, especially when dealing with large transactions. This article explores how to automate journal entries using SuiteScript 2.0, reducing manual work while maintaining accuracy. Script Implementation Define the Script Type Use a User Event Script for automating journal entries upon record submission. Use a Scheduled Script for bulk… Continue reading Automating NetSuite Journal Entries Using SuiteScript 2.0

Use Case: Ability to show Count of Cases and whom they are Escalated To and to be able to drill down on the Escalated To field to see detailed results Create a Saved Search by following these steps: 1. Navigate to Lists > Search > Saved Searches > New. 2. Select Case. 3. Provide a… Continue reading Case Saved Search that allows you to drill down on grouped Escalated To field

If one needs to get an alert on every click out of the Address book sublist in the customer record, set up the client script below. The API will return the line number selected. Using the API returns a more consistent value than just returning a parameter like linenum. 1. Setup > Customization > Scripts… Continue reading Return Currently Selected Line Item on Address of a Customer Record via nlapiGetCurrentLineItemIndex

To correct the error message “Invalid subsidiary reference key xxx” when importing Journals: 1. Verify that the subsidiary is an active and existing subsidiary by navigating to Setup > Company > Subsidiaries. The subsidiary should be spelled the way it is spelled in the record. It is also possible to export the list of subsidiaries to get the correct format. If the Subsidiary… Continue reading Invalid subsidiary reference key xxx is received on CSV Import of Journal Entry

An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag https://system.netsuite.com/ to all relative anchors such as <a href=”#top”>Back to top</a>.   i.e. The email message includes a “Back to Top of Page” link and clicking it should return the user to the top of the page. This looks… Continue reading An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag https://system.netsuite.com/ to all relative anchors

The “Custom Inventory Balance Search 55” is currently returning all available inventory details, including those that are not associated with inventory numbers. However, transactions require only inventory with associated inventory numbers to be selectable. This task involves reviewing and updating the search to ensure it fetches only the inventories available for transactions. Current Issue: The… Continue reading RAF Support for inventory detail search

1. Navigate to Transactions > Management > Saved Searches > New. 2. Select Transaction. 3. In the Criteria tab > Standard subtab, set the following filters: — Type = is any of Bill, Purchase Order — Status = is any of Bill:Open, Purchase Order:Pending Supervisor Approval, Purchase Order:Pending Receipt, Purchase Order:Pending Bill. — Main Line… Continue reading Saved Search to Display Combined Open Bills and Open Purchase Orders that Exceeds their Credit Limit

It is important to take note of those accounts we deem as a Contra Revenue Account. A Contra Revenue Account is one that oppose the normal balance of a relative income account such as Sales Returns and Allowances, and Sales Discount. When entering budgets via Transactions > Financial > Set Up Budgets, Contra Revenue Accounts… Continue reading Budget Income Statement > Contra Revenue Account Amounts were Added Instead of Being Deducted to Total Sales

1.  Navigate to Reports> Saved Searches > All Saved Searches> New 2.  Choose Search Type “Transaction” 3.  At the Criteria tab, set the following: Filter Description Formula Type Is Invoice Main Line Is true Formula (Numeric) Is 1 Case When {shipaddress} != {custbody_end_user_default_ship_address} then 1 else 0 end Date Depends on the date range that the users need… Continue reading Create a Saved Search to Display invoices with Different Ship to Address and “End User” Ship to Address