Conversion from base unit to purchase unit and vice a versa

er.aman84

Hi,

One of our client maintaining inventory in numbers and purchase orders issued in kgs (or meters) (there is two unit of measures involved ie Base unit of Measurement & Purchase unit of Measurement).

For example: Item X

1 NUMBER = 1.5 KG and vendor will give the price in kgs.

If there is 2 number then kg will be 3.0 kg

Purchase order will be for 3.0 kg. And when we receive the purchase order, inventory will increase by 2 number.

You all are requested to give us the solution at the earliest.

insanni

You must set-up in Item Card :

create unit of measure code for Number and KG
fill 'base unit of measure' field with 'Number' and create another unit of measure (KG) with the conversion (1 Number = 1.5 KG)
fill 'purchase unit of measure' field with KG

darshanm

Namaste!

In this case your conversion factor between two UOM
should be fixed.

yonhantdaenta89@hotmail.com

hi @darshanm

i also got one story like this. my question is this

1. can warehouse receive a posted whse receipt with 2 in (Number) as the Quantity, while the PO open 3 in (KG) .
2. will the price or cost will adjusted to the unit of numbers?
for example 3(KG) are $100 so in 2(numbers) also $100
3. why that, because the warehouse use the item in ( numbers ) not in (KG), so the warehouse will negative the item in Numbers with adjusted cost based on the PO. if they negative 1 (Numbers ) the cost will be $50


Many thanks,

vaprog

All warehouse transactions are registered in the system using the Item's Base Unit of Measure, regardless of any other units used in associated documents. NAV handles the conversion.

In most tables where item quantities are involved you will find the quantity related to the unit of measure you chose (e.g. the Purchase Unit of Measure in the PO) and additionally the "Quantity (Base)", which is Quantity [UoM] converted to [Base UoM]

Price is always related to UoM. Cost (in contrast to unit cost) and amount is not related to the unit of measure, as cost per unit and price are inversely and proportionally related to the quantity when unit of measure changes.