Item Base UOM Change

armela20

HI there.
My client wants to change the base UOM of some items, however the system does not allow that because there are open ledger entries for that item.
I can certainly change it through a processing report, howeve I am not sure what the impact with be down the road.
Does anyone know ??
Can someone give me advice ??

Thanks

Savatage

I believe there are some posts on this if you search for "Unit Of Measure" or UOM

For Us this comes up once in a while (not often) but we found it easier to simply create a new item number & cost & prices.

When you change the base unit of measure all the costs & inventory has to be adjusted to match that UOM (hope that made sence).

Anyway once the new item# was created we simply transfered the merch to the new item #, blocked the old & entered the new item # into the old item#'s "Subsitute Item No." This way even if someone enters the old item number in an order it will switch to the new number.

That's the easiest way IMHO.

Here's More:
http://www.mibuso.com/forum/viewtopic.php?t=7727

Kowa

The warning that there are open item ledger entries should be taken seriously.
If you want to maintain the item no. ,calculate the inventory,create item journal lines with a negative adjustments to bring the inventory down to zero, then change the base UOM and post a postive adjustment with the new base UOM to regain the inventory. Take care that the unit cost for the positve adjustment is correct.

If only the code of the base UOM is wrong (e.g. "pce" instead of "piece") but everything else ( value, size, weight etc. ) remains the same, you can change the code via a batch job but check for all table relations for the UOM first.