SAP Knowledge Base Article - Public

2602958 - Unable to Update Process Status to Lost for Sales Quotes Using Data Workbench

Symptom

You have requirement to mass update the Process Status to Lost for Sales Quotes using Data Workbench, but unable to update the status field and system threw no error.

Environment

SAP HYBRIS CLOUD FOR CUSTOMER

Reproducing the Issue

1. Go to the Data Workbench work center
2. Select Update view;
3. Select Object Sales Quote
4. Press Next;
5. Upload the template;
6. Press Next

Go to Data Workbench work center -> Monitor view;
See that Update is finished without Error; But the progress status is not updated as expected

Cause

The Progress Status field(and also all other status) cannot be set directly via a service from outside. The Status is always determined internally by the system based on the current state of the Quote. If setting of Lost Status is possible or not follows the same logic as manually from the UI.

For example, Quotes which have been confirmed to the Account or their Doc Types are configured as not relevant to form output can be set to Lost while Quotes which are inconsistent or have no form output confirmation cannot be set to Lost.

Resolution

Please provide the Reason for Rejection (CancellationReasonCode) in the update csv file. With setting of the Reason for Cancellation, the Progress Status will automatically be set to Lost.

Keywords

Data Workbench; Sales Quote; Progress status; Status Lost , KBA , LOD-LE-CQP , Customer Quote Processing , How To

Product

SAP Cloud for Customer add-ins all versions