Clean up involves some or all of the following steps:
- Identify and remove unused customizations (searches, records, fields, scripts):
- Completely unused
- Useless or inefficient
- Identify and fix improperly set-up customizations (eg fields with generic script ids, fields with no help).
- Describe each object (search, field, script,workflow).
- Assign true and meaningful owners.
- Assign customizations to high-level processes.
- Optimize scripts, workflows and processes.
Clean Up Tools
Strongpoint has a series of built in Clean Up Tools to enable Administrators to clean up their NetSuite account in an organized and efficient manner. There are many types of clean up, but they generally follow the same process:
- Select the approach and tools
- Analyze the results
- Organize the results
- Create Change Request (if required)
- Manage the change or clean up as appropriate
|Note: Always check the Last Date Spidered on any object and re-spider that object if necessary to ensure the information about that object is up to date.|
Step 1: Select the Approach and Tools
There are many clean up and documentation tools available such as:
- Unused Fields
- Unused Fields by Form
- Unused Searches
- Unused Scripts
- Unused Workflows
- Unused Bundles (New)
Notes about Unused Tools
Unused fields and unused fields by form do not include fields that do not store a value since there is no Date Last Used for those objects.
All the “Unused” tools with the exception of Unused Bundles do not include customizations from bundles. For example, even if a field is not used, it is highly unlikely that you will delete a field from a bundle. You would likely want to analyze the bundle usage as a whole when cleaning up.
Customizations that do not follow Best Practices
- Customizations with Default ScriptID
- Customizations with No Help
- Customizations with No Active Owner
- Customizations with No Descriptions
The tools can be accessed from the Strongpoint tab under Clean Up or from the Overview.
It is often a good idea to delete unused customizations that are highly likely safe to delete, such as fields that have not been used in years, that are not used by any other customization, before moving onto other clean up activities.
Step 2: Analyze the Results
Most of the tools have the following columns. They might be in slightly different orders or omitted based on the type of clean up.
- Edit/View: enables you to edit or view the Customization Record for that customization.
- Name: the name of the customization.
- Type: type of customization if showing multiple types.
- Parent: the parent of the customization if applicable.
- Clean Up Classification: The clean up status.
- Process/Steps: processes or steps linked to the customization.
- Quick Add Process: enables you to link the customization to a process through direct list editing. Multiple customizations can be added to processes in bulk.
Other columns may include:
- Owner: owner of that customization. If the owner is “Default Strongpoint User,” this means that the owner is no longer active in the NetSuite account, so could not be linked to that customization.
- Link: takes you to the actual customization.
- ScriptID: shows you the Script ID.
- Description: the customization description.
The next three items are critical for understanding what impact changes to the customization may have throughout the system. Being able to quickly and holistically see the impacted customizations greatly reduces the risk of things breaking as a result of your changes.
- Scripts: displays the scripts that use that customization.
- Searches/Mass Updates: displays the searches/ mass updates that use that customization.
- Workflows: displays the workflows that use that customization.
Change Requests can be created and managed through:
- Create Change Request: enables you to create a new change request with a link to the customization or customization selected.
- Related Change Requests: displays the change requests that the customization is linked to.
Step 3: Organize the Results
The results can be sorted and filtered and are required to group and manage the output for subsequent steps. You may chose to clean up based on process or record type.
Every Customization record has a Clean-Up Status field that enables us to track the status of the clean-up process for that object.
The statuses are:
- To Be Cleaned Up: We are planning to clean this up, but aren’t doing so yet.
- Send Request Info Emails: This status triggers an email warning that the customization is about to be deleted.
- Under Investigation: A holdings status when we are deciding what to do.
- Disabled/Hidden:Tracks that the customization has been disabled.
- Archive: Tracks that the data / set-up was archived.
- Deleted: Tracks that the customization has been deleted. The doc will be inactivated.
- Ignore: Removes it from the searches.
- Specific tasks: Fix Script Id and Reassign Owner.
You can report on these statuses to organize your work.
Step 4: Create Change Requests (if required)
Some changes such as deletion, changes to scriptID and Help impact the customization itself. For these types of changes we recommend creating a Change Request.
However, for Clean Up, you can create new change requests and assign them to the customizations. In the results view, “Create Change Request” creates a new change request. Once that is added to that customization it will appear under “Related Change Requests”. You can have multiple customizations assigned to multiple change requests as appropriate.
Step 5: Manage the Change or Clean Up as Appropriate
You can find more information about how to use the Change Request under Change Management. Once the appropriate investigations are conducted and approvals are obtained the customization can be changed as appropriate based on company policies and procedures.
Some of the items being changed, such as the description or owner, can be direct list edited or bulk edited like any other NetSuite data directly in a Strongpoint view such as Unused Fields.
The Change Request has archiving and deletion tools to help clean up the account. To find out more about deleting unused customization by following this link.
Step 6: Re-Spider
At the end of the process of updating the customization record, the account should be re-spidered to update the Customization Records that document the customizations that were changed. It can be re-spidered just for a particular record type that is all that was changed.