by Chuck Hartle » Sat Dec 28, 2002 10:53 am
Turbo,
Try using this English statement for the
PARTS file
?SORT PARTS WITH CLOSED AND WITH POSTED1
?EQ "0" AND WITH Q.S. NE "0"
?BY EMP# BREAK-ON EMP# TOTAL E-SALE
?TOTAL E-COST TOTAL PROFIT
?ID-SUPP DET-SUPP (P)
This will give you an accurate total for each parts advisor before the job stack runs and clears out the daily PARTS file. By using the POSTED1 EQ "0", you clear out any "restored" tickets that someone may have restored to look at a previous invoice. When an invoice is restored, it is temporarily put back into the PARTS file for the day and cleared out that night with the job stack. Also, with 'Q.S. NE "0"' you also clear out any unwanted junk so you get just the true sales and credits for the day.
I am curious though, do you have PDA? If you go into PDA and go to the "M" MONTHLY REPORTS; report numbers 15,16,17 are awesome reports that show you the gross sales, gross profit, and credit history for the last 12 months plus your current month-to-date figures are updated each night the job stack is run. These are great, great reports to track your employee sales.
Jaz has some great suggestions for using RPG too, but here are a couple of others that will totally eliminate the need for experimenting with ENG and wasting paper.
1) Have your system administrator go into your UUP account for your individual logon in MAINT and have him/her give you access to "TCL" for your parts account. The prompt in UUP to turn this on is called "TCL Access" and they just need to highlight your -I account and save it to activate it for your logon. Then, at the Function Code, type "TCL" and you will go to a colon ":" prompt on your terminal.
2)Re-Term your current terminal by typing the following function code and prompts;
MENU TRM enter
1 enter
2 enter
8 enter
This will set up terminal up as a ADP120 terminal printer temporarily.
type 'MENU ENG' and you will be brought to the question mark prompt "?"
type in your english statement and at the end of it do not add the (N) or (P) for nopage or lineprinter.
After you hit enter, it will give you a page of your report. You have to hit enter each time you want the next page. To get out of the current report after you have looked at a sample of your english statement, simply hold the CONTROL key and E key to get back to the colon. If you have a PC or a slave printer and you feel you have a good English report, hit the print screen button to capture the statement before hitting "ENTER"
3) To Re-Term your terminal back to it's original setting, type the following;
MENU TRM enter
1 enter
1 enter
4 enter
19 enter
The 4 and the 19 could be different on your system. The 4 (or third prompt will give your the proper terminal type (such as ADP 220; MT502; MT503 terminal type, and the 19 is for NONE for your slave printer setting, this could be 17 or 18 depending on your software release.
Then, simply type MENU and you are back at the FUNCTION CODE prompt. This is, by far, the easiest way to experiment with ENG statements and watch them on the screen without losing paper.
Chuck Hartle'
PartsEdge