General Ledger Report Writer

The General Ledger (GL) Report Writer lets you produce financial reports based on user-defined hierarchies on any GL segment.

Introduction
Introduces the GL Report Writer.

Implementing GL Report Writer
Describes the steps required to implement the GL Report Writer.

Setting Up Report Components
Describes the main components of GL Report Writer reports.

GLRW Budgets
Create and maintain budget data used in GL Report Writer reports.

Defining Reports
Define the appearance of GL Report Writer reports.

Running Reports
Use Run Report to generate a report.

Checking Reports for Errors
Check the report definition for inconsistencies or errors.

Managing Report Images
Run inquires on report images.

The GL Report Writer lets you run financial reports previously created in an earlier version of a QAD ERP application, and lets you produce financial statements not supported by structured reports. You can report on transactions in the official layer of the current domain, and in the base and transaction currencies.

Note: You cannot use the GL Report Writer to report on transactions in the statutory currency.

The function uses GL data from COA elements (excluding SAFs) and entities as the basis for reporting. This gives you the flexibility to define your financial reports based on the criteria you set.

The GL Report Writer uses its own set of budget data that can be defined using GLRW Budget Maintenance (25.17.4.1), and retrieves actuals data from the posting history table.

Note: GLRW Budget Maintenance is used as the basis for GL and budget reporting for accounts, sub-accounts, cost centers, and projects, and for GL Report Writer reports alone. Another function, Budget Create (25.5.1.1), lets you create GL budgets for groupings of accounts for a single entity or for multiple entities with the same shared sets. See Budgeting.

The GL Report Writer uses its own set of database tables, based on account balance information from standard general ledger tables, and based on transactions in the official layer only. The GL Report Writer tables store financial balances, rather than individual GL transactions. The system retrieves pre-calculated information rather than making calculations when running the report. As a result, the system generates reports faster.

GL Report Writer Information Flow illustrates the flow of information from the GL transaction tables to the GL Report Writer tables and to the reports you create.