The payroll user has been thinking about the congratulations that he received from the managing director of INTRAC. Because of the quick implementation of rule ARWARN02 from Problem 2, he has saved the company time and money. With this quick success, the payroll user moves ahead to work on to Problem 3.
There is one more simple check that the payroll department will perform on the Sales Commissions Detail report. In this rule, a new feature of Control-M/Analyzer is introduced — the ability to summarize extracted information.
Look again at a sample page of the report.
Figure 69 Sales Commissions Detail Report
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9---
INTRAC INC. SALES OPERATIONS DEPARTMENT DATE 10/10/01 TIME 23:45 PAGE 4
S A L E S C O M M I S S I O N S D E T A I L FROM 10/10/01 TO 10/10 01
| SALESPERSON HARVEY J. JONES (197) | INVOICE # | INVOICE DATE | AMOUNT | STATUS
| | CJ39394 | 02/02/00 | 2040.00 | COLLECTION|
| | CJ98443 | 03/03/00 | 245.00 | |
| | MJ24545 | 04/04/00 | 10344.40 | |
| | RJ10030 | 01/02/00 | 5329.39 | |
| | RJ12233 | 02/02/00 | 5000.00 | |
| | RJ30021 | 03/02/00 | 16670.10 | |
| | RJ32991 | 02/03/00 | 30300.44 | |
| | RJ33939 | 03/03/00 | 900.25 | |
| | RJ38001 | 04/04/00 | 1000.23 | |
| | RJ93043 | 04/04/00 | 415.89 | |
+--------------------------------------------------------------------------------------------
|TOTAL SALES - THIS MONTH 72245.70 (PAID IN FULL)
|ADJUSTMENTS -5800.70
|YTD SALES (INCLUDING THIS MONTH) -127879.00
|YTD COMMISSIONS PAID 0.00
|YTD COMMISSIONS OWED -5115.00
|COMMISSION PAYROLL AMOUNT 5115.00
---------------------------------------------------------------------------------------------
Parent Topic |