Enhancements to Number Format Settings in NetSuite 2023.2
NetSuite 2023.2 introduces improved number format settings for enhanced user customization and data management.
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
AccountingPeriodFiscalCalendarsrecord 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.
Frequently Asked Questions (4)
Does the removal of the Override box for number formats apply to both WMS and standard NetSuite?
What permissions are required to access the new Formula (HTML) field in saved searches?
What implications does the change to the AccountingPeriod record type have for existing SuiteAnalytics Connect queries?
Will the new number format settings affect existing workflows in NetSuite?
Was this article helpful?
More in Administration
- User License Management in NetSuite: Best Practices and Guidance
Manage user licenses in NetSuite effectively. Learn about license types, counting methods, and best practices for compliance.
- NetSuite 360 and New Roles in NetSuite 2025.2 Enhancements
Explore new features in NetSuite 2025.2, including NetSuite 360 and enhanced roles for better account management.
- Show Role Differences Feature for Permission Management
Show Role Differences feature in NetSuite allows efficient role permission comparisons, enhancing security and user access management.
- Sales Administrator Permissions and Features in NetSuite
Sales Administrator role provides complete access to vital sales and financial records, including commissions and reports.
Also from NetSuite 2023.2
- Vendor Credit Inbound Transaction Support in NetSuite 2023.2
NetSuite 2023.2 enhances order management with inbound vendor credit transaction support, streamlining processing.
- Make Copy Function in SuiteBilling for NetSuite 2023.2
The Make Copy function in SuiteBilling facilitates billing account creation, enhancing efficiency for NetSuite 2023.2 users.
- Bulk Assignment of Pick Tasks in NetSuite 2023.2
Enhance efficiency in inventory management with bulk assignment of pick tasks in NetSuite 2023.2.
- Fine and Interest Charges for Purchases in NetSuite 2023.2
NetSuite 2023.2 introduces fine and interest charges on purchases to enhance compliance management and financial record keeping.
Advertising
Reach Administration Professionals
Put your product in front of NetSuite experts who work with Administration every day.
Sponsor This Category