Hi,

I am using conversion factors for the following units:
1. Rolls (rl)
2. ft (feet)
3. inch (in) This is the base unit.
The 3 units are defined as length in the Units table.

We create a conversion factor as follows:
Base unit: in
ft FOOT 12.00000000 0 0.083333 0
m METER 39.37000000 0 0.025400 0
rl ROLL 19620.00000000 0 0.000050 0
yd YARD 36.00000000 0 0.027777 0

The problem is that we have an item the we buy it in rl and consume it in ft. LN only allows us to put the converstion factors related to units, in this case in. Therefore there is no direct converstion factor between them.
The price of the item is $37 USD/rl and the cost is 0.0126 USD.

Any idea how Baan creates the conversion? We can't get this number.
Any help It will be appreciate.

Thanks

Soory the prices is 37.7 USD instead of 37.
Thanks

For this you need to create a conversion factor at the Item Level using the Base unit of the Item and then insert the Conversion Factor under that.

I can't.
The problem is that when I try to create ft to rl for the item in specific. LN displays a message that says "Define the conversion factor at general level" and the when I tried to define at general level Baan is not allowing me to put ft in the base unit because ft is not a base unit.

i hope I made myself clear.
Thanks

What are your Base Units:

Weight lbs
Length ft
Area(m2) sqm
volume gl
Time hr

If you have a different base unit for Length then you would have to define the conversion factor based upon that base unit.

Hi
Do you use LN?

What inventory unit do you use in that item?

You can use conversion factor in item level.
Input all the conversion in item level, everytime you have a new UOM that only be converted for this item (eg : roll)

For purchase unit , you can define it in Item Purchase
But for consume it, you can only use one UOM (Inventory unit).
So you can use many of UOM for sales unit and purchase unit.
but for inventory consumption, it always read the inv unit.
I ve benn through this before, and find lots of problem because of this.
Any other opinion?

I think the error message "Define conversion factor on general level." does not block, does it?

Maybe it is not wise to have the Roll defined as a length. In fact it is a "piece".

Factors between length units are rarely item specific and therefore the warning is given I guess.
E.g.: 1 meter = 100 centimeters. That is not different for any item.
(oh.. some venders sell 110 centimeters out of 1 meter, maybe ;-) )

Hope this helps you!

Regards,
Eddy

Hi achavezf,

did you solved your problem ? i'm facing the same now.

would be thankful if you tell what have you done.

Hi:
Since your base unit is "in" (inch), you have to define the conversion factor between inch and roll at general level as both of them are for type "length".
Though this could be huge factor (1 roll = 235440 inch), it should be possible as ERPLN allows conversion factors till 10^6.
As you already have maintained conversion factor between inch and foot, ERPLN would understand it and covert roll to ft.

Hope this solves your problem