Symptom
You would like to know how to configure Currencies, Measurement Units and values works in C4C for Sales Documents. In this example we are using the Sales Quotes.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to the Sales
- Open Sales Quote view
- Add product ID: ABC ( ABC stand for the Product ID)
- Add Quantity
- Observe: the UoM (Pails; Gallons, Quarts, Ounces ) does not exist in the dropdown list of UoM
- In the Business Configuration all UoM are maintained but once you change the UoM in the Products Tab of the Sales Quote you have an error
- Error- ''Quantity conversion not valid; conversions must be interrelated''
Cause
- The Physical Units are not Maintained
- You have not maintained the Currency and Quantity Conversion
- Quantity conversion i.e. From and To quantity conversions were reversed due to which quantities were not interrelated.
Resolution
First off all, you have to create Trading Units.
Create and Maintain Trading Units
For the purposes of quantity conversion, you can further define your new trading UoM by referencing a predefined UoM in the Product Data tab. Any new trading UoM that you create can be used internally but not for electronic transactions between one business and another (B2B Communication) unless the new UoM is common to both business partners. UoMs shipped by SAP adhere to the UNECE standards and can be used for B2B Communication.
Note:
You can only delete UoMs with the status In Preparation. Only UoMs with the status Released are displayed on the interface.
To create and maintain trading units, follow these steps:
- Go to the Business Configuration > Activities > Quantities and Units of Measure
- Click on Create and Maintain Trading Units in the
- Click on Add Row to add a new trading unit
Maintaining Physical Units:
Any new physical UoM that you create must reference another predefined physical UoM. This UoM can be used internally, but not for electronic transactions between one business and another (B2B Communication) unless the new UoM is common to both business partners. UoMs shipped by SAP adhere to the UNECE standards and can be used for B2B Communication.
Note:
You can only delete UoMs with the status In Preparation; only UoMs with the status Released will be shown on the user interface.
The reference offset and factor are used to convert quantities between the Reference UoM and the new physical UoM. The reference offset is only used in a limited number of cases.
Example1:
When converting Centigrade to Fahrenheit.
The formula used for conversion is: (Quantity in Reference UoM * Reference Factor) + Reference Offset = converted quantity.
Example2:
To convert 100 degrees Centigrade to Fahrenheit you set a reference offset of 32 and a reference factor of 1.8. The formula would look like this (100*1.8) + 32 = 212 degrees Fahrenheit.
The symbol represents the UoM. Most physical UoM symbols are recognized internationally.
Example3:
kg for kilogram and lb for pound.
To create and maintain physical units, follow similar steps, as mentioned in the trading units section above.
Currency and Quantity Conversion
If a currency field is selected in a condition, currency conversion will be performed during runtime. The currency amount in the condition will be converted into the currency used in the related business object.
Example 1:
The condition specifies that a notification will be sent if the net value is greater than 100 EUR. The net value in the related business object is 80 USD. The system will convert 100 EUR into USD and compare the value in the condition with the one in the business object to determine whether to send a notification.
Note:
If a quantity field is selected in a condition, quantity conversion will be performed during runtime.
If the quantity in the condition is product-related, quantity conversion will not be performed.
Example 2:
The conversion will not be performed if the quantity unit in the condition is “each” and the quantity unit in the business object is “pallet.”
If there is just one quantity in the related business object, for example, in the header of a business document, quantity conversion will be performed if the quantity unit is not product-related. For example, the conversion will be performed if the quantity unit in the condition is “meters” and the quantity unit in the business object is “centimeters.”
The above error message is a valid one. Please refer to the Quantity conversion node of Product where we maintain conversions. Over here it is important that if you know the quantity in any UoM, it should be possible to convert to another UoM. Let's understand this with an example
1 Pallet = 10 cases
1 box = 10 bottles
This is not a valid conversion as you cannot convert from Pallet to Bottles. The correct conversion would be
1 Pallet = 10 cases
1 case = 10 boxes
1 box = 10 bottles
Here all the UoMs are interconvertible.
Please verify the below details to fix this issue from your end:
Verify the Base UoM.
Please check the Product for which the error is being thrown and identify the missing link in quantity conversion.
Create the missing link between the used quantity conversions.
Once you fix this you can perform the migration activity again and it should go through without any issues.
Keywords
Trading Units, UoM, Currencies, Physical units, interrelated , KBA , LOD-LE-CQP , Customer Quote Processing , How To