Global Search


Global Search is the input bar on the top of you every NetSuite page.  You can think of it as the Google for your NetSuite environment and there are some cool things you can do to save time!

  1. Add prefixes to your search, the first three letter follow by a colon (:) is telling NetSuite to filter transaction type on the spot.  Here is an example:
    sa:119012 results in






    This is telling the search to filter to the sales order number.

    inv:325689 results in







    This is telling the search to filter to invoice number.
    Here is a cheat sheet for the abbreviations.


  2. To show all inactive records in the global search you can append the plus sign (+) at the end of the string text.  For example, em:33150+
  3. To search using wildcard you can insert the percentage signs (%).  For example, if you type in Jack% H%le, you would get Jackson Hole in return, if there is a record of such.  The trick can also be applied in Saved Search filters.
  4. Combined search is possible when you insert OR in between.  For example, emp:Ian OR Ivy

Comments

Post a Comment

Popular posts from this blog

Troubleshoot : Purchase Order did not Auto Generate for Drop Shipping

Issue: You have created a Sales Order that includes one or more Drop Ship item (item record that has the checkbox Drop Ship enabled) > Save. You expectation is that NetSuite will automatically generate the Purchase Order on the dropship items for you.  This is standard NetSuite drop ship behavior. What actually happened is it didn't, you still have to manually Drop Ship it from the CREATE PO sub list column. You don't have custom script or workflow running on sales orders. Resolution: CHECK your item setup for Purchase Price. CHECK your item setup for Preferred Vendor. CHECK your item setup for Subsidiary of Preferred Vendor matching your Subsidiary of Sales Order. CHECK your sales order is Approved. If the standard behavior is not working, it is most likely due to the item setup.  Focus on item setup and go from there.
Read more

SuiteScript : Defaulting Tax Code at Line Level

Script Difficulty: 💚 Here is a time where you would like to set the tax code at the line level to select a certain tax.  This is an alternative solution to demonstrate that you can consider scripting to implement at the line level.  The solution also combined with a control point visible to the user for triggering of the script actions. Exercise goal: for all Invoices, have a custom checkbox that controls the triggering of setting tax code to NoTax to every line and override the tax to zero at save. Create a new custom checkbox and give it a good name, in our case it's Wipe Tax.  Set the checkbox's internal ID to custbody_wipetax .  Customization > Scripting > Scripts > New Script Under Script File field, upload the JavaScript  > Create Script Record > User Event Give it a good name. Under Script tab, set BEFORE SUBMIT FUNCTION to userEventBeforeSubmit . Under Deployments tab, apply the script to Invoice.  Give a good deploy name, set Deploy...
Read more

Saved Search Build : Find And Replace Substrings

Build Difficulty: 💗💗💗💗 The time has come that you need to find certain string in the column and replace it with a hard-coded ones.  Additionally, we are combining this search & replace with a nested comparison logic. Exercise goal: look at the Posting Period and replace with the first of the month instead of of the abbreviations in the results.  For example, transform from "Feb 2022" to "2-1-2022". TRANSACTION search CRITERIA Posting = T RESULTS Document Number Formula Text = "CASE WHEN REGEXP_SUBSTR({postingperiod},'\A\w\w\w\s')='Jan ' THEN REGEXP_REPLACE({postingperiod},'\A\w\w\w\s','1-1-') WHEN REGEXP_SUBSTR({postingperiod},'\A\w\w\w\s')='Feb ' THEN REGEXP_REPLACE({postingperiod},'\A\w\w\w\s','2-1-') WHEN REGEXP_SUBSTR({postingperiod},'\A\w\w\w\s')='Mar ' THEN REGEXP_REPLACE({postingperiod},'\A\w\w\w\s','3-1-') WHEN REGEXP_SUBSTR({postingperiod},'\A\w\...
Read more