3405060 - Error "Unit of measure does not exist" when uploading purchase order via excel template

Errors when create new purchase order via excel template：

One record failed to save due to the errors:

• Error: Unit of measure XYZ does not exist (KBA: 2743428) (XYZ represents the UoM of the product)
• Warning: Unit of measure XYZ not valid for product ABC (KBA: 2674385) (ABC represents the product ID)
• Warning: Price missing; price required for expected follow-up documents invoice or ERS

SAP Business ByDesign

1. Go to Purchase Requests and Orders work center.
2. Go to Purchase Orders view.
3. Download the excel template and maintain data in the template then upload.
4. You see the mentioned errors.

The product used in purchase order creation does not have base Unit of measure (UoM) maintained.

System is trying to read product master data in backend and trying to do conversion check between blank UoM (from product master) & XYZ (unit passed in excel). That's the first place where process is going into error & later calculation part is also failing.

Please maintain base UoM under General tab & Sales UoM under Sales tab for the product.

Once this is done, log out & log in again, then try to upload file.

While uploading file, please follow below steps for UoM column in excel file: Click on the cell "Unit of measure" -> Click on Business ByDesign button -> Click Lookup button ->You see a popup where you can choose the UoM based on Description.

Unit of measure does not exist, Unit of measure not valid for product, Price missing; price required for expected follow-up documents invoice or ERS, Purchase order, Excel template , KBA , SRD-SRM-PRO , Purchase Requests and Orders , Problem