SAP Knowledge Base Article - Public

3389715 - How to Add the List Price and Requested Date Fields in the Sales Order Excel Upload Template

Symptom

While creating the Sales Orders from Microsoft Excel the fields List Price and Requested Date are not available in the Excel Upload Template.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to Sales Order work center.
  2. Select the Sales Orders view.
  3. Click on New and select Sales Order from Microsoft Excel® option.
  4. In the downloaded excel template file, the fields List Price and Requested Date is not available.

Cause

It is not possible to add list price and requested date in the New Sales Order Excel Template as the excel is used to quickly create sales orders and required pricing master data needs to be setup in the system.

Resolution

It is the current system behavior. It is recommended to use the Customer Influence Forum to submit or vote for an improvement request.

Additionally, kindly check the ManageSalesOrderIn web service help documentation https://help.sap.com/doc/a2b4c7ef61d64397b2b1d052082a8a08/2305/en-US/PSM_ISI_R_II_SLO_SO_BUNDLE_MBO.html to assess whether the requirement can be fulfilled by the Web Service.

See Also

KBA 1972763 - How to Add the Sales Unit Field in the Excel Upload Template

Keywords

Excel Template; Excel Upload; Upload; Sales Order; XML; List Price; Requested Date
, KBA , AP-SLO-SO , Sales Order , How To

Product

SAP Business ByDesign all versions