Tag: SAVEDSEARCH

Resolving the Error: “There is a divide by zero error in this search…” on a Saved Search

Scenario: At a saved search, user encounters an error: There is a divide by zero error in this search. It may be an error with a formula you have used. Please retry without the formula(s). If an error still occurs, please file with Customer Support. If it does not, please correct your formula. Typically that… Continue reading Resolving the Error: “There is a divide by zero error in this search…” on a Saved Search

Saved Search That Displays the Most Recent Task Created on an Opportunity

Scenario Create a Saved Search that will display the most recent Task created on an Opportunity. Solution A. If the fields are obtained from the Opportunity record, follow the below format. Navigate to Lists > Search > Saved Searches > New Click Opportunity Search Title: Enter Title Click Criteria Filter: Select Activity fields… Activity Filter: Select Activity type Activity Type:… Continue reading Saved Search That Displays the Most Recent Task Created on an Opportunity

Resolve error: “code”:”SSS_INVALID_SRCH_COLUMN_SUM”,”details”:”An nlobjSearchColumn contains an invalid column summary type

Scenario: Creating saved search in suite script which contains results having summary type. Solution: Check the field types. If the field type is numeric (e.g., Integer, Decimal Number), you can use “SUM”, “AVG”, “MIN”, “MAX”. If the field type is non-numeric (e.g., Text, List/Record), use “GROUP” or “COUNT”. If we are using summary types as… Continue reading Resolve error: “code”:”SSS_INVALID_SRCH_COLUMN_SUM”,”details”:”An nlobjSearchColumn contains an invalid column summary type

Item Saved Search for Quantity on Order Column divided into Open Purchase Order and Transfer Order

Scenario The user wants to create an Item Saved Search to get the quantity for Open Purchase Order and another column for Open Transfer Order from the Quantity On Order column under Item Record > Purchasing/Inventory tab > Locations subtab. Solution Navigate to Lists > Search > Saved Searches > New Select Item Search Title:… Continue reading Item Saved Search for Quantity on Order Column divided into Open Purchase Order and Transfer Order

Saved search for finding file from a folder based on the Return Authorization number using Suitescript 2.x

By using this solution, we can get the file which is stored in file cabinet on the specific folder with the file name of a Return Authorization number or related to any RA details using Suitescript 2.0 Suitescript: // salesOrderResult is an array of return authorization ids try {         var returnAuthorizations… Continue reading Saved search for finding file from a folder based on the Return Authorization number using Suitescript 2.x

Create a saved search to display the additional details of all transactions posted in the Sales/Revenue Account that are not available in the Financial Report Builder.”

Scenario: User needs to create a Saved Search that will display the additional details of all transactions posted in the Sales/Revenue Account that is not available in the Financial Report Builder. Solution: The Saved Search should list all Items for all transactions involved in the Sales/Revenue portion of the Standard Income Statement. Navigate to Reports > Saved Searches > All Saved Searches… Continue reading Create a saved search to display the additional details of all transactions posted in the Sales/Revenue Account that are not available in the Financial Report Builder.”

Creating an Average Items Per Order Search

To create a saved search of average items per order: Click Saved Searches > New to open a Saved Transaction Search page. Enter a descriptive Search Title. On the Criteria subtab in the Filter dropdown list: Select Type, choose Sales Order in the popup, and click Set. Select Main Line, choose No in the popup, and click Set. Select… Continue reading Creating an Average Items Per Order Search

Created as saved search to show the sales the that occurred within each hour in a day without tax.

Scenario: Create a saved search that shows the sales that occur within each hour in a day without considering the tax. Solution: List> Search> Saved Searches Select Transactions Enter Search Title Criteria: Type: Sales Order Status: is not Sales Order: Closed Date Created: is on Today Main line: False Results: Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’)… Continue reading Created as saved search to show the sales the that occurred within each hour in a day without tax.

Sales Report which shows the Revenue, Cost and Gross Profit

Requirement We will be able to create a Sales report in NetSuite to understand the revenue, cost, gross profit and gross profit percentage from a transaction. Solution Create a Transaction Saved search Add the following filters to the Criteria section Type = Sales Order, Invoice Main line = true Add the following columns in the… Continue reading Sales Report which shows the Revenue, Cost and Gross Profit