To find items with the same display name but different manufacturers in a NetSuite saved search, you can use a combination of filters and formulas. Here’s how you can approach it:
1. **Create a Saved Search**:
– Navigate to **Lists > Search > Saved Searches > New** and select the **Item** record type.
2. **Set Criteria**:
– Add a filter for items with a **Display Name** that is not empty.
– Optionally, filter for specific item types if needed (e.g., Inventory Items).
3. **Use a Formula Field**:
– In the **Results** tab, add a **Formula (Text)** field to group items by their display name and manufacturer.
– Use a formula like this:
```sql
{displayname} || ' - ' || {manufacturer}
```
– This concatenates the display name and manufacturer into a single field for easier comparison.
4. **Group and Summarize**:
– Set the **Summary Type** for the formula field to **Group**.
– Add a **Count** field to identify items with multiple manufacturers for the same display name.
5. **Filter for Duplicates**:
– In the **Criteria** tab, add a filter to show only items where the count of manufacturers is greater than 1.