SAP Knowledge Base Article - Public

2923577 - Sales Order ID is Showing # in the Sales Order Returns Rate report


You have created return ABC referring to 2 product lines from sales order DEF, while running the report:Sales Order Returns Rate, you only see one return item line correctly showing the sales order ID, the other return line showing # in the Sales Order ID field.

(ABC represents the ID of a return, DEF represnts the ID of a sales order)


SAP Business ByDesign

Reproducing the Issue

  1. Go to the Sales Orders work center.
  2. Go to the Returns view.
  3. Open return ABC and go to Items tab, there are 2 lines in the return.

Now, open the report "Sales Order Returns Rate"

  1. Go to the Sales Orders work center.
  2. Go to Reports view.
  3. Find report "Sales Order Returns Rate" and Open it.
  4. In the Selection, set Customer Return=ABC, and in the View, add row fields Sales Order ID and Sales Order Item ID.

You are able to see these 2 return lines. But only return line 10 could show the correct reference Sales Order ID: DEF and Sales Order Item ID:10. The other return line is showing # (not assigned) in the Sales Order ID and Sales Order Item ID fields.


The report Sales Order Returns Rate with data source: CRMSOCRTU internally uses other data sources to show the result. One being CRMSOCRIB (Customer Returns Sales Order Reference) for getting returns with sales order reference. For this data source, only sales order item with fulfillment status as "Finished" will be displayed in the result and this is the reason why in the report, for the return ABC line 20 with reference to sales order DEF-20 is not displayed on report as for the item 20 in the Sales Order , fulfillment status is "In Process" (Partial Delivery).

The data is currently not getting displayed if the related sales order is partially delivered and cancelled. This is a known limitation as we wouldn't be able to identify sales orders partially delivered and cancelled from the sales orders cancelled immediately after the release. Hence sales order references for returns created from partially delivered and cancelled sales orders won't be available in the data source as return sales order reference.


This is the current behavior of the report.


Sales Order Returns Rate; CRMSOCRTU; Sales Order ID; # , KBA , SRD-CRM-RET , Returns , Problem


SAP Business ByDesign all versions