Incomplete Information? Respectfully Decline Mandatory Fields

This article is relevant if you are customizing NetSuite and you seek better data entry practices but mandatory fields are too invasive.

The Mandatory Field Dilemma

When I work with executives to help them design business practices, often we will get into conversations which organize around data entry screens.  A data entry screen usually does a good job illustrating the business problem we want to solve or the coordination practice we seek to design.

Many times, when an executive sees the power of NetSuite, and because they want data, they will quickly want to make many fields mandatory.  While mandatory fields are easy to activate to ensure you force users to provide information, there are situations when information may not be at hand.

Some organizations have long-lead to fulfillment cycle times.  For example, a long lead cycle often can develop in the sales and project setup within a full-service project professional services firm.

Example Project Business Field Challenges

In a service business that conducts projects for their customers, many times the work setup takes time to get information from  clients.  For example, let’s assume that we know we are going to produce a project for ABC Corp, but the following information, at this time, is not yet available:

  • We have not yet assigned a project manager.
  • We are not yet clear if the project will be sold as time and materials or fixed bid.
  • If the project is sold as fixed bid, the practice manager must provide an approval.
  • We are not clear the start date.
Assuming you are trying to manage the practice with many professionals, projects, and managers, it becomes very important to have good information in NetSuite to stay on top of all the action.   Yet, the information elements noted above are not yet known but they are relevant.

Use a Record Quality Control Feature

Instead of mandatory fields, use a mechanism that inspects a project record every time it is updated.   Build rules for what fields need to meet specific criteria.  The idea is that you can use a text field to automatically hold “clear language” that can be displayed on the project form and used in saved search / reports to drive better education of the desired business process.  Use NetSuite SuiteScript in a User Event to hold your special logic.

Generate a Saved Search which Notifies Users and Managers

With your new quality control feature in lieu of  mandatory fields, your records can now be saved with incomplete information.  Yet, you can stay on top of these records by using Saved Search.  For example, you can send out a daily email to users with specific  information about the quality control concern.  Further, if no action has been taken by a certain amount of days, you can use color coding to highlight the record staleness.  Finally, a practice manager can receive the same information organized in a fashion that allows them to manage the team.

If you have ideas on how you might implement such a feature and would like some help, contact us.

 

Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube

| Tags: , , , , , , | Category: Management, NetSuite | Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *