YASSER
01/27/2025, 8:13 AMCeligo AI
01/27/2025, 8:14 AMAI generated answer (using internal Slack threads):To calculate the historical opening balance for inventory using a saved search in NetSuite, you can create a Transaction Saved Search. Here are the steps: 1. Navigate to Reports > New Search > Item > click "Create Saved Search". 2. In the Criteria section, add 'Posting' = True. This ensures that only posted transactions are included in the search. 3. Add a Formula (Numeric) field. For the formula, enter:
case when {account.number} = '(insert your item asset account)' then 1 else 0 end
. This formula will return 1 for transactions related to your item asset account and 0 for all other transactions.
4. Add 'Date' to your Available Filters. This allows you to filter the search results by date.
5. In the Results section, add 'Item' (Group) and 'Quantity' (Sum). This will group the results by item and show the sum of the quantity for each item.
This saved search will show the on hand running balance for items at all locations. You can adjust the date filter to get the opening balance for a specific date.
Please note that this is a somewhat advanced operation. If you're not familiar with creating saved searches in NetSuite, you might want to consult with a NetSuite professional or partner for assistance.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
01/27/2025, 8:14 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818580747
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818568289
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.812799394
Celigo AI
01/27/2025, 8:14 AM