Improve NetSuite Vendor Management Efficiency With A Vendor Activity Check

Get Rid of All the Clutter in 12 Steps
Book Clutter

Vendor management is a critical aspect of any business operation, and efficient processes can significantly impact the overall productivity and financial health of an organization. In this blog post, show how to identify non active NetSuite vendors and remove them from your active vendor list. The advantages of using NetSuite’s vendor activity checks, will help to prevent paying closed contract purchase orders (POs), make it easier to find vendors, and decrease page load times. Let’s dive in!

Inactivating Non-Active Vendor Records Can:

decrease Page Load Times

Make it Easier to find vendors

Prevent Paying closed contract POs

Step 1: Create a New Saved Search

From the top Navigation Global Search Enter: “new saved search”

NetSuite - New Saved Search

Step 2: Select Vendor

Scroll down and select “Vendor” from the list of search types

Select the Vendor Record

Step 3: Enter a name and Criteria

Enter a name for the saved search “Vendor Activity Check” and the following critera

Inactive > No

Transaction Fields… > Type > Bill Payment

Criteria 1

Step 4: Click Results and copy the result values

Enter the following fields into the result tab

Name (Set Summary Type to Group)  

Internal ID

Transaction Fields… > Date (Set Summary type to Maximum)

Transaction Fields… > Date (Set Summary Type to Count)

Transaction Fields… > Document Number  

Transaction Fields… > Internal ID

Results 2

Step 5: Click Save & Run

Click “Save and Run” by hovering over the save button.

Click Save and Run

Step 6: Export the Data

Export the Data to excel by clicking the button highlighted in the image below

resultset 3

Step 7: Edit the CSV in Excel

Using a combination of the Last Transaction Date and the total Count of Transactions you can determine which Vendors should be inactivated. The results go from least active vendors on the top to most active below. REMOVE ALL Vendors from the CSV you wish to keep active. All remaining Vendors on the CSV will be inactivated in the next few steps.

Note: Remove the last line on the CSV as this line is the total count

Save the File

Step 8: Import the CSV to NetSuite

In the Navigation Global Search type: “Page: Import CSV Records”

On the first page select the following:

Import Type: Relationships

Record Type: Vendors

Then select the CSV file you saved in the previous step

Click Next


Step 9: Select Update then Click Next

Select Update from the Data Handling List

Under Advanced Options – Make sure “Custom Form” is set to the “Standard Vendor Form”

Then Click Next

Next 1

Step 10: Enter the Field Mapping

Internal ID should be automatically set

Select the second line under Internal ID 

Then Select “Inactive” from the List on the Right

Click on the Pencil Icon on the second line and select Yes

Then Click Next


Step 11: Save and Run

Hover over the Save button and Select “Run”


Step 12: Verify the Import was Successful

Select Import “Job Status Link”


Verify that ALL records were imported successfully

success 2

That's it!

Your non-active vendor records are now inactive and creating much less clutter in your system. 

If you have any questions at all please reach out to and we would be happy to help!



More Posts you may like:

The Complete Guide to NetSuite Sandbox Refresh: Best Practices and Benefits

NetSuite sandbox refreshes are an essential part of maintaining a well-functioning environment. TAC, a leading NetSuite Alliance Partner, will guide you through this journey. This detailed guide outlines the proposed step-by-step process for refreshing your NetSuite sandbox, while also emphasizing best practices to consider before performing a sandbox refresh.

Bank Parser

The Ultimate Guide to Setting up Bank Parsers and Bank Statement Imports in NetSuite

Are you interested in making your financial processes more efficient and optimizing your NetSuite experience? Well, the key lies in connecting bank parsers and setting up bank statement imports. These processes allow for your organization to import bank activity daily, thus significantly reducing time to close at month end. In this guide we will walk you through each step of the process to help you successfully implement this functionality within NetSuite.

Multi-book Accounting

Understanding Multi-Book Accounting in NetSuite with Expert Insights

Is your organization facing challenges of managing numerous financial records or ensuring GAAP compliance within your NetSuite environment? Fortunately, NetSuite offers a powerful solution known as Multi-Book Accounting that can only be effectively implemented by a certified NetSuite Partner or the experts at NetSuite Professional Services.

Request a demo

Fill out the form below and our team will be in touch shortly.