Base UOM Question: Rock|Hard Place

Savatage

Nothing is more frustrating than telling someone that the BASE UOM MUST BE FILLED IN and it doesn't happen.

So I added the "Mandatory Field" code (which has been discussed here many times (Seach: Mandatory Fields)

One of the problems I have is that once 1 ledger entry has been made it no longer allows you to enter a "Base Unit of Measure". This is the case for 4 out of 5500 items.

But the code POP's up the message " You MUST enter a Base UOM for item: XYZ" everytime you go in and out of that item.

Does anyone know a way of forcing a value into the base UOM. Our base UOM is always 1 so if won't screw anything up. and these are NEW items so other than just receiving the merch into stock there are no other Ledger entries.

I just need to force "EA" for each into the Base UOM for these items - Any suggestions other than exporting, fixing & importing the item table?

Thanks

Savatage

Ok I found a workaround...

I see it only POP-ups the message about "you can't enter a base unit of measure......"

if the item has open entries. since these were brand new items with just 1 entry for receiving it was easy to open the "Item Ledger Entry" table & uncheck the "Open" field.

then go back to the item & enter the Base UOM.
then go back to the Item Ledger Entry table & re-check the "Open" field.
then while i was there I also put in the UOM in the ledger entry.

---

any positive =D> or negative [-X thoughts???

Marije_Brummel

I think wat you have done is what most consultants would have done, it is good that you put the UOM also in the ledger entry.

Have thought abount defining a default UOM?

You can add a default UOM to the Inverntory setup and use this in the OnInsert of the Item table.

Also you can use the InitValue of the field, but this is more quick and dirty.

If you then use the not black property your nightmare is gone, without any mandatory code thing, which is not realy a Navision way of work.

Savatage

i believe I have tried the init value a long time ago. I remember it not working because you physically have to drill into the Item Unit of Measure table and create a UOM first.

or did i miss something?

DenSter

You could also put something in the posting routines that checks for the Item's Base uom and error out if it doesn't have one.

If I understand Mark correctly, he means that you can program the Item table to create a record in the Item Unit of Measure table for the default UOM entered in the Inventory setup. So you create a new field called "Default Base Unit of Measure' to the Inventory Setup table. Then in the Item table's OnInsert, you check to see if the Base Unit of Measure is entered, and if it isn't you create a new Item Unit of Measure record with the uom entered in your new Inventory Setup field.

You'd still want to check the qty per of that default uom, and still have some kind of check in the posting routine I believe, just to make sure that everything checks out.

Savatage

ahhh :P - gotcha

Marije_Brummel

I think the check in the posting routine is the best solution and also the most Navision like.

Making this in combination with a default setup will I think totaly eliminate all problems