Hi, everybody.
My environment is : RMS 2.0.0126, connection of every store once per hour. Almost only serialized items in the stock.
I found out that one store input wrong serials on a whole batch of products. (different products, not related and not serial numbers close to each other so have to modify one by one)
I want to modify that, and I am trying to find the options I have to do so.
I was thinking :
- In the Store Manager, I can delete a serial number, then add a new one. Delete a serial also remove one quantity of the product from the stock, while adding one adds one quantity. It sounds like a good solution to me, but are there some drawbacks? Will the HQ update that automatically on the next connection?
- Changing the serial number with a SQL statement. In the Serial table, just change the serial number... but after checking the tables, I found out that the serial number is also in other tables. Do I have to modify the serial number in ALL the tables? What if I forget one? How will it be updated in HQ after I do that in the store DB?
Other options you can see, or anything I am wrong about?
Sincerely.
