I created a Saved Search on Transfer Orders that should only return one line, since the Transfer Order has only one item line. However, when I run the search, it gives me three lines instead of one. It seems that the results are being duplicated, but I can’t figure out why. I would like the search to show only one line per Transfer Order.

AI generated answer (using internal Slack threads):

It seems like your Saved Search is returning multiple lines because it's not set to only return the main line. In NetSuite, a single line in the UI can actually be represented by multiple lines in the database. For example, a Transfer Order with one item line can have a fulfilling line, a receiving line, and a third line that represents what you see in the UI. To fix this, you need to adjust your Saved Search criteria. Set the "Main Line" criteria to "True". This will ensure that your search only returns the main line for each Transfer Order, which should eliminate the duplicate lines you're seeing. Here's how you can do it: 1. Go to your Saved Search and click "Edit". 2. In the "Criteria" tab, find the "Main Line" field. 3. Set the "Main Line" field to "True". 4. Click "Save". After making this change, your Saved Search should only return one line per Transfer Order, as expected. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******