Inventory Searching

[virginia]

Hello Everyone!
We are wondering or asking maybe, if there is any way to search the inventory in Crystal more precisely. Recently we have needed to make changes to certain things or add notes to certain groups of inventory and it would be more helpful to have a search option similar to the reports screens. For example, I need to search and pull up every frame in inventory eye size 61 or larger and add a note to include Over Sized Lens Charges. Currently the only search bar pulls up for frame names. I'd like a screen that is more specific. There are times when we need to pull up "Petite" or "Men's Large". Obviously going through every manufacturer and frame brand will take a lot longer than if I can just select a list and have shown "Women's Sun". It would also help us know what to buy from frame reps when they come if we know we want to keep 15 Men's Large in the office all the time.

Does anyone know if this is already possible? Does anyone else handle this some other way?

Thoughts Please and Thank you!

[KizerOpt]

When I use the Search button on the inventory page (left side, below Restock, Remove, etc...) I can enter 'women' and it pulls a long list of frames where we have included 'women' in our description. Is that the Search you are using? The inventory search is not at all precise, searching for '61' brings up anything with 61 in it, including UPC codes. Our optician would also like better reports and search capability.

Karen

[Gina]

When searching inventory, the search will pull anything matches the text you include in that search. If you are looking for a something very specific, you can enter it as %petite%. Entering between the percent signs will narrow your search but it must be verbatim the way you have it entered in your inventory.