Slackbot
11/09/2024, 11:05 PMCeligo AI
11/09/2024, 11:06 PMAI generated answer (using internal Slack threads):Based on the conversations, it seems you want to create an inventory aging report using a saved search in NetSuite. Here's a general approach to achieve this: 1. Create a new saved search for inventory items. 2. In the criteria section, you can add the item fields you want to filter on. For example, you can add 'Quantity Available' and set it to greater than 0 to only include items that are currently in stock. 3. In the results section, you can add the fields you want to display in your report. For example, you can add 'Item', 'Quantity Available', and 'Last Purchase Date'. 4. To calculate the age of the items, you can use a formula field. For example, you can use the formula
TO_DAYS({today}-{lastpurchasedate})
to calculate the number of days since the item was last purchased.
5. To categorize the items based on their age, you can use a case statement in your formula. For example, you can use the formula CASE WHEN TO_DAYS({today}-{lastpurchasedate}) <= 30 THEN 'Less than 30 days' WHEN TO_DAYS({today}-{lastpurchasedate}) BETWEEN 31 AND 60 THEN '31 to 60 days' ELSE 'Greater than 60 days' END
.
Please note that this is a general approach and you might need to adjust it based on your specific requirements and the actual fields available in your NetSuite account.
******
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
11/09/2024, 11:06 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.852150738
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.843258142
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841788769
Celigo AI
11/09/2024, 11:06 PM