Listing of Sales and Qty Purchased by a Customer
 		Previous Topic  Next Topic 

Listing of Sales and Qty Purchased by a Customer



The following is a command that you can type in that will output the part sales history for a particular customer and quantity purchased. You need to follow the following instructions exactly.  All the text that is in Bold type will be the commands you are typing.


  1. At the main menu type in TCL <Enter>.  This will bring you to a colon (:).
  2. Type in the following command.  When you see a “_” it means to place a space in between the works.  You can change the dates in the select statement as needed.
  3. SP-ASSIGN_F0  (This will send the report to printer 0.  If you want it sent to a different printer, replace the 0 with the printer # you want to print out the report).
  4. At the colon (:) type in :SELECT_ORDER_WITH_BILLTO.NO_=_“9414862183”  <enter>

>SELECT_ORDER_WITH_DATE.ENT_>_”9/30/98”_AND_WITH_ DATE.ENT_<_”11/1/98”<Enter>

  1. After typing in the command and pressing enter you will be brought to a greater than sign “>”, this is normal.  Then type in this command.

>SORT_ORDER_BY_DATE.ENT_BY_PARTNO_BREAK-ON_DATE.ENT _TOTAL_QTY.SHIP_PARTNO_UM_TOTAL_EXT.PRICE_(P    (This report will output the information by the date and the by the part.

  1. This will print out your report.  When finished you will be brought back to a colon (:).  Type in “M” <Enter> to return to the main menu.

Hint:  In TCL when you type in a command the command is recorded in a memory that can be recalled again.  If you type in <Ctrl> “D” it will bring back the last command that you typed in.  If it has been some time since you last typed in the command you can type in the first word in the command string and then hit a <Ctrl> “A” and it will bring up the last command typed in using that first word.  By continuing to hit either <Ctrl> “D” or “A” you will keep bringing up the commands as they were typed in.