01
About this report
One row per active month, quarter, year and adjustment period that ends on or after 1 January two years ago. Each row gives the start and end dates, whether the period is closed, and whether AR, AP and all transactions are locked.
Before a close, filter Period type to Month and look for open months earlier than the current one.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Period | Period type | Start | End | Closed | AR locked | AP locked | All locked |
|---|---|---|---|---|---|---|---|
| Jul 2026 | Month | 2026-07-01 | 2026-07-31 | Yes | Yes | Yes | Yes |
| Aug 2026 | Month | 2026-08-01 | 2026-08-31 | No | Yes | Yes | No |
| Sep 2026 | Month | 2026-09-01 | 2026-09-30 | No | No | No | No |
| Q3 2026 | Quarter | 2026-07-01 | 2026-09-30 | No | No | No | No |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT p.periodname AS period_name,
CASE WHEN p.isyear = 'T' THEN 'Year' WHEN p.isquarter = 'T' THEN 'Quarter'
WHEN p.isadjust = 'T' THEN 'Adjustment' ELSE 'Month' END AS period_type,
TO_CHAR(p.startdate, 'YYYY-MM-DD') AS start_date,
TO_CHAR(p.enddate, 'YYYY-MM-DD') AS end_date,
p.closed AS closed,
p.arlocked AS ar_locked,
p.aplocked AS ap_locked,
p.alllocked AS all_locked
FROM accountingperiod p
WHERE p.isinactive = 'F'
AND p.enddate >= ADD_MONTHS(TRUNC(SYSDATE, 'YYYY'), -24)
ORDER BY p.startdate, CASE WHEN p.isyear = 'T' THEN 1 WHEN p.isquarter = 'T' THEN 2 ELSE 3 END