Sort Receiving by Part Number
Previous Topic  Next Topic 

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