This query is returning a syntax error

SELECT TOP 10
    TRANSACTION.ID
FROM 
    TRANSACTION
WHERE
    TRANSACTION.postingperiod IN BUILTIN.PERIOD('LFY', 'START', 'NOT_LAST', '>=')

AI generated answer (using internal Slack threads):

The query you provided is returning a syntax error because the

BUILTIN.PERIOD

function is not used correctly. The

BUILTIN.PERIOD

function is not a valid function in SuiteScript or SuiteQL. If you are trying to filter transactions based on a specific posting period, you should use the

postingperiod

field in your WHERE clause. However, the

postingperiod

field is a text field that contains the name of the posting period, not a date. If you want to filter transactions based on a date range, you should use the

trandate

field, which is a date field. Here is an example:

sql
SELECT TOP 10
    TRANSACTION.ID
FROM 
    TRANSACTION
WHERE
    TRANSACTION.trandate >= '2021-01-01' AND TRANSACTION.trandate <= '2021-12-31'

This query will return the top 10 transactions that were posted between January 1, 2021, and December 31, 2021. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******