I have created a saved search to check item stock availability. When a user enters an item name, the search displays stock details across different locations, including Quantity On Hand, Quantity Available, Quantity Committed, Quantity Backordered, and Quantity Incoming.
I would like to know if there is any standard option or customization available in NetSuite where:
- Clicking on the Committed Quantity opens the list of related committed transactions (such as Sales Orders), and
- Clicking on the Backordered Quantity opens the related backorder transactions.
Has anyone implemented similar drill-down functionality, or can this be achieved using saved searches, SuiteScript, or other NetSuite features?
Any guidance or best practices would be appreciated.