ANS-0073 · SAVED SEARCHES & FORMULAS
Why Does ‘Created From : Item’ Search Not Return Results in NetSuite?
NetSuite searches on the 'Created From : Item' field may fail to display expected results due to limitations in joining line-related data.
Short answer
NetSuite searches using the 'Created From : Item' criteria often fail to return results because the system is unable to perform joins on line-related data for this specific field. This limitation prevents the search from accurately linking items from the 'Created From' transaction to the current record.
Scenario
Users attempting to perform a search in NetSuite using the 'Created From : Item' criteria may observe that the search returns no results, even when relevant data is expected. This occurs despite the presence of transactions that should logically link through the 'Created From' field to specific items.
Solution
When a search is executed in NetSuite utilizing the Created From : Item criteria, the system is unable to return results. This behavior is attributed to NetSuite's inability to perform joins on anything line related when this specific field is used in a search.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support