Until very recently we used the Generic Description on the item inventory card as a top-level category for items, and we used the Short Name on the same card for the second-level category.

Categories inside categories

Categories inside categories

Sometimes we wanted to see how many items we had in each subcategory. A SQL query to show that is:

[sql]
select itmgedsc,itmshnam,count(*)
from dbo.iv00101
group by itmgedsc,itmshnam
order by itmgedsc,itmshnam;
[/sql]

We used that listing to find misspellings, plan for new items, and as a basis for other reports.

Sample result

Sample result

Hope you find this useful!

Leave a Reply

Your email address will not be published. Required fields are marked *

 characters available