Dynamics Community Forum Thread Details

Editable Subgrid on Opportunity for opportunity Product

Hello Community,

I recently encountered an issue with the editable grid on the Opportunity Product subgrid in Dynamics 365, where custom fields appeared with a lock icon and were not editable.

Issue:

In Dynamics 365, when using an editable grid on the Opportunity form to display the Opportunity Product subgrid, some custom fields are not editable and show a lock icon beside them. This is problematic when trying to update these fields directly from the subgrid.

Tested Solutions:

Field Properties Check:
Ensure that the custom fields in the Opportunity Product entity are not set to read-only. Also, confirm that they are not calculated or rollup fields, as these types cannot be edited in any grid.
Security Roles
Editable Grid Configuration:
Ensure that the grid is set to editable for all client types (Web, Phone, Tablet)
Testing with System Administrator Role to make sure it is not security role issue.
Form Design Review