Are these 2 different items or are they the same item with 2 different UOMs.  What is your valuation method?  I'm assuming it's 2 different items because MAS 500 stores the quantities by stock unit of measure.

Hi John, these are different items set to different Each UOMs. Valuation is Average for all items.

Cesar,  This is probably a non trivial task.  I've done very similar things but this was all through the back end in SQL.  I know Lou Davis and Joe Noll (both post on here) have the skills to do this.  I would offer but I'm not a consultant anymore.  Maybe someone from Sage has an 'easy' idea.  We recently did something similar but in our case it was moving the items to EACH from PACK unit of measure.  It was pretty time consuming.

Cesar,  This is probably a non trivial task.  I've done very similar things but this was all through the back end in SQL.  I know Lou Davis and Joe Noll (both post on here) have the skills to do this.  I would offer but I'm not a consultant anymore.  Maybe someone from Sage has an 'easy' idea.  We recently did something similar but in our case it was moving the items to EACH from PACK unit of measure.  It was pretty time consuming.

Thanks John. I ran it by Sage already trying to find an easier way to handle this, or maybe a utility but they also suggested doing it through the back-end and then update all tables associated. I will work with our dev team to come up with a plan, thanks for providing feedback. Cheers! Cesar Varela.