Wrong Base Unit of Measure

dkblee · 2006-02-16

Hi! One of the user created a wrong Base Unit of Measure for an item and i can change it to the correct one now. It prompted me the msg

"You cannot change Base Unit of Measure because there are one or more open ledger entries for this item"

What should i do from here?

Thks!

ara3n · 2006-02-16

please search the forum. There are several threads on this subject.
Basically have to bring the inventory to zero.

johnson_alonso · 2006-02-16

If you want to change the base UOM, you must empty your inventory to zero by using item journal. The other method you must use sales order that also aims to delete inventory qty to zero.

rgds,

Johnson Alonso

dkblee · 2006-02-16

Hi!

Do i need to do any reclass?

Thks!

kriki · 2006-02-16

dkblee wrote:

Do i need to do any reclass?

Not necessary, just make an item journal line with the opposite amounts (1 per location code/bin code).
E.g. you have 10 items in RED and -3 in YELLOW. In this case you would have to create 2 lines: one with -10 in RED and one with +3 in YELLOW.
Once the inventory is 0 (=meaning that are item ledger entries of that item are closed), you can change the unit of measure.

dkblee · 2006-02-16

Hi!

You are saying i need to go to list item by location. From the available location(with qty in those loc.) make +ve or -ve adjustment in Item Journal?

eg. in loc A 100

I will have to -100 in Item Journal?

kriki · 2006-02-16

A thing you can try (but first on a copy of the DB), is the Phys. Inventory Journals. Get the inventory for only that item, and before posting it, put it on 0, so Navison will post negative entries and connect them. This can be faster than doing it manual.

One thing I forgot to mention before: of course after changing the unit of measure, you have to re-input the quantities to get your inventory correct.

dkblee · 2006-02-16

Hi! How do i input back the qty that i've deducted from item journal after changing the UOM? through +ve adjustment in Item Journal as well?

Thks!

kriki · 2006-02-16

Yes. But you need to write down (or check in the real-world magazines) the quantities of the item in the diferent locations.
You also need to give in the correct unit cost of the item.

dkblee · 2006-02-17

Hi! If that item is used in some of the BOM , does this method of +ve, -ve of adjustment still applicable? Any other thing that i need to take note of?

kriki · 2006-02-17

Yes, but everywhere you used it, you have to check and update it.
e.g. If you have open sales orders of that item, used in a BOM, ...

dkblee · 2006-02-18

Hi!

Sorry i'm very new in Navision. What do you mean by check and update?
What should i check and update in the BOM?
I thought i only need to update(+ve,-ve adjustments) it in the Journal line.

johnson_alonso · 2006-02-20

Hi,
I will try to answer your question about how to check and/or update SO and BOM. Sorry for it.
for Sales order, you must go to status, if you have released it, you must reopen by Alt-u, then push o in keyboard, then you click the item you have made +ve adjt and then press enter or click OK button. For BOM, if you have certified it, you must first go to status and make the status under development by click drilldown button, then do the same as in Sales Order.
g'luck

rgds,
Johnson Alonso
"Praise the Lord, o my soul"

Howdy, Stranger!

Quick Links

Categories

Wrong Base Unit of Measure

Comments