get the custom filed data in saved search from inventory number if it match with inventory details batch number using filter or formula

AI generated answer (using internal Slack threads):

To get the custom field data in a saved search from the inventory number that matches with the inventory details batch number using a filter or formula, you can use SuiteQL or a saved search in NetSuite. Here's how you can do it: 1. Using SuiteQL: SuiteQL allows you to query your NetSuite data using SQL-like syntax. You can use a SELECT statement to retrieve the custom field from the Inventory Number record. However, custom fields are not directly accessible in SuiteQL. You need to join the custom record with the Inventory Number record using the internal ID of the custom field. Unfortunately, the exact SQL query would depend on your specific custom field and database schema. 2. Using Saved Search: You can create a saved search on the Inventory Number record. In the criteria tab, you can add a filter to match the inventory number with the batch number. In the results tab, you can add the custom field to the list of fields to display. If the custom field is not directly available, you can use a formula field. For example, if you want to display the committed quantity, you can use a formula like

{quantityonhand}-{quantityavailable}

. Please note that the exact steps and formulas may vary depending on your specific NetSuite setup and the custom field you want to retrieve. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******