SAP Knowledge Base Article - Public

1893004 - The Sales Order Uploaded via Excel is Inconsistent

Symptom

The sales order uploaded via excel is inconsistent.

Reproducing the Issue

  1. Go to the Sales Orders work center.
  2. Go to the Sales orders view.
  3. Select the New button and choose Sales Order from Microsoft Excel®.
  4. Add mandatory details in the excel with:
    • Product as ABC (ABC represents the ID of the product).
    • Quantity as XXX (XXX represents the value of quantity).
    • UOM as XYZ (XYZ is the Unit of Measure of the quantity).
  5. Upload the excel in Business ByDesign system.
  6. The sales order created via excel has below inconsistency: 
    • Error: Item : Distribution channel or sales organization missing
    • Error: XXX is not a valid value for this field. Enter a valid value.
    • The quantity selected for the product is zero.

Cause

You have not set the master data correctly due to which system is not able to recognize the Sales Unit, Distribution Channel, Minimum Order Quantity and Unit of Measure (UOM).

  • No Organizational Work distribution rule is defined, hence after the upload of sales order, the sales order cannot pick the sales unit and result in error on product.
  • No Quantity Conversion defined for the product.
  • No Minimum Order Quantity is defined for the product.

Resolution

You can set up the automatic determination of Sales Unit and Distribution Channel in the sales order by following below steps:

  1. Go to the Organizational Management work center.
  2. Go to the Work Distribution view -> Organizational Work Distribution subview.
  3. Select Sales Unit for Sales under Business Area: Sales and Marketing.
  4. Edit the Sales Unit for Sales option.
  5. Select the Add Rule option.
  6. You can add the rule depending upon your business requirement. This rule ensures automatic determination of sales unit in sales documents.

Follow the steps below to add Quantity Conversion and Minimum Order Quantity in the product.

  1. Go to the Product and Service Portfolio work center.
  2. Select the Products view.
  3. Search for the product ABC (ABC represents the ID of the product).
  4. Select the product ABC and choose Edit button.
  5. Select the View All button and go to the General tab.
  6. Add the quantity conversion (standard to XXX).
  7. Go to the Sales tab.
  8. Add the Minimum Order Quantity (this will ensure that quantity is not picked as 0 in the sales order).

Keywords

KBA , AP-PRP , Purchase Request Processing , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708