How to change Unit of Measure for Bin Contents record in Dynamics NAV

When trying to change status for production order from released to finished in Dynamics NAV, I have received error message saying: “The Bin Content does not exist“. After further analysis, I have found that production order had components set to be backflushed, so the first thought – we don’t have enough stock! However, the stock was there… plenty of it. Just, in the wrong (that is, different) unit of measure. And when the system was trying to backflush consumptions, it was trying to do so using “Unit of Measure” code from prod. order component lines.

After scratching my head for a minute, I decided that the quickest way of solving this issue would be to change Unit Of Measure Code for existing Bin Contents to match Unit of Measure defined on Prod. Order Component. However… I haven’t done this before…

How do you change Unit of Measure for your Bin Content in Dynamics NAV?

Go to Warehouse > Planning & Execution > Movement Worksheet and click Functions > Get Bin Content…
Change Unit of Measure - Movement Worksheet - Get Bin Content
In the request form, enter filters (your item, in this example, we will use LS-120, location, bin code, etc):
Change Unit of Measure - Movement Worksheet - Get Bin Content - Request Form
This will create a new line in Movement Worksheet with “From Bin Code” field filled in, and with blank “To Bin Code” field.
Change Unit of Measure - Movement Worksheet Line From
Enter “To Bin Code” (you can actually use “From Bin Code” field value, if the stock is in the right bin, but with the wrong Unit of Measure).
Change Unit of Measure - Movement Worksheet Line To
And click Functions > Create Movement…
Change Unit of Measure - Functions - Create Movement
This will create a new movement (take a note of the movement number):
Change Unit of Measure - Movement Created
Go to Warehouse > Goods Handling Multiple Orders > Movements and find your new Movement. You will notice that there are two lines – one to Take the stock from Bin Content and another to Place the stock back to another (or same) bin.
Change Unit of Measure - Warehouse Movement
Click Functions > Change Unit Of Measure…
Change Unit of Measure - Functions - Change Unit of Measure
In the request form, you can select any other unit of measure that is available for the item (in our example, we need boxes, so let’s select BOX). And click OK.
Change Unit of Measure - Whse. Change Unit Of Measure
This will result in Place line being changed to use new Unit Of Measure.
Change Unit of Measure - Warehouse Movement With Changed UOM
Now, if you would click Registering > Register Movement, system will create a new bin content record with new Unit of Measure (and I will be able to finish my production order with back-flush consumption).

Result!

Technorati Tags: , , ,

This entry was posted in Dynamics NAV / Navision, functionality and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *