Low inventory by Category

JeromeKoehn · Post by **JeromeKoehn** » Tue Jun 21, 2016 8:57 am

Is there a way to get a report for low inventory by category, don't want to use by vendor or part #. If not I think this would be "VERY HELPFUL" What do you fellow users think?

ricmorin · Post by **ricmorin** » Tue Jun 21, 2016 9:09 am

Can you explain how this would be helpful in your case? What are your processes that make this desirable?

I usually group my parts by type and sort by number.

JeromeKoehn · Post by **JeromeKoehn** » Tue Jun 21, 2016 10:19 am

We have over $150,000 of inventory, 42 different categories, we buy from many different vendors. We have a min/max for inventory can't sped the time to look at every item to check if we need to re-order, so right now run a low inventory report by vendor. Not all things are bought from one vendor, we shop around. Example Filters I just want to see Filters, 90% are bought from NAPA but we use other vendors for are Semis, so to get this I need to run 2-3 different "Low Inventory By Vendor Reports" and then I get everything from the 2-3 vendors, just gets to be a lot of paper. Just a side note we are not 100% done with are min/max numbers for inventory. Hopefully this helps explain why we could use this report

ricmorin · Post by **ricmorin** » Tue Jun 21, 2016 11:16 am

I think I'm getting it. One more question: If you're not checking each items count before ordering, what are the reports used for? Are you using an electronic catalog(s)?

Sorry for so many questions, but often there is a current method in Manager not yet exploited.

Johnny5 · Post by **Johnny5** » Tue Jun 21, 2016 11:46 am

SOMETHING LIKE THIS ??

: LOW INVENTORY BY GROUPED BY CATEGORY; CATEGORY.jpg (136.75 KiB) Viewed 4772 times

JeromeKoehn · Post by **JeromeKoehn** » Wed Jun 22, 2016 5:53 am

That looks good, but I only need to pick 1 category at a time, I don't need all the categories to print out

JeromeKoehn · Post by **JeromeKoehn** » Mon Jun 27, 2016 12:13 pm

How do I get the above report? I just need one category at a time

Johnny5 · Post by **Johnny5** » Mon Jun 27, 2016 12:21 pm

I did not finish that report, I haven't been able to print just 1 category so I shelved it.

JeromeKoehn · Post by **JeromeKoehn** » Tue Jun 28, 2016 8:45 am

If I can't get just 1 category, ok.. but how do I get the report shown above with all categories?

Johnny5 · Post by **Johnny5** » Tue Jun 28, 2016 10:33 am

Exit Manager SE, run this on the HOST first, then run it on each workstation. http://www.m1faqs.com/fix/SE/LowInvCat.exe When complete, you will find a new report under the Inventory tab named "Low Inventory by Category". I structured the report so you easily select a specific category and print just those pages (print to screen first to do this.)

JD

JeromeKoehn · Post by **JeromeKoehn** » Wed Jun 29, 2016 9:15 am

John: Thanks, this will help a lot!!

Johnny5 · Post by **Johnny5** » Wed Jun 29, 2016 9:18 am

You are most welcome.

Low inventory by Category

Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category

Re: Low inventory by Category