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.
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 %