Removal of the PeriodFiscalCalendars Table from SuiteAnalytics Connect
As of 2026.1, the PeriodFiscalCalendars table is no longer available in SuiteAnalytics Connect.
After your NetSuite account is upgraded to 2026.1, queries, reports, or integrations that reference the PeriodFiscalCalendars table won't work.
The functionality previously provided by the PeriodFiscalCalendars table is now available through the following tables:
-
AccountingPeriodFiscalCalendars, which provides fiscal calendar data for accounting periods -
TaxPeriodFiscalCalendars, which provides fiscal calendar data for tax periods
In most cases, you should use one of these tables depending on your use case. These tables represent separate functional areas and aren't typically used together.
If you need to combine both accounting and tax period data for existing integrations, you can use the following as part of your query:
SELECT * FROM AccountingPeriodFiscalCalendars
UNION
SELECT * FROM TaxPeriodFiscalCalendars
Required Actions
Update any queries, reports, or integrations that reference the PeriodFiscalCalendars table to use appropriate replacement table.
Review existing integrations to ensure they no longer depend on the PeriodFiscalCalendars table and validate that queries continue to work after upgrading to 2026.1.
For more information about working with SuiteAnalytics connect data, see SuiteAnalytics Connect.