Symptom
The item numbers in the excel template do not match the item numbers once loaded into the system for the purchase order excel upload.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Purchase Requests and Orders work center.
- Go to Purchase Orders view.
- Select the New button.
- Select Import from Microsoft Excel® option from the drop down
- Enter the data in the template and connected to their system via the add-in
- Click on "Save Data to" to send the data over and create the purchase order
Cause
The issue arises when the same service item ID or product item ID is used multiple times in an Purchase order excel template upload. The system cannot differentiate between the line items.
Resolution
This is an expected system behavior. If you enter different service item ID or product item ID then system will differentiate and populate line items in the same item number.
See Also
Keywords
Item Numbers; Mismatch; Purchase Orders Excel Import; , KBA , SRD-SRM-PRO , Purchase Requests and Orders , Problem
SAP Knowledge Base Article - Public