Figure 42 shows a sample page from another source of data for the balancing rules—the Sales Commissions Detail report. This report is prepared monthly by the sales operations department. The report contains a list of all the invoices for which sales commissions are calculated for a given month.
At the end of each list of invoices for a given salesperson is a summary of calculated information, along with other information. The final line shows the amount of commissions that salesperson is owed, according to the sales operations department.
The several rules that analyze the lines on this report are illustrated in Basic Problems and Solutions and Advanced Problems and Solutions.
Figure 42 Sales Commission 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 MARYJANE INKSTERR(177) | INVOICE | INVOICE DATE | AMOUNT | STATUS
| | B7003003| 02/02/00 | 11800.00 | |
| | B7003420| 03/03/00 | 2700.00 | |
| | B7004009| 04/04/00 | 1500.00 | |
| | B7018700| 05/05/00 | 500.00 | |
+--------------------------------------------------------------------------------------------
| TOTAL SALES - THIS MONTH 16500.00 (PAID IN FULL}
| ADJUSTMENTS 0.00
| YTD SALES (INCLUDING THIS MONTH) 999879.00
| YTD COMMISSIONS PAID 0.00
| YTD COMMISSIONS OWED 39995.16
| COMMISSION PAYROLL AMOUNT 39995.16
|--------------------------------------------------------------------------------------------
Parent Topic |