Sort Receiving by Part Number

Sort Receiving by Part Number

Sort statement used for printing a Vendor specific report, by manufacturer, with a date range, that will print the part numbers from receiving with their quantities and costs.

Go into TCL from the Main Menu:

Then type colon:

SORT RCV.PARTS WITH VENDOR "vvv" AND WITH MFR "mmm" AND WITH LOCATION "#" AND WITH RECEIVE.DATE >= "xx/xx/xx" AND WITH RECEIVE.DATE <= "xx/xx/xx" BY RECEIVE.DATE BY PART.NO BREAK-ON RECEIVE.DATE QTY.RCV PART.NO COST TOTAL EXT.COST ID-SUPP