<img src="https://ws.zoominfo.com/pixel/5BFMW73xT6Cu70sN1cUt" width="1" height="1" style="display: none;">

Saved Search Tip: How to Filter Out a List of Specific Transactions

Posted by Sara Duong, Consultant on May 30, 2023 12:44:17 PM

Save searches have emerged as a powerful tool to sift through high volumes of data and uncover relevant information. However, there are instances when you need to extract data for a specific subset of transactions, without the overload of excess information. In this article, we will explore ways to leverage unique identifiers, such as Transaction IDs or Internal IDs, to streamline your search and focus solely on data that matters to you most.

Read More

Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Saved Search, Transactions, Transaction Lines, Implementation, Transaction IDs

Saved Search Update for HTML

Posted by Isaias Torres, Consultant on May 16, 2023 1:28:23 PM

In the upcoming Netsuite Release 2023.2, there will be a key change to a saved search function. This alteration specifically affects the HTML option available to users when creating formulas within the search. In this article, we will review how to maintain the HTML hyperlink option in your saved search fields. 

Read More

Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Saved Search, Customization, HTML

Counting Selected Values in a Custom Field from Saved Search

Posted by Kevin Suh, NetSuite Administrator on May 4, 2023 11:06:17 AM

NetSuite provides a variety of search tools to identifyimportant information, filter criteria, and obtainthe real-time data. I will shareone of the latest NetSuite search tips, methods, formula restrictions, and the importance of using NetSuite’s tools to quickly find information. In this blog, I will share the great tip to count the number of selected values from the custom field.  

Read More

Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Saved Search, Customization, Custom Fields

Inline Editing and Its Saved Search

Posted by Kevin Suh, NetSuite Administrator on Apr 4, 2023 9:02:12 AM

Inline editing is a great feature in Netsuite.Inline list editing enables you to update records quickly by changing data directly in a record's row on the list page.This capability supports faster and easier editing because you do not have to go into each record to edit it.

Read More

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, NetSuite Integrations, Saved Search, Cloud ERP, Inline Editing

Netsuite Connector Saved Search Export

Posted by Kevin Suh, NetSuite Administrator on Nov 17, 2022 11:38:27 AM

If you have a Netsuite Connector and need to export Saved Search results, the saved search export records in NetSuite can be configured to any File Transfer Protocol (FTP). NetSuite Connector uploads the saved search results to the configured FTP. You might be first interested in the Netsuite Connector. What is Netsuite Connector? NetSuite Connector (formerly called asFarApp) allows you to set up data mapping between NetSuite and your ecommerce storefronts, point-of-sale (POS) systems, online marketplaces and third-party logistics providers. By automating the transfer of data, you keep your vital information centralized and eliminate manual data entry, costly errors and delays, data exports and processes managed with spreadsheets and email. 

Read More

Tags: NetSuite, NetSuite How To's, NetSuite Tips, Connectors, Saved Search, FTP, SFTP

CASE STATEMENT use case – Intercompany Reconciliation

Posted by Justin Myung, Consultant on Oct 27, 2022 10:40:39 AM

Have you ever wanted or needed a quick comparative view of your Intercompany transactions between your subsidiaries?  One way to achieve this is through the use of CASE Statements in Saved Searches.  What is a CASE Statement?  A CASE Statement is similar to that of an if-then-else statement.  You may have encountered this in spreadsheetsIn NetSuite, it’s an available function that allows you to program conditions to return values when those conditions are met.  So, when a condition is true, NetSuite will provide the results based on those conditions.  You can have multiple conditions in one CASE Statement.

Read More

Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, Saved Search, Reconciliation, CASE, Formula, If-Then

Date/Period Mismatch – Life-to-Date

Posted by Justin Myung, Consultant on Oct 6, 2022 9:45:05 AM

There are many reasons why a company may want to have dates and periods not match-up.  One common reason may be related to the month-end close processA company may want to enter the actual date (which is in a prior period) of a vendor bill, but since the previous period has already been closed, they will post to the current period for financial purposes.  NetSuite can allowtransaction dates outside of the posting periods through the company’s Accounting Preferences.  This can increase the risk of unwanted date/period mismatches as well as cause headaches for reconciliations between AR/AP Aging reports to the Balance Sheet.  One way to monitor this is through a Saved Search. 

Read More

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Accounting Periods, Saved Search, Transactions, Date Mismatch

Get an Undeposited Funds as of Date Report

Posted by Justin Myung, Consultant on Sep 6, 2022 10:59:29 AM

Have you ever wondered if there was an easier way to get a detail report of Undeposited Funds for a previous Date?  If you have a lot of transactions that flow in and out of this account, it can be a daunting task if you don’t reconcile this right after month-end close or even if there happened to be back-dated transactions after you month-end bank reconciliation.   The following search will help you download a saved search report to solve that issue. 

Read More

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Financial, Bank Reconciliation, Bank Account, Saved Search, Transactions, Undeposited Funds

How to Resolve Period and Date Mismatches

Posted by Mariella Marquez, Consultant on Jul 12, 2022 1:30:00 PM

Have you ever noticed that your Balanced Sheet and Income Statement have different month end balances?

Read More

Tags: NetSuite, Accounting, Accounting Periods, Saved Search, Transactions, Date Mismatch

Content not found

Subscribe to our blog!

Recent Posts

Posts by Topic

see all