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