NSC | Creating a Saved Search for Duplicate Vendor Bill Reference Numbers

Scenario

A user needed to identify Vendor Bills that were created with duplicate Reference Numbers in NetSuite.

The account was configured with the Warn Only preference for duplicate numbers, which allowed users to override the warning and continue saving duplicate Vendor Bills. Because of this, the user wanted to create a Saved Search that would identify duplicate Vendor Bill Reference Numbers and trigger an email notification whenever a new duplicate bill was created.

Solution

Create a Transaction Saved Search using the following configuration to identify Vendor Bills with duplicate Reference Numbers.

Create the Saved Search

Navigate to Reports > Saved Searches > All Saved Searches > New then select Transaction as the search type.