SuiteQL Accounting Period Queries: Fiscal Years and Posting Periods
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 Filtering: Current Month, Previous Month and Date Ranges
Filter SuiteQL records by the current month, previous month or a custom date range without losing rows at time boundaries.