Why can't I pull the cogs account of an inventory item on a saved search?

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. ****** The inability to pull the COGS (Cost of Goods Sold) account of an inventory item on a saved search in NetSuite is due to the limitations of the system. NetSuite's saved search functionality does not support joining the account table into the item table, which is why you're unable to get the full account name or number in your search results. When you're doing a saved search on existing Inventory Items and pulling out your Income Account, Expense Account, etc., it doesn't give you the full account name because the saved search is only able to display the account type (e.g., Inventory, Revenue-Sales) instead of the actual account name or number. As a workaround, you could use the account internal ID instead of the text representation. However, this might not be feasible if you're doing this across different NetSuite accounts and the internal IDs are different. Please note that there is an existing enhancement request (Enhancement 75028) that has been logged to make the account number with the account name available in an Item Saved Search. However, this enhancement has been pending for several years and it's unclear when or if it will be implemented.