About Report Writer report

A Report Writer report is a customized report that you create in the Report Writer application to display General Ledger data. At the most basic level, a report is made up of lines going down the page (row) and columns going across the page (format). Formats also contain heading and report title information. You define rows and formats separately for ease of maintenance and greater flexibility in report creation.

Illustration: A report is made up of a row and format (columns)

With Report Writer, you can define three basic types of reports, referred to as Style 1, Style 2, and Style 3 reports. The style of the report is based on the kind of information that displays down the page in the rows of the report. This table shows the three different ways to organize a report:

Report type Rows display
Style 1 Accounts
Style 2 Organization level
Style 3 Organization level and accounts

Style 1 report

A Style 1 report lists accounts down the page. A Balance Sheet is a good example of a Style 1 report.


              
                                    LGE Corporation
                       Balance Sheet
                      January 31, 2000


                                         YEAR TO DATE
      Cash

     Cash-Savings                          $11,906,944
     Cash-Checking                           9,635,058
     Cash-Other                              3,999,435
     Cash-Payroll                            5,700,108
                                        --------------
     Total Cash                            $31,241,545

     Accounts Receivable

     Accounts Receivable-Trade              $5,589,120
     Accounts Receivable-Freight             1,010,235
     Intercompany Receivables                   33,745
     Employee Advances                          75,000
     Sales Tax Receivable                        4,500
     COBRA Retiree Accounts Receivable          37,850
                                        --------------
     Total Accounts Receivable              $6,750,450



            

Style 2 report

A Style 2 report lists organizational levels, such as accounting units, down the page. A Salary and Wage Analysis is a good example of a Style 2 report.


              
                                                         LGE Corporation
                                       SALARY AND WAGE ANALYSIS
                                          January   2000

                                   REGULAR                              VACATION
                                       PAY              OVERTIME         & SICK PAY          Total
    CORPORATE HEADQUARTERS       ------------           --------          ----------         ------- 

Corporate                               $20,066                $685              $1,008             $21,759
Administration                           7,941                 685               1,008               9,634
Human Resources                          9,265                 799               1,176              11,240
MIS                                       6,618                 571                 840               8,029
                                   --------------      --------------      -----------      ---------
      TOTAL CORPORATE                   $43,890              $2,740              $4,032             $50,662

    CLINICAL DEPARTMENTS
Administration-Pleasanton              $9,265                $799              $1,176             $11,240
Diagnostic Svces-Pleasanton             9,265                 799               1,176              11,240
Administration-Springfield             10,588                 913               1,343              12,844
Diagnostic Svces-Springfield            5,294                 457                 672               6,423
Patient Services-Springfield           13,236               1,142               1,679              16,057
                                   --------------      ------------      ------------     ----------
      TOTAL CLINICS                       $47,648              $4,110              $6,046             $57,804

            

Style 3 report

A Style 3 report lists a combination of accounts and levels down the page. An Income Statement report is a good example of a Style 3 report, because the accounts and accounting units being reported on change going down the page.


              
                                        LGE Corporation
                          Income Statement
                          January 31, 2000

                                     Year to Date        % of
                                          1998          Sales
                                     ------------       -----
       SALES

Sales-Prescription Drugs              $12,620,100          15 %
Sales-Non-Prescription Drugs           10,890,000          13
Sales-Clinic Services                  13,812,060          16
Sales-Hospital Services                39,387,163          47
Sales-Floral                              451,620           1
Sales-Gifts                               475,525           1
Sales-Restaurant                        3,125,475           4
Sales-Other                             2,000,000           2
Financial Revenue-BOE                   1,000,000           1
Miscellaneous Revenue                      15,780
Sales Discounts                            27,125-
Sales Returns & Allowances                  4,623-
                                   --------------      -------

       NET SALES                      $83,745,975         100 %
Cost of Goods Sold                    $43,871,865          52 %
                                   --------------      -------

      GROSS PROFIT                    $39,874,110          48 %

   OPERATING EXPENSES
Clinic Expenses                           $62,229
Hospital Expenses                       8,351,803          10
Administrative Expenses                 3,082,482           4
Retail Expenses                            53,585
                                   --------------      -------
   TOTAL OPERATING EXPENSES           $11,550,099          14 %