Previous Topic: 6.1.1.1 Consolidated Invoice Report Features

Next Topic: 6.1.1.3 Running the Consolidated Invoice Report

6.1.1.2 Sample Consolidated Invoice Reports


The figures in this section show samples of the Consolidated
Invoice Report in each of the three summary types:
computation code, invoice category, and cost center.  In
addition, each sample has been produced with a different set
of options (including line item formats) which are described
in the accompanying text.

COMPUTATION CODE INVOICE

The Computation Code Invoice presents line items at the
individual billing element level.  This is the most detailed
pricing level provided by CA MICS Accounting and Chargeback.

The INVCCAT line item format provides lines designated by
invoice category descriptions with values at the individual
billing element (COMPCODE) level.  The columns are:  major
invoice category (nXXX), invoice category code, invoice
category description, computation code (in parenthesis),
billed quantity, rate, units of measure, and charge.  This
sample invoice also utilizes the cost center subtotal option
and several footing options including budget information and
year-to-date totals.  Refer to Figure 4-44 for an
illustration of the options used to create this sample.


                                                                  COMPLEX REPORT                                      INVOICE                                                    MONTHLY INVOICE FOR JUNE 2002  TO:  MR. JOHN SMITH, GROUP VP                            DIVISION:  ACME                                     INVOICE NO. -       3       ACME PRODUCTS DIVISION                                                                                  PAGE NO. -   1                                                                                                               BILL DATE - 07/30/02                                                                                                               STATUS: BILL  CATEGORY RESOURCE UTILIZED                                       QUANTITY       RATE            UNITS            CHARGES    ----   ---------------------------------------------------- ------------- ------------- ----------------  -----------------    1XXX   PROCESSOR HARDWARE      RESEARCH           1100 CENTRAL PROCESSOR(S)                     (0023)       759.760      $0.1000  TCB SECONDS                 $75.98           1100 CENTRAL PROCESSOR(S)                     (0041)       100.000      $0.2500  KCORE HOURS                 $25.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $100.98      SALES           1100 CENTRAL PROCESSOR(S)                     (0023)       911.200      $0.1000  TCB SECONDS                 $91.12           1100 CENTRAL PROCESSOR(S)                     (0041)       200.000      $0.2500  KCORE HOURS                 $50.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $141.12           1100 VALUE-ADDED TAX (VAT)                                 242.100      %0.1000  DOLLARS                     $24.21      RESEARCH           1200 CHANNELS                                 (0097)       200.000      $0.2500  1000 EXCPS                  $50.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                  $50.00      SALES           1200 CHANNELS                                 (0097)       400.000      $0.2500  1000 EXCPS                 $100.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $100.00           1200 INVOICE CATEGORY DISCOUNT                             150.000     (%0.0500) DOLLARS                     ($7.50)    7XXX   INVENTORIES      RESEARCH           7200 DISK VOLUMES                             (1820)       291.355      $1.0000  MEGABYTE HOUR              $291.36                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $291.36      SALES           7200 DISK VOLUMES                             (1820)       301.633      $1.0000  MEGABYTE HOUR              $301.63                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $301.63           7200 VALUE-ADDED TAX (VAT)                                 592.990      %0.1000  DOLLARS                     $59.30  

 Figure 6-1a. Computation Code Invoice in INVCCAT Format (Part 1 of 2)

   9XXX   DIFFERENTIAL CHARGES      RESEARCH           9400 MINIMUM CHARGE                           (JMIN)                                                        $620.04                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $620.04      SALES           9400 MINIMUM CHARGE                           (JMIN)                                                        $434.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $434.00      RESEARCH           9500 ZONE DIFF CHARGE                         (ZDIF)                                                       ($157.50)                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                ($157.50)      SALES           9500 ZONE DIFF CHARGE                         (ZDIF)                                                       ($221.45)                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $221.45  -------------------------------------------------------------------------------------------------------------------------------           TOTAL CHARGES                                                                                             $1,736.19           VOLUME DISCOUNT                                                                                            ($120.07)                                                                                                              -----------------           SUBTOTAL                                                                                                  $1,616.12           5.00% VAT                                                                                                    $80.80                                                                                                              -----------------           SUBTOTAL                                                                                                  $1,696.92                                                                                                              -----------------           NET CHARGES                                                                                               $1,696.92                                                                                                              =================  -------------------------------------------------------------------------------------------------------------------------------             BUDGET AUTHORIZATION                                                                                      $2,000.00           VARIANCE AMOUNT                                                                                             $303.08             YEAR-TO-DATE CHARGES                                                                                      $7,434.27           YEAR-TO-DATE BUDGET AUTHORIZATION                                                                        $17,700.00           YEAR-TO-DATE VARIANCE AMOUNT                                                                             $10,265.73  -------------------------------------------------------------------------------------------------------------------------------           NET CHARGES                                                                                               $1,696.92           ZERO BALANCE ADJUSTMENT                                                                                      $10.83                                                                                                              -----------------           ADJUSTED CHARGES                                                                                          $1,707.75                                                                                                              =================           YTD CHARGES                                                                                               $7,434.27           YTD ZERO BALANCE ADJUSTMENT                                                                                 $100.10                                                                                                              -----------------           ADJUSTED YTD CHARGES                                                                                      $7,534.37                                                                                                              =================

Figure 6-1b. Computation Code Invoice in INVCCAT Format (Part 2 of 2)                                                 

 Figure 6-1b.  Computation Code Invoice in INVCCAT Format (Part 2 of 2)

INVOICE CATEGORY INVOICE

The Invoice Category Invoice presents a single line item for
each invoice category (individual billing elements have been
summarized to their associated invoice categories).  The
lines are designated by invoice category codes and their
associated descriptions.  Thus, the invoice category type
invoice is one "level" less detailed than the Computation
Code type.

The CHARGE line item format prints the following columns:
invoice category code, invoice category description, and
charge.  This sample invoice also utilizes the invoice
category group subtotal option and several footing options
including budget information, year-to-date totals, and a
footnote.  Refer to Figure 4-46 for an illustration of the
options used to create this sample.

                                                          COMPLEX REPORT                                      INVOICE                                                    MONTHLY INVOICE FOR JUNE 2002  TO:  MR. JOHN SMITH, GROUP VP                            DIVISION:  ACME                                     INVOICE NO. -       3       ACME PRODUCTS DIVISION                                                                                  PAGE NO. -   1                                                                                                               BILL DATE - 07/30/02                                                                                                               STATUS: BILL  CATEGORY RESOURCE UTILIZED                                       QUANTITY       RATE            UNITS            CHARGES    ----   ---------------------------------------------------- ------------- ------------- ----------------  -----------------    1XXX   PROCESSOR HARDWARE      RESEARCH           1100 CENTRAL PROCESSOR(S)                     (0023)       759.760      $0.1000  TCB SECONDS                 $75.98           1100 CENTRAL PROCESSOR(S)                     (0041)       100.000      $0.2500  KCORE HOURS                 $25.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $100.98      SALES           1100 CENTRAL PROCESSOR(S)                     (0023)       911.200      $0.1000  TCB SECONDS                 $91.12           1100 CENTRAL PROCESSOR(S)                     (0041)       200.000      $0.2500  KCORE HOURS                 $50.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $141.12           1100 VALUE-ADDED TAX (VAT)                                 242.100      %0.1000  DOLLARS                     $24.21      RESEARCH           1200 CHANNELS                                 (0097)       200.000      $0.2500  1000 EXCPS                  $50.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                  $50.00      SALES           1200 CHANNELS                                 (0097)       400.000      $0.2500  1000 EXCPS                 $100.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $100.00           1200 INVOICE CATEGORY DISCOUNT                             150.000     (%0.0500) DOLLARS                     ($7.50)    7XXX   INVENTORIES      RESEARCH           7200 DISK VOLUMES                             (1820)       291.355      $1.0000  MEGABYTE HOUR              $291.36                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $291.36      SALES           7200 DISK VOLUMES                             (1820)       301.633      $1.0000  MEGABYTE HOUR              $301.63                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $301.63           7200 VALUE-ADDED TAX (VAT)                                 592.990      %0.1000  DOLLARS                     $59.30        9XXX   DIFFERENTIAL CHARGES      RESEARCH           9400 MINIMUM CHARGE                           (JMIN)                                                        $620.04                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $620.04      SALES           9400 MINIMUM CHARGE                           (JMIN)                                                        $434.00                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $434.00      RESEARCH           9500 ZONE DIFF CHARGE                         (ZDIF)                                                       ($157.50)                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                ($157.50)      SALES           9500 ZONE DIFF CHARGE                         (ZDIF)                                                       ($221.45)                                                                                                              -----------------      DEPARTMENT TOTAL                                                                                                 $221.45  -------------------------------------------------------------------------------------------------------------------------------           TOTAL CHARGES                                                                                             $1,736.19           VOLUME DISCOUNT                                                                                            ($120.07)                                                                                                              -----------------           SUBTOTAL                                                                                                  $1,616.12           5.00% VAT                                                                                                    $80.80                                                                                                              -----------------           SUBTOTAL                                                                                                  $1,696.92                                                                                                              -----------------           NET CHARGES                                                                                               $1,696.92                                                                                                              =================  -------------------------------------------------------------------------------------------------------------------------------             BUDGET AUTHORIZATION                                                                                      $2,000.00           VARIANCE AMOUNT                                                                                             $303.08             YEAR-TO-DATE CHARGES                                                                                      $7,434.27           YEAR-TO-DATE BUDGET AUTHORIZATION                                                                        $17,700.00           YEAR-TO-DATE VARIANCE AMOUNT                                                                             $10,265.73  -------------------------------------------------------------------------------------------------------------------------------           NET CHARGES                                                                                               $1,696.92           ZERO BALANCE ADJUSTMENT                                                                                      $10.83                                                                                                              -----------------           ADJUSTED CHARGES                                                                                          $1,707.75                                                                                                              =================           YTD CHARGES                                                                                               $7,434.27           YTD ZERO BALANCE ADJUSTMENT                                                                                 $100.10                                                                                                              -----------------           ADJUSTED YTD CHARGES                                                                                      $7,534.37                                                                                                              =================

 Figure 6-2.  Invoice Category Invoice in CHARGE Format

COST CENTER INVOICE

The Cost Center Invoice presents line items summarized across
invoice categories to the cost center level specified in the
Invoice Format Options.  A line item is provided for each
unique cost center value for which charges were incurred (in
the sample report, line items are specified for the cost
center level titled "APPLICATION").  Subtotals may be
requested at another cost center level (in the sample report,
subtotals are provided for the cost center level titled
"DEPARTMENT").  Note that the cost center levels specified do
not have to be either contiguous or in numerical order,
however, some combinations may produce "meaningless" reports.

The BUDYTD line item format provides both budget and year-to-
date information for each line item.  The columns are:
current month charges, current month budget, variance from
current month budget, year-to-date charges, year-to-date
budget, and variance from year-to-date budget.  Refer to
Figure 4-48 for an illustration of the options used to create
this sample.

                                                          COMPLEX REPORT                                      INVOICE                                                    MONTHLY INVOICE FOR JUNE 2002  TO:  MR. JOSEPH DOKES, GENERAL MGR.                  DIVISION:  AMALGAMATED                                  INVOICE NO. -       4       AMALGAMATED MECHANISMS, LTD.                                                                            PAGE NO. -   1                                                                                                               BILL DATE - 07/31/02                                                                                                               STATUS: BILL DEPARTMENT / APPLICATION                                 MONTH CHARGES      MONTH BUDGET     VAR %       YTD CHARGES      YTD BUDGET  VARIANCE ----------------------------------------- -----------------   --------------   --------  ----------------- ------------- -------- DEVELOPMENT   BATCH                                            $125.00           $5,700       97.8            $250.00       $11,400     97.8   TSO                                              $317.50           $5,000       93.6          $3,728.57       $17,000     78.1                                           -----------------   --------------   --------  ----------------- ------------- -------- DEPARTMENT SUBTOTAL                                $442.50          $10,700       95.9          $3,978.57       $28,400     86.0 PRODUCTION   CICS                                             $232.82                                      $3,663.43                                           -----------------   --------------   --------  ----------------- ------------- -------- DEPARTMENT SUBTOTAL                                $232.82                                      $3,663.43   ----------------------------------------------------------------------------------------------------------------------------------- TOTAL CHARGES                                      $675.32                                      $7,642.00 INVOICE CATEGORY DISCOUNTS                                .                                        ($5.59)                                           -----------------                              ----------------- SUBTOTAL                                           $675.32                                      $7,636.41 INVOICE CATEGORY SURCHARGES                         $10.10                                        $649.34                                           -----------------                              ----------------- SUBTOTAL                                           $685.42                                      $8,285.75 VOLUME DISCOUNT                                           .                                      ($520.07)                                           -----------------                              ----------------- SUBTOTAL                                           $685.42                                      $7,765.68 5.00% VAT                                           $34.27                                        $388.28                                           -----------------                              ----------------- SUBTOTAL                                           $719.69                                      $8,153.96                                           -----------------                              ----------------- NET CHARGES                                        $719.69                                      $8,153.96                                           =================                              =================     ----------------------------------------------------------------------------------------------------------------------------------- TOTAL BUDGET AUTHORIZATION                                          $10,700                                     $28,400 VARIANCE AMOUNT AND %                            $9,980.31                        93.3         $20,246.04                   71.3   ----------------------------------------------------------------------------------------------------------------------------------- NET CHARGES                                        $719.69                                      $8,153.96 ZERO BALANCE ADJUSTMENT                             $45.82                                         $46.65                                           -----------------                              ----------------- ADJUSTED CHARGES                                   $765.51                                      $8,200.61                                           =================                              =================

Figure 6-3. Cost Center Invoice in BUDYTD Format