This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Write me a line of SQL on a saved search which sums the transactions between Jan 1st 2023 and Dec 31st 2023

&gt;*AI generated answer (using internal Slack threads):*
Based on the conversations, you can create a saved search in NetSuite to sum the transactions between Jan 1st 2023 and Dec 31st 2023 using SQL. Here is a line of SQL that you can use:

```sql
SELECT SUM({transaction.amount}) 
WHERE {transaction.trandate} BETWEEN '2023-01-01' AND '2023-12-31'
```

This SQL statement will sum the transaction amounts where the transaction date is between Jan 1st 2023 and Dec 31st 2023.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1490195732525271|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.838695

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1702411776494909|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.829921365

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C29HKGM6J/p1485821614000604|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.826409101



Please provide your feedback on this answer.