Is there a way to JOIN

accountingperiod

records to fiscal calendars? In querying the

fiscalcalendar

table, I see two values

[{'links': [],
  'fiscalmonth': 'JAN',
  'id': '2',
  'isdefault': 'F',
  'name': 'January Fiscal Calendar'},
 {'links': [],
  'fiscalmonth': 'MAR',
  'id': '1',
  'isdefault': 'T',
  'name': 'March Fiscal Calendar'}]

But the

accountingperiod

records do not seem to have a field to join to fiscalcalendar. As a consequence, I cannot determine which accountingperiods are the correct ones (i.e. belong to the default fiscal year). Has anyone run into this?

There is a

accountingPeriodFiscalCalendars

table

Do you know what permission I would need to access that? I'm getting "Search error occurred: Record 'accountingPeriodFiscalCalendars' was not found" when I run

SELECT * FROM accountingPeriodFiscalCalendars

Do you have

Fiscal Calendars

?

Hmm. I'm going to Roles > Searches > Fiscal Calendar to add the permission. Adding it seems to work fine, but when I return to the role record the permission does not appear 😕

You should be adding under Permissions > Lists.

It does not seem to be an option under Lists

Hmm do you have Multiple Calendars feature enabled?

Ah I think that's the issue. I am missing the permission in a client account, but the account I test with does not have that feature.

There is a

CompanyFeatureSetup

table

Thank you for the help!

There's also an "IsAvailable" column on the CompanyFeatureSetup table, which indicates if a given feature is even available. There's a query and list of a bunch of features here: https://timdietrich.me/blog/netsuite-suiteql-company-features/