ANS-1852 · CUSTOM FIELDS, RECORDS & FORMS
How to Restrict Entity Selection to Employees in NetSuite Journal Entries?
Learn how to implement a custom solution in NetSuite to ensure only employee records can be selected in the Name field of Journal Entry lines.
Short answer
To restrict entity selection in NetSuite Journal Entries to employees, a custom column field should be created to list only employees. Users will select employee names in this custom field. A script will then disable the standard Name field and copy the selected employee value from the custom field upon line addition or Journal Entry save.
Scenario
NetSuite users may require the ability to restrict the entities selectable in the 'Name' field on Journal Entry lines. This is often necessary to enforce specific accounting policies, such as ensuring that only employee records are linked to certain journal transactions, preventing the selection of vendors or customers in inappropriate contexts.
Solution
The solution involves implementing a customization within NetSuite to control the entity selection process. This approach ensures that only employee records are available for selection in the designated field.
Create a custom column field on the Journal Entry form. Configure this field to list and allow selection of only employee records.
Instruct users to utilize this new custom field for selecting employee names.
Develop a script that performs two key actions: disable the standard 'Name' field and copy the value from this custom field on add of line OR save of JE.
Expert NetSuite Support
Need help with this NetSuite issue?
Custom Fields, Records & Forms consulting and configuration support