Inventory parts, inventory and ordering

Report I am missing??

Report I am missing??

Postby Rich » Thu Oct 22, 2015 6:08 am

We are running 6.6.8.

Its that time of the year and I would like to get some common wiper blades into the shop. We always get them from CarQuest, line code is generally CWP. There has to be a report I can run to show the CWP parts I have sold...isn't there?

I have tried Reports, Inventory, Non stock parts purchased. they are sorted by Category. :evil:

Please tell me that I am missing something. I can not believe there is not a way to search sold parts, not in inventory, by at least vender. By Line code would be great.
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Report I am missing??

Postby ricmorin » Thu Oct 22, 2015 6:30 am

My answer to this would depend on whether you have these wipers in inventory or non-stocking. If the numbers are in inventory, you can search them in the Inventory module and refine by line code, then check the sales of each. If not, then the Non-Stock Parts Purchased report would be what I would use, however, there is no line code there. It is refined by Category, though, which may help.

This is why every part purchased here goes into inventory. This gives us greater flexibility.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5268
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Report I am missing??

Postby Rich » Thu Oct 22, 2015 6:41 am

OK, just what I thought. Crap (can I say that?) I don't have time to enter category everytime. And these parts are not in inventory. Guess I will just wing it.
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Report I am missing??

Postby ricmorin » Thu Oct 22, 2015 7:04 am

Crap. Yeah, I guess you can say that.

In cases where I don't have or can't get history sales, I ask my vendor for a popularity list and go by that for the first year, then I have enough data to further refine the stocking list.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5268
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Report I am missing??

Postby Rich » Thu Oct 22, 2015 8:05 am

That does appear to be my only option. :cry:
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Report I am missing??

Postby liljoe » Thu Oct 22, 2015 12:11 pm

Can your supplier not pull up a report on your purchases for that? I know we have had reports like that for various items provided by our vendors.
Working hard to prove the Green Team can do it with the best of 'em.
User avatar
liljoe
1500 Club Master Plus Contributor
1500 Club Master Plus Contributor
 
Posts: 1565
Joined: Thu Sep 21, 2006 6:27 am
Location: Mentally: outer space. Physically: Alabama

Re: Report I am missing??

Postby Rich » Thu Oct 22, 2015 12:17 pm

Yes he can. Just kinda thought it was a pretty basic report, hoped to do it in house.
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Report I am missing??

Postby ricmorin » Thu Oct 22, 2015 12:24 pm

The problem I find with the supplier provided popularity reports is it usually doesn't match what's popular with us exactly. Good place to start, though.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5268
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Report I am missing??

Postby JeromeKoehn » Fri Oct 23, 2015 5:28 am

Rich:
I'm new to Mitchell, coming from a retail business where inventory reports are very important, I would like your feed back on a couple reports I have if you could e-mail me your fax # I'll sent them to you and see what you think. Thanks
Jerome@rahnfuels.com
JeromeKoehn
25 Club: Starting Contributor
 
Posts: 46
Joined: Thu Sep 24, 2015 6:29 am

Re: Report I am missing??

Postby Rich » Fri Oct 23, 2015 6:15 am

On the way!
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Return to Inventory / Purchase Orders

Who is online

Users browsing this forum: No registered users and 1 guest