When entering serial numbers on the Inventory Management page, if a serial number is assigned to the wrong Item Name (whether by user error or based on info from previous system), the only option is to delete that serial number and re-add it under the correct Item Name. However, the system does not allow you to re-use a serial number that has ever been used in order to maintain the integrity of the tracking and reports.
Would it be possible to allow the serial number to only be re-used when the serial number has been removed with the Reason of Error Entry? This would allow it to be a legitimate "error entry" and the user to correct it fully and to maintain accurate information with their On Hand items.
To amend my comment, yes, should only be reused if Returned or Deleted, not when sold. However, I'd like more visibility in inventory of serial # status' if Sold or Returned (including reason) and if sold then to show the Case# it was posted on and the date posted and to be able to click on the case if needed to go directly into the case. It is cumbersome to figure out a query to tell me this tracking information. Inventory needs a BOOST to be comparable with other database systems.
Serial #s should always be able to be reused NO MATTER the reason, because maybe you find it, and sometimes the manufacturer sends it back to you repaired.