Metric Conversion help needed.

[LaLouisiane]

I am doing a metric conversion for the first time. I know the file F41003 is used in some way. Can anyone give me some guidelines on how to determine my Related Unit of Measure? LB to KG, etc.

I ask because the key to F41003 is Unit of Measure and Related Unit of Measure.

How do I determine the related Unit of Measure? I would prefer not to hard code this.

 

[Jim_rubino]

Linda,

The first thing I will tell you is that if you go to GOOGLE.COM and in
the search box enter the conversion you want, example: 1 lb in kg and
then press search.
You will that 1 pound =3D 0.45359237 kilograms
On GOOGLE search you can find any conversion value by using the IN
keyword, i.e.:
1 ft IN inches will show 12 inches, and 3 ft IN yard will show 1 yard
and 1 gal in cups will show 16 cups. This is a very handing tool to
know and use.

Now in JDE world on the Item Units of Measure screen (P41002) here you
can put lb in the first field and then the .45359237 in the quantity
field and then kg in the last field.
In the file the first UM is the field UM field on this screen and the
Related UM is the second or converted to field on this screen.

I hope this helps you.
\\\\\|/////
( o o )

 

[John_Dickey]

Linda,

The unit of measure process in JD Edwards is pretty much user
defined. Both the Unit of Measure and the Related Unit of Measure use
the same UDC table (00/UM). As the customer/user, you have to set up
the conversions that you need to make in your system. So you determine
what kind of conversions you need to make for your system. For example,
if you need to convert pounds to kilograms, you set up that conversion.
Base JDE comes pre-populated the more common type of conversions that
you would need to make, and have a pre-populated UDC table. If you need
to add a unit of measure not in the UDC table, you just add the new code
to that UDC table, and then you can pick it to build your units of
measure conversion table (the F41003). My thinking is look at the base
JDE values and see if those will work for you.

John Dickey
Financial Systems Administrator
White-Rodgers, division of Emerson Electric
8100 West Florissant Ave.
P.O. Box 36922
St. Louis, MO 63136-9022
314-553-3067
[email protected]

 

[tpayne]

I would like to also add that this information can also be found in the JDE User Manuals, which the company should have on CD if not in printed form. The CD version is in pdf format and allows you to search for anything you need to look up (using Acrobat Reader).

You can use the information in the manuals plus looking at the relevant menu options and the data in the files, and for things like this it should be clear how to set everything up.

 

[LaLouisiane]

Thank you for your help.

Actually, I ended up creating a logical over F41003 so I could access it by Unit of Measure, then I have the related unit of measure as well as the conversion factor I need.

I just figured JDE would have something already set up to key into that file. I know the unit of measure I am moving from.. but.. the related unit of measure... I had no place to get that information.

I could have used processing options, etc. in my dreamwriter, but I created a logical over F41003 to key by only the Unit of Measure. It works great.

Thanks.

 

[LaLouisiane]

Thank you for your help.

Actually, I ended up creating a logical over F41003 so I could access it by Unit of Measure, then I have the related unit of measure as well as the conversion factor I need.

I just figured JDE would have something already set up to key into that file. I know the unit of measure I am moving from.. but.. the related unit of measure... I had no place to get that information.

I could have put it in the UDC table but I would have to depend on users to put that information into the UDC table.

I could have used processing options, etc. in my dreamwriter, but I created a logical over F41003 to key by only the Unit of Measure. It works great.

Thanks.

 

[LaLouisiane]

Thank you for your help.

Actually, I ended up creating a logical over F41003 so I could access it by Unit of Measure, then I have the related unit of measure as well as the conversion factor I need.

I just figured JDE would have something already set up to key into that file. I know the unit of measure I am moving from.. but.. the related unit of measure... I had no place to get that information.

Thanks for the info on GOOGLE, that is handy to know.

My boss did not want to have to use F41002 because he didn't want the issues of keeping it maintained.

I could have used processing options, etc. in my dreamwriter, but I created a logical over F41003 to key by only the Unit of Measure. It works great.

Thanks.

 

[John_Dickey]

Linda,

I am confused by what you did. If I understand you correctly,
you created a new logical file with 1 key field - the unit of measure
field. Am I correct in my understanding? If so, you did not need to do
that. You can do partial key processing in RPG programs. You just use
the field name to chain and read equal. Or create a key list that
contains just the unit of measure field as the only key field, and again
chain or read equal. But you have to be careful here - can very easily
have multiple records for a unit of measure. This is why JDE does not
supply you with a logical with just unit of measure as the only key
field. You are supposed to have both field values when accessing this
file. Otherwise you could end up processing a record you did not intend
to process. So this could be a dangerous thing you are doing here.
Food for thought.

John Dickey
Financial Systems Administrator
White-Rodgers, division of Emerson Electric
8100 West Florissant Ave.
P.O. Box 36922
St. Louis, MO 63136-9022
314-553-3067
[email protected]

 

[LaLouisiane]

John,

You're right, however, the user who is needing this assures me there will only ever be 3 records in F41003. LB to KB, SF to SM and FT to MT.

I will probably delete the logical, and just use the partial key.

Thanks for that heads up.

/lf

 

[Alec]

Linda

One extra point to John’s point if you are using your logical for metric and
non-metric conversions - Some units of measure have different quanties for
related units

Example one product could have 10 eaches in one box

A different product could have 25 eaches in a one box

To be safe you must look at first at the product’s unit of measure
relationships then if no match use the generic conversion.

Alec

 

[John_Dickey]

Linda,

That may be

 

[tpayne]

Re: RE: Metric Conversion help needed.

In my last job we had Boxes which could have about 30 different quantities, depending on the item and also where it was purchased from. Because they wanted to order in boxes not eaches, we had to set up 30 different UOM's for Boxes. Very messy!