jhayczee09
04/22/2025, 9:08 AMCeligo AI
04/22/2025, 9:09 AMAI generated answer (using internal Slack threads):Based on the conversations, it seems that you are trying to display multiple subsidiaries as one line in the results of a saved item search. However, when you add the subsidiary field, you get multiple lines for one account for each instance of a subsidiary. In NetSuite, when a GL account has multiple subsidiaries (or Include Children is checked), it will by design result in more than one row. This is because each subsidiary is considered a separate entity and the balances are maintained separately for each subsidiary. If you want to limit the results to show only one line per account, you can try using the 'Group' summary type for the subsidiary field in your saved search. This will group the results by the subsidiary field. However, please note that you need to use 'Group' on each field otherwise it will not appear. For cases where you have accounts that are only for one subsidiary and you want to see the named subsidiary, you can add a criteria in your saved search to filter out the parent subsidiaries. For example, you can add a criteria where 'Subsidiary' is not equal to 'Parent Subsidiary'. This will exclude the parent subsidiaries from the results and only show the child subsidiaries. In case you want to show the balance for each subsidiary of a vendor, you can try using the 'Vendor-Subsidiary Relationship' saved search type. This will allow you to see the balance for each subsidiary of a vendor. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
04/22/2025, 9:09 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.858260036
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.85743
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.853467464
Celigo AI
04/22/2025, 9:09 AM