I have a BAQ that pulls in all our BOMs.
I’m wondering if someone knows of away to get like the top 100 most used BOMs.
Get Top 100 in Subquery options and limit to M type and w/e class your BOM parts reside in would be a good start…
1 Like
You need to base it on some transactional data. Either invoices or part transactions. In either case, you’d group on part number and sum the qty column. Then sort by that summed qty. As @CSmith mentioned, you’d limit to top 100. If that’s all you want… you’re done. If you want to use that to get other info, you’d make that subquery a CTE. Then use it in another one that gets you your final info.
1 Like
What’s your definition of “Most used”?
Used in the most other BOM’s? On the most number jobs? Quantity of parts transacted on that used that BOM? Number of times said parts are transacted upon regardless of qty?
Once you define that, you can start making a query to find that.
3 Likes
What I ended up doing is grouping it by the jobs that BOM part numbers were on and counting the group by part number.
Which does show overall the most used. I may want to set a date limit on it. Say over the last 3 years.
Not perfect but it may work for what I need. Thank you everyone.
2 Likes