i want formula get the opening balance in the saves search

AI generated answer (using internal Slack threads):

To get the opening balance in a saved search, you can use a formula in a Transaction Saved Search. However, the exact formula will depend on the specific requirements of your search. Here is a general approach: 1. Create a Transaction Saved Search. 2. In the Criteria, add 'Posting' = True. 3. Add a Formula (Numeric) field. For the formula, you might use something like:

case when {account.number} = '(insert your item asset account)' then 1 else 0 end

. This formula will depend on your specific needs. 4. Add 'Date' to your Available Filters. 5. In the Results, add 'Item' (Group) and 'Quantity' (Sum). This will show the on hand running balance for items at all locations. For a more complex scenario, you might need to accommodate for locations and different transaction types. In such cases, you might find this blog post helpful: https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/ Please note that this is a general approach and might need to be adjusted based on your specific needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******