Symptom
When creating multiple products using the generic Copy & Paste feature, an error is raised with the text 'Entry xx is not a valid ID based on the search criteria configured.'
*Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.*
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to the Sales Workcenter.
- Navigate to the Sales Quote or Sales Order View.
- Open an existing document or create a new document.
- Access the Product facet or Add Product section.
- Click the paste icon.
- Copy the product internal ID from an MS Excel file.
- Paste the data into the table.
The system throws the error message: Entry xx is not a valid ID based on the search criteria configured.
Cause
The error message occurs because the Product External ID is maintained for the ID field in the Adaptation mode.
Resolution
To resolve this issue, please follow the below steps:
- Go to the Sales Workcenter
- Go to Sales Quote / Sales Order View
- Open any existing document or create new document
- Go to Product facet or Add Product
- Go to Adaptation mode
- Now click on Add button to add the product.
- Click on the product value selection
- Click on the edit/pencil icon in the product screen
- Under the adapt change the value of the drop-down field from Extern
- End the Adaptation
Now you can try with any internal ID of the product and see the error doesn't pop up.
See Also
Keywords
- Excel copy-paste product
- Add product
- Copy paste
SAP Knowledge Base Article - Public