Processing inventory with over 100 items in catalog

I am working on an scenarios for IT support, where the equipment changes of status from available to in use to in repair, the equipment are filter by serial number, but I am realizing that is a very large scenario, how can i simplify it?

You should read the Guideline before posting to the Community.

I don’t understand from your current post what exactly you have done, what the situation is, and what you are having trouble with.