Unit Conversion
Description
Returns the conversion factor between two units of measure for a given item number.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Short Item Number | Column or Literal |
| Business Unit | Column or Literal |
| Input Units | Column or Literal |
| Output Units | Column or Literal |
| Maximum Hops | Integer with default of 6 |
| Only Rollup If | Generic Criteria |
Remarks
- Allows you to take a value based on the Unit of Measure's User Defined Code value and convert the value using the F41003 Unit of Measure table to get a conversion rate into your desired new unit value.
- The calculation may include the F41002 table as well as it provides item and branch plant specific unit conversions.
- The system will attempt to chain together conversions (ex: KG > OZ would go through KG > LB > OZ). The 'Maximum Hops' setting provides a cut-off. If a conversion did not occur before 'Maximum Hops', then 0 is returned for the conversion.
- An item-specific conversion (F41002) is preferred over a general conversion (F41003).
- A mixture of item and branch plant specific and general conversions can be chained together.
Example
Imagine that you have transactions for various items in various units. What if you wanted to see those transactions in one unit? Let's say you wanted to see everything by kilograms or cases. This topic explains how to use the Unit Conversion calculation to solve this problem.
JD Edwards allows users to enter transactions for items in various units. Although JD Edwards provides unit conversions for items, it is fairly difficult to actually query this conversion information and provide the correct conversion. The Unit Conversion calculation lets you convert any unit to any other unit seamlessly. To convert the units of an item:
- Right-click the item number in your grid.
- Select Quick Calculation | EnterpriseOne/World | Unit Conversion.
- Data Access Studio will create a new column called "Unit Conversion". Double-click this new column to edit.
- You will see that the Short item is already populated with the Short Item Grid Column setting.
- If business units affect your conversions, select a business unit column for the Business unit setting.
- Select Input units if your table has transactional units (usually the UM field). If you leave Input Units blank, then the calculation will use the base unit of the item as the input unit.
- Select the desired Output unit. This can be a parameter or hard-coded value.
Once you get data, you will see that the Unit Conversion column has the correct unit conversion for each item. Simply multiply your transaction quantity by this conversion to get the converted quantity.