Symptom
You are trying to upload data for a price list and when performing such action the system returns one of the following:
Message: 0 Record(s) successfully saved in SAP Business ByDesign
or
Error: Value for Unit of Measure and XX is invalid for Line Item
Environment
SAP Business Bydesign
Reproducing the Issue
In this example we will use Company Specific Price List.
- Navigate to the Product and Service Portfolio work center.
- Select the Price Lists view.
- Search for Company Specific Price List.
- Select ABC (ABC represents the name of the price list).
- Click Download.
- Fill the excel file.
- Click Save Data To.
The system returns the following:
Message: 0 Record(s) successfully saved in SAP Business ByDesign
or
Error: Value for Unit of Measure and XX is invalid for Line Item
Cause
You are passing the Unit of Measure as lower case such as "ea" or using the value value.
Resolution
This is the system expected behavior.
Please change the Unit of Measure to upper case, changing "ea" to "EA" and click Save Data To.
If this does not work, please click the Lookup button and the system will propose all valid Unit of Measures.
See Also
2788104 - Quantity Unit Error When Uploading Customer Invoice
Keywords
Price List, Quantity, Unit of Measure, UoM, Price, Value, Unit, Error, Upload, Invalid, Excel, SAP Add-In, Microsoft Excel, 0 Record(s) successfully, 0 Record(s) , KBA , AP-PRC-PC , Calculation , How To