Conversion from base unit to purchase unit and vice a versa

er.aman84
er.aman84 Member Posts: 18
edited 2008-01-17 in NAV/Navision Classic Client
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.

Comments

  • insanni
    insanni Member Posts: 52
    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
    insanni
  • darshanm
    darshanm Member Posts: 280
    Namaste!

    In this case your conversion factor between two UOM
    should be fixed.
    Darshan Mungekar
    Senior Consultan
  • yonhantdaenta89@hotmail.com
    yonhantdaenta89@hotmail.com Member Posts: 52
    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
    vaprog Member Posts: 1,163
    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.

Categories