You’re offline. This is a read only version of the page.
4,203
Hi Community,
I have an item, say a bun, which we put as 1 kg.
This bun is put into a pack.
Question, why does it shows 0.3 in Qty per UOM, when 1 bun is already 1kg?
Thank you!
Josh,
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. This is great, but there are some things to be aware of when setting an item up with different unit of measures.
An item must have a base unit of measure. The base unit of measure is how the inventory quantities are displayed and how the inventory is valued. 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).
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. Sometimes this is not possible and then it is good to know what is behind the ‘best practice’ to avoid getting into troubles. Here is an example of how to recreate an issue with different unit of measures:
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. The items unit of measures will then be setup like this.
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). One feet equals 12 inch (for all the metric people ).
We now purchase 10 feet which will create the following transaction.
After this we sell 120 inch (which is the same as 10 feet), this creates the following transaction.
As you can see the 120 inch translates to 9.9996 feet due to the rounding in the items unit of measures. This creates a scenario where we have 0.0004 feet left in inventory which we shouldn’t have.
Setting the items base unit of measure to inch would have prevented this situation (and you can still purchase it in feet). This is why it is always recommended to set the smallest unit of measure as the base unit of measure.
Although, this only happens when there is a rounding involved, knowing this you can say that it is quite safe to setup items with a pair as the base unit of measure and sometimes sell it in pieces or setup an item with meters as the base and sometimes sell it in cm, etc..
The situations that I have seen where it was more or less impossible to set the base unit of measure to the smallest unit was for produced items. In those cases all routings, work instructions, costs, etc. was related to a specific unit of measure and it was not feasible to rearrange the entire production setup just to have the smallest unit of measure be the base.
Hope this helps.
Thanks,
Steve
Thank you so much Zhu!
Hi, Yes, it's really not easy to understand. The bolded part is the base unit. So the screenshot should mean 1 Pack = 0.3 KG
Let's look at a simple example.
Create a Purchase Order and post it.
Then check the inventory. 1.3 kg (1 + 1 * 0.3)
Item Ledger entries:
Hope this will help.
Thanks.
ZHU
Hi Zhu, thank you for your reply.
I understand where to find the Purchase and Sales Unit of measure, but I just don't know how do we read the information in the screenshot below.
When navision show us Pack = 0.3, and kg = 1. how do we read this?
if kg is the lowest Base UOM for this item, how can it be possible to have Pack smaller than the base UOM?
Hope you can advise. Thank you!
Hi, It looks like the ratio is set in the multiple item units of measure or Sales Unit of Measure of this item.
For example:
Choose Unit of Measure action:
Or
Hope this will help.
Thanks
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,522
Super User 2024 Season 2
#2
Martin Dráb
228,441
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
