how to build saved search calculate the inventory opening balance

AI generated answer (using internal Slack threads):

To calculate the inventory opening balance using a saved search, you can create a Transaction Saved Search. Here are the steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction from the list. 3. In the Criteria subtab, add 'Posting' = True. This ensures that only posted transactions are included in the search. 4. Add a Formula (Numeric) field. For the formula, enter:

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

. Replace '(insert your item asset account)' with the actual account number of your inventory asset account. 5. Add 'Date' to your Available Filters. This allows you to filter the search results by date. 6. In the Results subtab, add 'Item' (Group) and 'Quantity' (Sum). This will group the results by item and sum the quantities of each item. This saved search will show the on hand running balance for items at all locations. To calculate the opening balance, you can filter the search results by a specific date. The sum of the quantities on that date will be the opening balance. Please note that this method assumes that all inventory transactions are posted to the same inventory asset account. If you have multiple inventory asset accounts, you may need to adjust the formula accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******