Validation Rules for Fixed Assets Custom Reports in NetSuite

Starting in NetSuite 2023.2, enhancements were made to the report customization process for Fixed Assets, which streamline validation when selecting fields in custom report templates. This update introduces a validation rule that ensures only custom fields with the Store Value option enabled can be selected in the Source Field.

Changes in Field Selection

When creating or modifying a custom report for Fixed Assets, users will receive an alert message if they attempt to save a report including any fields that are not linked with the Store Value setting. This helps in maintaining the integrity of the reports and ensures that only valid data sources are utilized.

Exceptions to Validation

It's important to note that even if the Store Value box is unchecked, certain fields sourced by SuiteApps for report generation remain usable. For instance, the Currency field within the Fixed Asset Management (FAM) Asset and Alternate Depreciation record is not subject to this validation, allowing flexibility in report design while adhering to the new rules.

Best Practices

• Field Setup: Ensure custom fields related to Fixed Assets have the Store Value option checked to avoid validation alerts during report customization.
• Review Existing Reports: Audit current custom reports to verify compliance with the new validation rules to prevent disruptions when saving changes.
• Training: Educate users involved in reporting on these updates for better adherence to the new processes and to minimize errors.

Who This Affects

This feature primarily impacts:

• Administrators: Responsible for setting up and maintaining custom report templates.
• Developers: Engaged in report design and customization workflows.
• Accountants & Financial Analysts: Users who generate and utilize fixed asset reports for decision-making.

Key Takeaways

• Introduction of validation for custom report templates in Fixed Assets.
• Alerts inform users of non-compliant field selections during customization.
• Store Value requirement enhances report accuracy and integrity.
• Exceptions exist for certain fields, like Currency, that can still be used regardless of Store Value setting.
• Applies to NetSuite version 2023.2 and may affect report-generation processes and user training.