Applies to: NetSuite OneWorld accounts that use multiple fiscal calendars
ExtendInsights Financial Reporting requires access to the appropriate fiscal calendar when calculating results with XAVI formulas.
When users connect through a non-administrator role, a NetSuite administrator must:
Enable the Multiple Calendars feature.
Grant the role the Fiscal Calendars permission with View access.
Symptoms / Error Message
If Multiple Calendars is not enabled or the connected role does not have the required permission:
XAVI formulas do not return results.
An error notification appears in ExtendInsights.
Users may see one of the following messages:
An internal error occurred.
Your connection lacks the required permission, or this feature is not enabled. Contact your NetSuite administrator.
The Fiscal Calendars permission does not appear when configuring the role.
Why This Happens
NetSuite makes the Fiscal Calendars permission available only when the Multiple Calendars feature is enabled.
Enabling the feature does not automatically grant the permission to non-administrator roles. A NetSuite administrator must add it to the role used for the ExtendInsights connection.
How to Resolve the Issue
The following steps must be completed by a NetSuite administrator.
Step 1: Enable Multiple Calendars
In NetSuite, go to Setup > Company > Enable Features.
Select the Accounting subtab.
Under Advanced Features, select Multiple Calendars.
Click Save.
Step 2: Grant the Fiscal Calendars Permission
Go to Setup > Users/Roles > Manage Roles.
Locate the role used to connect ExtendInsights and click Edit.
Select the Permissions subtab.
Select the Lists subtab.
In the Permission dropdown, select Fiscal Calendars.
Set the access level to View.
Click Add.
Click Save.
If Fiscal Calendars is not available in the permission dropdown, confirm that the Multiple Calendars feature was enabled and saved successfully.
Verification
After completing the NetSuite configuration:
Return to Excel.
Open ExtendInsights.
Reconnect using the updated NetSuite role.
Refresh the report or recalculate the XAVI formulas.
The formulas should return financial data without displaying the feature or permission error.
Best Practices
This configuration applies to NetSuite OneWorld accounts that use multiple fiscal calendars.
The exact NetSuite permission name is Fiscal Calendars.
The permission is located under Permissions > Lists on the role record.
View access is sufficient for ExtendInsights Financial Reporting.
Make sure you update the same role the user selected for their ExtendInsights connection.
đŹ Need Help?
If the error continues after enabling Multiple Calendars and updating the role, contact CloudExtend Support at cloudextend-support@celigo.com.
Include:
The complete error message
The affected NetSuite account ID
The name of the role used for the ExtendInsights connection