Alternate UOM factor

Business Central/NAV Developers Forum
1

Hi all,

Our Client uses alternate UOM for an Item I0001. Sale UOM is PC & Purchase UOM is Kg.

Client wants to add 1000 PC into the Inventory by purchasing 5 kg Item I0001.

But alternate UOM factor never suggest that 5kg = 1000 PC. It’s near to 1000.
How to handle this issue in NAV 5.0 ?

2

What is the value in “Qty. per Unit of Measure” for this case ? What is your Base Unit of Measure, is it PC, if it is PC, then “Qty. per Unit of Measure” should be either 0.005 or its reciprocal 200, check it for yourself?

If it is PC, then in this particular case the calculation is simple and I believe it must show what you are expecting.

3

Thank Dhanraj.

What is the value in “Qty. per Unit of Measure” for this case ?

Here I want to store the value of (10/3) [not 3.3333] in the “Qty. per Unit of Measure” field.

4

For your earlier example, the value I suggested will work.

Recently, there was a discussion on this website on this topic and people suggested to use smallest unit as Base UoM and to avoid decimal places, search that discussion for yourself.

5

Hi Dhan raj,

Thanks for ur reply.

Suppose I store the value 3.3333 in the “Qty. per Unit of Measure” field.Which is actually comes from 10/3. But this value 3.3333, multiply by 3 will never gives me 10.

6

if you want to store 5 kg = 1000 PC for your Item I0001. so means 1 kg = 200 pc.

in your Item Unit of Measure, you need to define:
kg = 1
pc = 200

7

Hi Jeo,

if you want to store 3 kg = 10 PC for your Item I0001. so means 1 kg = 10/3 pc.

in your Item Unit of Measure, you need to define:
kg = 1
pc = ?

8

This issues has been discussed a number of times and following are few links:

http://dynamicsuser.net/forums/p/5301/26349.aspx#26349

http://dynamicsuser.net/forums/p/30303/158910.aspx#158910

The conclusion is that you should select Base UoM in such a way, so that these decimal discrepancies can be avoided