I just spent the better part of two days serializing my inventory. My fingers are numb--and I didn't type many serial numbers at all.
I did a physical inventory of the entire department first. Then I scanned most of the serial numbers (everything in the warehouse) and exported the file to Excel. I sorted by ILC and went down the list in both HQ and SO to check that the on-hand and the number of serial numbers matched. When they did, I changed the item type in HQ from Standard to Serialized then went to SO, did the same thing and then entered the serial numbers.
When the numbers didn't match, I noted the over/short and went in search of the 'short' serial numbers. I found most of them on the showroom floor. Again, I checked my s/n:on-hand ratio and where it was 1:1 I entered the serial number(s).
In a few cases, I found that I had an extra serial number for an item that was actually sold. I had also counted these items during my physical inventory. So I changed the quantity on-hand, deleted the offending s/n and continued.
During all of this, my 'sync s/n:on-hand' switch was set to OFF in my SO Config.
After changing a few quantities, I thought it'd be nice to issue a 501 from HQ and get the item counts in sync.
Big Problem. Now, everything with a serial number shows double on-hand in HQ. I tried going back to SO, setting my 'sync s/n"on-hand' to ON and then re-issuing the 501. No luck.
My SO database is correct. My HQ database shows the wrong quantities everywhere, but with the correct s/n listing.
Is there a way for me to fix this without blowing away my HQ database?
Thanks, Tom