SAP Knowledge Base Article - Public

2682040 - The Service Order Uploaded via Excel Failed with Errors

Symptom

The Service Order excel upload failed with errors.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Service Orders work center.
  2. Go to the Service Order Processing view.
  3. Select the New button and choose Service Order from Microsoft Excel®.
  4. Add mandatory details in the excel.
  5. Upload the excel in Business ByDesign system.
  6. You receive the pop up mentioning Record(s) failed to save due to the errors.

Create not possible; source object inconsistent

Party with role Sales Unit missing

Location with role Sales Unit missing

Organizational data missing

The currency was not found for account XYZ, sales organization  and distribution channel (XYZ represents the Account ID)

Distribution channel or sales organization missing

Cause

You have not set the master data correctly and the system is not able to recognize the Parties.

Resolution

  1. Go to the Organizational Management work center.
  2. Go to the Work Distribution view -> Organizational Work Distribution subview.
  3. Select Service and Support Team for Service Orders under Business Area:Service and Support.
  4. Click on Edit.
  5. Select the Add Rule option.
  6. You can add the rule depending upon your business requirement. This rule ensures automatic determination of parties in service documents.

See Also

2548518 - The Sales Order or Sales Quotes Uploaded via Excel Failed with Errors

1972763 - How to Add the Sales Unit Field in the Excel Template NewSalesOrder and NewServiceOrder

Keywords

Excel Template; service order; failed due to the errors; Type Error; , KBA , service order , type error , excel template , failed due to the errors , AP-SVO-SO , Service Order , Problem

Product

SAP Business ByDesign 1808