FAM Diagnostics Portlet: Data-Integrity Checks for Fixed Assets

What changed

A new FAM Diagnostics portlet can be added to the dashboard. It exposes seven automated integrity checks against the FAM bundle's internal records and provides scan, review, and fix actions without requiring direct database queries or custom scripts.

Available diagnostic checks

• Precompute Depreciation Values — Generates pre-computed depreciation schedule values that FAM uses to optimise the depreciation engine. Values are auto-generated for assets created via Asset Proposals but not for assets created manually or through CSV import. Running this check fills the gap.
• Reset Asset Values — Detects when changes to asset life, cost, or other formula inputs have made existing depreciation history stale. Triggers an Asset Reset to delete outdated depreciation histories so they can be regenerated.
• Check Missing Summaries — Looks for depreciation histories that lack a corresponding BG Summary record (keyed on subsidiary + department + class + location + currency). Depreciation will not proceed without this record.
• Check Missing Asset Values Record — Finds assets that have no linked Asset Values record. Common causes: CSV import performed while server-side SuiteScripts were not running, manual removal of the Asset Values record, or direct deletion of the record.
• Check Missing Lease Contracts — Identifies lease payments without an associated contract record, typically caused by CSV import while server scripts are disabled.
• Check Missing DHRs without Associated Records — Finds orphaned Depreciation History Records (DHRs) that are no longer linked to an Asset or Asset Values record. Orphans arise when users manually delete the parent record or modify the DHR outside of FAM transactions.
• Check Duplicate DHRs — Detects duplicate DHRs created when prior forecast DHRs are not cleared before new ones are generated (usually due to a failed FAM process). Only identifies duplicates without journal entries, so they are safe to review and delete.
• Check Stale DHRs — Flags forecast DHRs that no longer match the related Asset Value record or the current depreciation date. A DHR is stale when:
  • Its date is later than the Asset Value's Last Forecast Date.
  • The Asset Value has no Last Forecast Date at all.
  • The DHR is linked to a BG Summary that already has a journal entry and its date exceeds the Asset Value's Last Depreciation Date.
  Only stale DHRs without journal entries are surfaced.

Permissions

The portlet is visible by default to the Administrator and Fixed Assets Manager roles. Any other role requires the FAM Recent Diagnosis permission (configured under Form Permissions for Fixed Assets Management).

Why this matters

Before this portlet, diagnosing FAM data corruption—orphaned DHRs, missing summaries, stale forecasts—required custom saved searches or direct SQL via SuiteAnalytics Connect. These issues commonly surface after bulk CSV imports run with server scripts disabled, or when users manually delete asset-related records outside the FAM UI. Left unchecked, they silently block depreciation runs or produce incorrect depreciation amounts.

What to do

1. Add the portlet — Navigate to your dashboard, click Personalize, and add the FAM Diagnostics portlet.
2. Run a full scan — Use the portlet's scan action to check all seven diagnostic categories. Review the results for any flagged records.
3. Fix issues via the Review Assistant — The portlet links to the Review Assistant for deleting orphaned, duplicate, and stale DHRs. Use it rather than scripting bulk deletes.
4. Grant access to non-default roles — If FAM administrators or accountants use custom roles, assign the FAM Recent Diagnosis permission so they can view and act on diagnostics.
5. Review CSV import workflows — Several checks exist specifically because CSV imports bypass server-side SuiteScripts. If you bulk-import assets or lease payments, schedule a diagnostic scan immediately after import or ensure server scripts are enabled during the import.
6. Schedule recurring scans — Consider using the scheduling feature (see Scheduling a Diagnostic Scan in the help center) to run diagnostics on a regular cadence, especially in environments with high asset volume or frequent CSV imports.

Note: The source documentation does not specify which NetSuite release introduced this feature. Verify availability in your account's release notes or the FAM bundle version history.