Use barcode for quantity in microsoft dynamics pos 2009

#Use barcode for quantity in microsoft dynamics pos 2009 how to

Setting the items base unit of measure to inch would have prevented this situation (and you can still purchase it in feet). This creates a scenario where we have 0.0004 feet left in inventory which we shouldnвЂ™t have. We now purchase 10 feet which will create the following transaction.ДЄfter this we sell 120 inch (which is the same as 10 feet), this creates the following transaction.ДЄs you can see the 120 inch translates to 9.9996 feet due to the rounding in the items unit of measures. One feet equals 12 inch (for all the metric people рџ™‚ ). The quantity per base unit for an inch is set to 0.08333 (the base unit must always be 1), this field has a maximum of five decimals so it gets rounded like this (which is part of the problem). The items unit of measures will then be setup like this. LetвЂ™s say we have an item that we purchase in feet and sell in inch and we setup the base unit of measure to be feet.

#Use barcode for quantity in microsoft dynamics pos 2009 how to

Here is an example of how to recreate an issue with different unit of measures: Sometimes this is not possible and then it is good to know what is behind the вЂbest practiceвЂ™ to avoid getting into troubles. It is considered best practice to have the base unit of measure to be the smallest one, this to avoid having fractions of units leftover due to rounding. It is also how it is produced (you can have a Production BOM in a different unit of measure, but the Routing and the Production Order will always be in the base unit of measure). The base unit of measure is how the inventory quantities are displayed and how the inventory is valued. This is great, but there are some things to be aware of when setting an item up with different unit of measures.ДЄn item must have a base unit of measure. Items in Microsoft Dynamics NAV can have multiple units of measures, you can for example sell in one unit of measure and purchase in another unit of measure.