How to update a part quantity in many EM's

Legacy Contributor

Is there an easy way to update the quantity, by a percentage, of a part in many EM's without going into every EM?

mseppanen

Are you meaning that it was found that some material initially used 10 gallons per use, but now you need 11 gallons in reality to account for scrap?



Although utilizing a SQL Update is not ideal, it is an option. Instead of modifying the QtyPer, you could simply increase the Scrap % from where it is now, as it seems that you are accounting to waste material. Adjusting Scrap % is also cleaner than touching your user input variables of QtyPer or if using Dimensional Inventory touching the Length and Width fields.



Beware that there are 2 variants of Scrap % in the system. One is PPM (technically Parts per Hundred) and the other is Utilization Percentage, and they function VERY differently in the system.