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.
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.
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.
This is the system expected behavior.
Sale Order, Excel, Upload Template, Price Components, , KBA , SRD-CRM-ORD , Orders & Contracts , How To