get the custom filed data in invoice 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 an invoice saved search from the inventory number, you would need to join the 'Inventory Detail' record with the 'Invoice' record in your saved search. Here's a general approach: 1. In your saved search, select 'Invoice' as the record type. 2. In the criteria tab, add a new criteria where 'Main Line' is 'F' (False). This will ensure that you are looking at line items and not the invoice header. 3. Still in the criteria tab, add a join to the 'Inventory Detail' record. The join field would be 'Inventory Detail' which is available under 'Item'. 4. In the results tab, add the fields you want to display. If you want to display the custom field from the 'Inventory Number' record, you would need to add a join to the 'Inventory Number' record. The join field would be 'Inventory Number' which is available under 'Inventory Detail'. Then, you can select your custom field. Please note that the exact field names and join paths might vary depending on your NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******