SAP Knowledge Base Article - Public

3589569 - Mismatch in Item Numbers during Purchase Orders Import from Excel

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

  1. Go to Purchase Requests and Orders work center.
  2. Go to Purchase Orders view.
  3. Select the New button.
  4. Select Import from Microsoft Excel® option from the drop down
  5. Enter the data in the template and connected to their system via the add-in 
  6. 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

Product

SAP Business ByDesign all versions