<img src="https://ws.zoominfo.com/pixel/5BFMW73xT6Cu70sN1cUt" width="1" height="1" style="display: none;">

Inline Editing and Its Saved Search

Posted by Kevin Suh, NetSuite Administrator on Apr 4, 2023 9:02:12 AM
Kevin Suh, NetSuite Administrator
pexels-ono-kosuki-5648076

Inline editing is a great feature in Netsuite. Inline list editing enables you to update records quickly by changing data directly in a record's row on the list page. This capability supports faster and easier editing because you do not have to go into each record to edit it.

You can also edit multiple records simultaneously by using keyboard commands. Addresses cannot be edited on list pages using inline editing. Inline list editing is available when the Inline Editing feature is enabled. To enable the feature, go to Setup > Company > Enable Features. On the Company subtab in the Data Management section, check the Inline Editing box and click Save.

To use inline editing: 

      1. Use the Edit switch at the top of the page to turn on inline editing. When editing is off, the switch displays an x.


      2. When editing is on, the switch has a green check. 



      3. The list page refreshes to display an edit icon in each column header that contains editable fields. You can also identify editable fields by placing the cursor on them. A field is editable if the cursor turns into a hand when on the field. 
      4. Click the field where you want to enter or change information. 
      5. Click away from the field to save your changes. 
      6. The data is automatically saved on that record. 

However, you might have encountered the issue of using the inline editing on a list or saved search, even when the Inline Editing feature is enabled. I will quickly go over the behavior and the reasons. Also, I will provide the solution for those behaviors. 

      • The role of the user only has the View permission level for the permission related to the record type 
          • Solution
                1. Login as administrator 
                2. Navigate to Setup > Users/Roles > Manage Roles 
                3. Custom role: Click Edit 
                4. Click Permissions 
                5. Locate the permission related to the record type the user is trying to edit via Inline Editing 
                6. Level: Select Edit 
                7. Click Save 

        • The field is to be edited is hidden on the preferred form 
            • Solution
                1. Login as administrator Navigate to Customization > Forms > Entry Forms 
                2. Preferred form: Click Edit 
                3. Click Fields 
                4. Field: Show: Enter Checkmark 
                5. Click Save 

        • The preferred form's Enable Field Editing on Lists preference is disabled 
            • Solution
                1. Navigate to Customization > Forms > Transaction / Entry Forms 
                2. Preferred form: Click Edit 
                3. Enable Field Editing on Lists: Enter Checkmark 
                4. Click Save 

        • The Display Type of the field to be edited is set to Inline or Disabled 
            • Solution
                1. Navigate to Customization > Lists, Records, & Fields > Entity Fields 
                2. Field: Click Edit 
                3. Click Display 
                4. Display Type: Select Normal 
                5. Click Save and Apply to Forms 
                6. Select the form where to show the field 
                7. Click Save  

        • The field to be edited uses a formula 
            • Solution
                1. Navigate to Customization > Lists, Records, & Fields > Entity Fields 
                2. Field: Click Edit 
                3. Click the Sourcing & Filtering / Validation & Defaulting tabs 
                4. Check if there's anything selected in the Source List or Default fields 

        • The field to be edited is not applied to the record type 
            • Solution
                1. Create a custom Item field: 
                    1. Navigate to Customization > Lists, Records, & Fields > Item Fields 
                    2. Label: Enter label 
                    3. Store Value: Enter Checkmark 
                    4. Type: Select Free-Form Text 
                    5. Click Applies To 
                    6. Inventory: Enter Checkmark 
                    7. Non-inventory: Enter Checkmark 
                    8. Click Save and Apply to Forms 
                    9. Select Show for all forms that apply
                2. Enter a value for the custom field via Inline Editing: 
                    1. Navigate to Lists > Accounting > Items 
                    2. Click Customize View 
                    3. Click Available Filters 
                    4. Type:Show as Multi-Select: Enter Checkmark 
                    5. Click Save 
                    6. Filters:Type: Select Inventory Item, Non-inventory Item and Service Item 

        • The field to be edited is a Multiple Select field 
         
        • The role of the user has Restrict Time and Expenses preference enabled
           
        • The role of the user does not have the Find Transaction permission 
            • Solution
                1. Navigate to Setup > Users/Roles > Manage Roles 
                2. Custom role: Click Edit 
                3. Click Permissions 
                4. Click Transactions 
                5. Permission: Select Find Transactions 
                6. Level: Select Edit or Full 
                7. Click Save  

        • The user tries use inline editing on a transaction list or saved search that has multiple transaction types 
         
        • The user tries use inline editing on a transaction list or saved search with results that contain line item fields 
         
        • The user tries use inline editing on a transaction list or saved search that returns rows representing line items 
            • Solution
                1. Navigate to Lists > Search > Saved Searches 
                2. Saved Search: Click Edit 
                3. Click Criteria 
                4. Filter: Select Main Line 
                5. Main Line: Select Yes 

If you want to learn more about Inline Editing or need help with Saved Search, please contact Concentrus today to discuss your needs.  

 

 

About Us

Concentrus is a leading provider of innovative cloud-based enterprise resource planning (ERP) solutions, including NetSuite. Our team of NetSuite experts offers a range of services, including NetSuite price analysis, NetSuite training, and NetSuite integration services.  

Our goal is to help businesses of all sizes maximize their investment in NetSuite by providing expert NetSuite cost optimization and implementation strategies. With years of experience as a NetSuite partner, our NetSuite administrators and NetSuite consultants are well equipped to help businesses of all sizes with their NetSuite consulting needs.  

Whether you're looking for a NetSuite consultant to help with your NetSuite implementation or you need ongoing NetSuite support, Concentrus is here to help. 

 

Read About Our Implementation Methodology

 

Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos

 

 

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, NetSuite Integrations, Saved Search, Cloud ERP, Inline Editing

Subscribe to our blog!

Recent Posts

Posts by Topic

see all

Request a quote