Symptom
You are not able to select a distribution channel in the sales documents and in the sales data of the account master data. In the drop down list there are no records shown.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Orders work center.
- Select the Sales Orders view.
- Click on the New button and select the Sales Order option.
- Enter an account.
- Enter a Sales Unit.
- The following error message is displayed:
Item : Distribution channel or sales organization missing - When you click on the drop down list for the Distribution Channel you can see that there are No records found.
- Open the account master data for the respective account.
- Navigate to the Sales Data tab.
- Enter a Sales Organization.
- click on the drop down list of the field Distribution Channel.
- You can see that also here the system displays: No records found
Cause
The reason why you get no results for the distribution channels is due to the fact that the work distributions rules for your sales organizations have either not been set up or are not valid anymore.
You can check this as follows:
- Go to the Organizational Management work center.
- Select the Work Distribution view and the Organizational Work Distribution sub view.
- In the field Effective Date enter today's date.
- Click on the Go button.
- Select the work category Relevant Distribution Channels.
- You can see that no rule has been set up and the Work Distribution Status is Global Work Assignment.
Resolution
- Go to the Organizational Management work center.
- Select the Work Distribution view and the Organizational Work Distribution sub view.
- In the field Effective Date enter today's date.
- Click on the Go button.
- Select the work category Relevant Distribution Channels.
- You can see that no rule has been set up and the Work Distribution Status is Global Work Assignment.
- Click on the Edit button
- Create the rules for your sales org units.
- Click on the Save and Close button.
You will now be able to select the distribution channel in the sales documents and in the sales data of the account master data.
See Also
2548518 - The Sales Order or Sales Quotes Uploaded via Excel Failed with Errors
2682040 - The Service Order Uploaded via Excel Failed with Errors
1893004 - The Sales Order Uploaded via Excel is Inconsistent
Keywords
Distribution channel; sales organization; missing; No records found; , KBA , AP-SLO-SO , Sales Order , How To