Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community

Inventory Value in different unit of measures

rated by 0 users
This post has 7 Replies | 3 Followers

Top 150 Contributor
Posts 126
Points 2,690
Member since 09-25-2007
lally Posted: 10-24-2008 14:31
Hi,

What is the report available in navision to know the Inventory Value in different unit of measures ?

Inventory qty in Different unit of measures ?

Not based on the Base unit of meanusre .

For eample My item Base unit of measure = Ml, in Item card.
I can purchase this Item in Litre.

So finally I want to know what is qty in ML and what is the quanity in Litres.

Whgat is the value in Ml and what is Inventory value if I consider based on KGs ?


Navision is showing is only based on the BASE UNIT OF MEASURE in Item card .[

Pleas help me
Top 75 Contributor
Male
Posts 309
Points 4,430
Member since 11-06-2005

Inventory value is inventory value.  Viewing it with a different "unit of measure" would not change the value.

 

Top 150 Contributor
Posts 126
Points 2,690
Member since 09-25-2007

 

 

so in  navision there is no possibility  to know the inventory value in different unit of measures

Top 75 Contributor
Male
Posts 263
Points 3,845
Member since 05-06-2008

Hi,

The confusion is in the title.  What you are looking for a Inventory Levels (qty) report in different unit of measure i.e. Sales unit of measure, Purchase unit of measure.  This is not a standard report so you will have to develop it.

Dave Treanor

Dynamics Nav Add-ons

www.simplydynamics.ie/Addons.html

Top 150 Contributor
Posts 126
Points 2,690
Member since 09-25-2007

Hi Dave

  

In item card  I define the Base unit of measure  =   ML( Millitere)

 

But I purchase this item in 200 Ml, 500 Ml, 1 Liter, 2. 5 Liter, 5 Liter..

  

I want to know the qty  In 200 Ml, what is the Quanity in 500 Ml, what is the qty in 1 Liter,…..

     

Actually this is what I  want .

 

Top 75 Contributor
Male
Posts 263
Points 3,845
Member since 05-06-2008

Hi Lally,

If the item is packaged differently well then it's a different item and should be setup as such.

Dave Treanor

Dynamics Nav Add-ons

www.simplydynamics.ie/Addons.html

Top 75 Contributor
Male
Posts 309
Points 4,430
Member since 11-06-2005

Use Bins

 

Top 10 Contributor
Male
Posts 1,359
Points 17,770
Member since 01-23-2004
DynamicsNAVMVP

lally:
In item card  I define the Base unit of measure  =   ML( Millitere)

 

But I purchase this item in 200 Ml, 500 Ml, 1 Liter, 2. 5 Liter, 5 Liter

I don't think it is a good idea at all to keep the base UOM at ML. A 200ML bottle is something significantly different than a 500ML bottle, or a 5 L bottle, they should all be their own items, and stocked in Eaches. It doesn't give you any information to know that you have 20000000 ML worth of water in various bottle sizes, that just doesn't tell you anything.

 

And besides that, if you buy in bottles of 200ML, convert it to ML, you can't convert that to bottles of 500ML, because you would first have to pour the water out of the 200ML bottles and pour it into 500ML bottles. That would be completely false information. 5 bottles of 200ML and 2 bottles of 500ML both add up to one liter, but they are definately NOT the same thing.

Page 1 of 1 (8 items) | RSS


Copyright Dynamics User Group, 1995-2009, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.