You have created a sales target plan and you are viewing it in Excel. You would like to edit the Quantity field, however the Excel cell is greyed out and not editable.
Reproducing the Issue
- Go to the work center Sales, view Sales Target Planning.
- Choose your plan and open it in Excel.
You are not able to edit the Quantity field in Excel. The cells are greyed out.
You can only update the quantity if the respective product has a valid unit of measure.
If there is no product (i.e. if the product is Not Assigned / # in a particular row), there can be no unit of measure either. For this reason, no quantities can be maintained. This is the correct behaviour.
Please also see the details in the case document 2080212 - You are Not Able to Edit the Quantity of your Sales Target Planning in Excel .
KBA , SRD-CC , Cross Components , How To