Currently in order to search via UPC when checking in inventory, a spreadsheet export is used to lookup the product description so it can be copied into the pos search and selected. The next page requires another input of the description and then the inventory details can be filled out.
Is it possible to change the function of the search to use an index of selected fields from tables in order to expedite the checking in of inventory? Even if the index would only be periodically rebuilt, it would drastically decrease the amount time needed to check in inventory.