SuiteQL Accounting Period and Fiscal Year Queries
Query NetSuite accounting periods with SuiteQL and avoid confusing transaction dates, posting periods and fiscal calendars.
Reporting
3 notes in this thread.
SuiteQL GROUP BY Month, Quarter and Year
Group SuiteQL results by calendar month, quarter or year while keeping the output correctly sorted across multiple years.
SuiteQL Date Filters: Current and Previous Month
Filter SuiteQL records by the current month, previous month or a custom date range without losing rows at time boundaries.