how can i join to the item location configuration from an item in netsuite. on a saved search or on a suite analytics workbook? is there any native way, or can i add a custom field somewhere

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that you can't directly join the "Advanced Item Location Configuration" on an item saved search. However, you can use SuiteAnalytics Workbook for this purpose as it allows unlimited joins. If you need to use a saved search, you might have to create a custom record and sublist it on the item records, then duplicate the relevant information from the "Advanced Item Location Configuration". Another approach is to enable the "Advanced Item Location Configuration" feature which allows you to create the field you want using "Other Record Types". However, this feature moves quite a few fields around which might impact some of your searches. Unfortunately, it seems that NetSuite did not create a link in the item type saved search to those custom fields. To emulate the behavior, you might need to make your own subrecord for each location, link them to that location, and hope to make it work by joining up or down in the saved search that you create to display the data from it. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******