Vedachalam Mahadevan
02/23/2025, 8:55 AMCeligo AI
02/23/2025, 8:55 AMAI generated answer (using internal Slack threads):To get only one timebill submitted for a day in a Saved Search, you can use the 'Group' feature in NetSuite's Saved Search. Here are the steps: 1. Go to the 'Results' tab in your Saved Search. 2. In the 'Summary Type' column, select 'Group' for the fields you want to group by. In your case, you would want to group by the 'Date' field and the 'Employee' field (or whatever field represents who is submitting the timebill). 3. In the 'Summary Type' column, select 'Count' for the 'Timebill' field. This will give you the number of timebills submitted for each group. 4. In the 'Criteria' tab, add a new criteria where 'Count' is equal to 1. This will filter out any groups where more than one timebill was submitted. This will give you a list of all dates and employees where only one timebill was submitted. If you want to see the details of the timebill, you can add the relevant fields to the 'Results' tab and set their 'Summary Type' to 'Minimum' or 'Maximum'. This will give you the details of one of the timebills in each group (since there is only one timebill in each group, it doesn't matter whether you choose 'Minimum' or 'Maximum'). ****** 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
02/23/2025, 8:55 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.794532418
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.791111
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.79070425
Celigo AI
02/23/2025, 8:55 AM