Expense Category Saved search on the Subsidiary mu...
# ask-stanley-ai
n
Expense Category Saved search on the Subsidiary multi-select field not pulling all data
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems that the issue of the Expense Category Saved search not pulling all data on the Subsidiary multi-select field could be due to the way the search is set up. In NetSuite, when you run a saved search and add the subsidiary as a result or criteria, it shows multiple lines per account - each child subsidiary that is selected shows up on a different line. This could be why you're not seeing all the data you expect. One suggestion from the conversations is to use the 'Group' option for the field as Summary type. This will limit your list and could potentially show all the data you're looking for. However, you need to make sure to use 'Group' on each field, otherwise, it will not appear. Another suggestion is to try the vendor-subsidiary relationship saved search type if you're dealing with vendors with multiple subsidiaries. Lastly, if you're dealing with departments, it was mentioned that a query join might solve the issue, although it was still a problem in the search. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840266228
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840159118
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835863709
Please provide your feedback on this answer.
Thank you for your feedback