SAP Knowledge Base Article - Public

3068369 - Cannot Update Price Components view Excel Add-In and/or Web Service

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

  1. Go to the Sales Orders work center.
  2. Select the Sales Orders view.
  3. Click New.
  4. 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, , KBA , SRD-CRM-ORD , Orders & Contracts , How To

Product

SAP Business ByDesign all versions