This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

i want to create formula for item opening balance quantity using saved search

&gt;*AI generated answer (using internal Slack threads):*
To create a formula for item opening balance quantity using a saved search, you can create a Transaction Saved Search. Here are the steps:

1. In the Criteria, add 'Posting' = True.
2. Add a Formula (Numeric) field. For the formula, enter: `case when {account.number} = '(insert your item asset account)' then 1 else 0 end`.
3. Add 'Date' to your Available Filters.
4. In the Results, add 'Item' (Group) and 'Quantity' (Sum).

This will show the on-hand running balance for items at all locations. 

Please note that this formula might need to be adjusted based on your specific needs, such as accommodating for different locations and transaction types.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C29J1BPM3/p1614026863013500|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.880181432

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1604066974135500|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.845010757

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1690326010143719|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.841804743



Please provide your feedback on this answer.