This notice applies to customers who use SuiteAnalytics Connect or SOAP web services. An upcoming change to existing fields may affect your queries. You should check your existing queries and requests, and make any adjustments as needed. This change is targeted to occur after your account is upgraded to NetSuite 2023.2.
Note: If you use SuiteAnalytics Connect, this change applies only to the schema available through the NetSuite2.com data source.
What is Changing?
Currently in SuiteAnalytics Connect and SOAP web services, you can use the parent field of the AccountingPeriod record type in your queries and requests. After your account is upgraded to 2023.2, the parent field of the AccountingPeriod record type will be available only if the Multiple Calendars feature is disabled. If the Multiple Calendars feature is enabled, you should use the parent field of the AccountingPeriodFiscalCalendars record type instead.
If you do not change your queries and requests before the change, they may stop working.
Required Actions
You should check your existing Connect queries and SOAP web services requests, and make any required updates before your account is upgraded to 2023.2.
The following samples illustrate what your Connect queries and SOAP web services requests and responses should look like after this change occurs.
Sample SuiteAnalytics Connect Query
SELECT
AccountingPeriod.*,
PeriodFiscalCalendars.Parent
FROM PeriodFiscalCalendars, AccountingPeriod, FiscalCalendar
WHERE FiscalCalendar = FiscalCalendar.id
AND FiscalCalendar.isDefault = 'T'
AND PeriodFiscalCalendars.AccountingPeriod = AccountingPeriod.id
ORDER BY StartDate, endDate DESC
Sample SOAP Web Services Request
</soap:Header>
<soap:Body>
<platformMsgs:get>
<platformMsgs:baseRef xsi:type="platformCore:RecordRef"
internalId="3" type="accountingPeriod" />
</platformMsgs:get>
</soap:Body>
</soap:Envelope>
Sample SOAP Web Services Response with the Multiple Calendars Feature Disabled
<soapenv:Body>
<getResponse xmlns="urn:messages_2022_2.platform.webservices.netsuite.com">
<readResponse>
<platformCore:status isSuccess="true" xmlns:platformCore="urn:core_2022_2.platform.webservices.netsuite.com"/>
<record internalId="3" xsi:type="listAcct:AccountingPeriod" xmlns:listAcct="urn:accounting_2022_2.lists.webservices.netsuite.com">
<listAcct:periodName>Jan 2014</listAcct:periodName>
<listAcct:parent internalId="2" xmlns:platformCore="urn:core_2022_2.platform.webservices.netsuite.com">
<platformCore:name>Q1 2014</platformCore:name>
</listAcct:parent>
...
</record>
</readResponse>
</getResponse>
</soapenv:Body>
Sample SOAP Response with the Multiple Calendars Feature Enabled
<soapenv:Body>
<getResponse xmlns="urn:messages_2022_2.platform.webservices.netsuite.com">
<readResponse>
<platformCore:status isSuccess="true" xmlns:platformCore="urn:core_2022_2.platform.webservices.netsuite.com"/>
<record internalId="3" xsi:type="listAcct:AccountingPeriod" xmlns:listAcct="urn:accounting_2022_2.lists.webservices.netsuite.com">
<listAcct:periodName>Jan 2014</listAcct:periodName>
...
<listAcct:fiscalCalendarsList>
<listAcct:accountingPeriodFiscalCalendars>
<listAcct:fiscalCalendar internalId="1" xmlns:platformCore="urn:core_2022_2.platform.webservices.netsuite.com">
<platformCore:name>Standard Fiscal Calendar</platformCore:name>
</listAcct:fiscalCalendar>
<listAcct:parent internalId="2" xmlns:platformCore="urn:core_2022_2.platform.webservices.netsuite.com">
<platformCore:name>Q1 2014</platformCore:name>
</listAcct:parent>
</listAcct:accountingPeriodFiscalCalendars>
</listAcct:fiscalCalendarsList>
...
</record>
</readResponse>
</getResponse>
</soapenv:Body>
For more information about the record types and fields available in the NetSuite2.com data source for SuiteAnalytics Connect, see Finding Record Type and Field Names (SuiteAnswers ID 87442).
For more information about the records, sublists, and other objects available in SOAP web services, see SuiteTalk SOAP Schema Browser (SuiteAnswers ID 74612).
If you require assistance or more information, please contact NetSuite Customer Support.