Tag: saved search

Customer Aging Report Using Saved Search

var invoiceSearchObj = search.create({    type: “invoice”,    filters:    [       [“type”,”anyof”,”CustInvc”],        “AND”,        [“mainline”,”is”,”T”],        “AND”,        [“amountremaining”,”greaterthan”,”0.00″]    ],    columns:    [       search.createColumn({          name: “entity”,          summary: “GROUP”,    … Continue reading Customer Aging Report Using Saved Search

Customer Aging Report Using Saved Search

var invoiceSearchObj = search.create({    type: “invoice”,    filters:    [       [“type”,”anyof”,”CustInvc”],        “AND”,        [“mainline”,”is”,”T”],        “AND”,        [“amountremaining”,”greaterthan”,”0.00″]    ],    columns:    [       search.createColumn({          name: “entity”,          summary: “GROUP”,    … Continue reading Customer Aging Report Using Saved Search

How to fetch saved search data with the title

Recently, I worked on a single-page application(SPA) for rendering saved search data from NetSuite. The client wanted to reuse the application for multiple saved searches. So, the app was designed with a search internal ID as a URL parameter and the data was fetched using the ID. However, the client also wanted to show the… Continue reading How to fetch saved search data with the title

Change date format in a NetSuite saved search result column

In NetSuite, the TO_CHAR() function can be used to convert a date object into a text representation of it. Here are some examples of date/time format values that can be used with TO_CHAR(): ‘YYYY’: 4-digit year‘IY’ or ‘IYYY’: ISO Year‘M’: Month2‘DL’: Long version of the date including day of the week, month, day, and year‘YEAR’:… Continue reading Change date format in a NetSuite saved search result column

Saved Search To Retrieve The Last Three Purchase Orders

Record Type: Transaction (as Purchase Orders are transaction records). Criteria: Type is Purchase Order: This filters the search to only include Purchase Orders. Main Line is True: Ensures that only the main line of transactions is considered. Date Created or Date of Purchase Order: Choose one of these date fields to sort the purchase orders.… Continue reading Saved Search To Retrieve The Last Three Purchase Orders

Send Email Alert using Transaction Saved Search when Item Fulfillment Status Changes

User creates a Transaction Saved Search to send an email alert that is triggered whenever there is a change in the Item Fulfillment status. However, user has customized its Item Fulfillment Status names and the email alert does not send as expected. The system still respects standard name of the status of the Item Fulfillment (Picked/Packed/Shipped), regardless of the name… Continue reading Send Email Alert using Transaction Saved Search when Item Fulfillment Status Changes

Formula to find the day difference between two Dates

Scenario: In the vendor record, we have a status called ‘Charity Status’. While creating a vendor record, the status is set to ‘Initial contact’. The status of the vendor will converted to ‘Approved – Active’ after a time period. So the requirement is to calculate the number of days from the ‘Initial contact’ date/ create… Continue reading Formula to find the day difference between two Dates

Inventory Activity Detail Report in Saved Search

Requirement: A user wants to show the Item with Quantity only that will match with Inventory Detail Report. This search should only expose the Item and Quantity Summary Initially but upon clicking on the Item it should expose all the relevant transactions for it. Solution Create a Transaction Saved Search by navigating to Reports > Saved Searches > All Saved… Continue reading Inventory Activity Detail Report in Saved Search