Symptom
The Service Order excel upload failed with errors.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to the Service Orders work center.
-
Go to the Service Order Processing view.
- Select the New button and choose Service Order from Microsoft Excel®.
- Add mandatory details in the excel.
- Upload the excel in Business ByDesign system.
- 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
-
Go to the Organizational Management work center.
- Go to the Work Distribution view -> Organizational Work Distribution subview.
- Select Service and Support Team for Service Orders under Business Area:Service and Support.
- Click on Edit.
- Select the Add Rule option.
- 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 , excel template , type error , failed due to the errors , AP-SVO-SO , Service Order , Problem