Symptom
In this document we will use the Sale Order Excel Upload Template as an example:
You are trying to maintain price component data inside the template, however, you don't find valid/available fields to proceed with such action.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Orders work center.
- Select the Sales Orders view.
- Click New.
- Select Sale Order from Microsoft Excel.
When the template opens, you do not find any available field to update price components.
Cause
Price component fields such as Total, Total Discount, Cost, Price Margin, Value Added Tax %, Total Net Value, Total Item Net Value and others cannot be updated via Microsoft Excel template or web service as these are calculated values.
Resolution
This is the system expected behavior.
Keywords
Sale Order, Excel, Upload Template, Price Components, web service; webservice; cost; ManageCustomerQuoteIn; Cost Estimate; Quote; ManageSalesOrderIn; Changing Condition type not possible; the field is read-only , KBA , SRD-CRM-ORD , Orders & Contracts , How To