Imran Hasan
12/30/2024, 7:06 AMCeligo AI
12/30/2024, 7:07 AMAI generated answer (using internal Slack threads):Based on the conversations, it seems that you are looking to create a saved search in NetSuite that shows only the items whose purchase price and last purchase price are equal. Here's a general approach to achieve this: 1. Create a new Item saved search. 2. In the Criteria subtab, add the necessary filters to narrow down the items you are interested in. 3. In the Results subtab, add the fields 'Purchase Price' and 'Last Purchase Price'. 4. Add a Formula (Numeric) field in the Results subtab with the formula
CASE WHEN {purchaseprice} = {lastpurchaseprice} THEN 1 ELSE 0 END
. This formula will return 1 if the purchase price and last purchase price are equal, and 0 otherwise.
5. In the Summary subtab, add a filter on the Formula (Numeric) field to only show the rows where the formula result is 1.
Please note that this is a general approach and might need to be adjusted based on your specific requirements and the actual field names 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
12/30/2024, 7:07 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.810814798
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.788506925
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.787868619
Celigo AI
12/30/2024, 7:07 AM