Enhancements to Number Format Settings in NetSuite 2023.2

Starting in NetSuite 2023.2, the platform introduces notable enhancements to number format settings to streamline customization and improve user experience.

Enhancements Overview

The most significant change involves the removal of the Override box from the Format window. Users can now define their number format settings directly without the previous constraints. This makes it easier to customize how numeric values are presented throughout the system, allowing for clearer data representation.

Implications for Users

With this update, administrators will find it more straightforward to set consistent number formats across various records and transactions. This enhancement is particularly beneficial for organizations that manage multi-currency transactions or have specific formatting requirements in reporting.

Changes to SuiteAnalytics Connect and SOAP Web Services

In addition to number format settings, another important update affects SuiteAnalytics Connect and SOAP web services:

• The parent field of the AccountingPeriod record type is no longer universally available. It can only be accessed if the Multiple Calendars feature is disabled.
• If the Multiple Calendars feature is enabled, users must now leverage the parent field of the AccountingPeriodFiscalCalendars record type.

Action Required

Users who utilize SuiteAnalytics Connect or SOAP web services should review their existing queries and requests to ensure compatibility with this change. Failing to adjust your Connect queries before upgrading to 2023.2 may disrupt service access.

HTML Code Restrictions in Saved Searches

To bolster security, NetSuite now restricts the use of HTML code within Formula (Text) fields in saved searches. Searches with HTML code will display results as plain text only.

• Users should transition to using the new Formula (HTML) field instead, which offers similar capabilities but with better adherence to security practices.
• Access to this field is governed by a permission setting: "Create HTML Formulas in Search."

Recommendation

It’s essential for users to update any saved searches employing HTML in Formula (Text) fields to avoid potential issues in results display.

Who This Affects

• Administrators: Responsible for configuring number formats and managing saved searches.
• Developers: Need to adjust API queries and web services in line with the new guidelines.
• Accountants: May be impacted by changes in how financial periods are accessed and reported.

Key Takeaways

• Number format settings are now directly editable without the Override box.
• Changes to AccountingPeriod record types affect SuiteAnalytics Connect and SOAP users.
• HTML code is no longer supported in saved search Formula (Text) fields.
• Users should replace Formula (Text) fields with the new Formula (HTML) field to maintain functionality.
• Review queries and permissions to ensure smooth transition post-upgrade to NetSuite 2023.2.