Hey all, I'm using SyteLine cloud in a MT environment so our access to using SQL is limited.
I'm curious to know if anyone has a way to mass update a whole mess of serial numbers. We have about 500,000 units and associated records that have serial numbers that were entered incorrectly. They have a S or M in front of them, so a serial that should be "P123456" was entered as "SP123456". I'm not sure how this happened as it was before my time here.
The issue is that we need to update these to remove the leading 'S'. Is there a built in utility or other easy way this could be done?
