Reynolds & Reynolds top selling parts

Reynolds & Reynolds top selling parts

Postby TOLPARTSMGR » Wed Nov 23, 2016 3:35 am

Anyone know how I can print a report that shows top 50 or top 100 selling parts in inventory.
TOLPARTSMGR
 
Posts: 8
Joined: Sun Jan 04, 2015 6:18 am

Re: Reynolds & Reynolds top selling parts

Postby vtecmanager » Wed Nov 23, 2016 1:23 pm

REPORT NAME: *** RANKING REPORT - TOP PARTS SALES YTD
FILE NAME PROD.MASTER
REPORT TYPE: SORT
SORT FIELDS: YTD
SORT SEQ. D
SELECTION CRITERIA:
FIELD CONDITION VALUE
.YTD >= 1
COLUMN HEADINGS FOR REPORT:
YTD;PART-INFO;BIN1;SRC;QOH
FIELDS TO BREAK ON
CHANGE PAGE AT EACH BREAK

Hope this helps. You have to build this in report generator.
20 years in the biz...and still learning.
vtecmanager
 
Posts: 31
Joined: Wed Oct 27, 2004 12:00 am
Location: Atlanta, GA

Re: Reynolds & Reynolds top selling parts

Postby Mike Nicholes » Wed Nov 23, 2016 3:15 pm

You can also have the report list all the parts with sales over "XY" numbers of pieces in the last 12 months. this list can be sorted by activity or by bin, or any other common criteria you might have.

Mike
Mike Nicholes
 
Posts: 215
Joined: Wed Feb 23, 2000 12:00 am

Re: Reynolds & Reynolds top selling parts

Postby dave1959 » Tue Nov 29, 2016 9:16 pm

3 PIECE SALES....................(2233)
dave1959
 
Posts: 38
Joined: Wed Sep 12, 2007 12:00 am


Return to Parts Managers

Who is online

Users browsing this forum: Google [Bot] and 36 guests

cron