When running a saved search on the account record (chart of accounts), how do you display the 'parent' or 'subaccount of' field in the saved search? Is it possible?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** In NetSuite, when running a saved search on the account record (chart of accounts), it is not directly possible to display the 'parent' or 'subaccount of' field. This is because NetSuite does not expose this field in the saved search for the account record. However, there are a couple of workarounds that you can consider: 1. SuiteAnalytics Workbook: Some users have suggested using SuiteAnalytics Workbook as it exposes more fields on Account records compared to Saved Searches. 2. Custom Field: Another workaround is to create a custom field on the account record, source it from the subaccount, and make sure the 'store value' option is unchecked. This way, the custom field will always reflect the current parent account, and you can include this custom field in your saved search. 3. Formula Field: Some users have suggested using a formula field in the saved search with the following formula:

TRIM(REGEXP_SUBSTR({accountgrouped}, '[^:]+'))

. However, this formula seems to work for transaction searches and not for account searches. Also, it may not work correctly if an account name contains a colon or if there is a 3+ level hierarchy. Please note that these are workarounds and may not work in all scenarios or may not provide the exact results you are looking for.