Producing a ledger transaction report

Ledger

Specify the ledger code if the report contains only transactions from a specific general ledger. Optionally, you can click the search icon to select an existing ledger. If you leave this field blank, then the transactions from all ledgers are included in the report.

You can also restrict the report based on these fields:

• Account range
• Transaction date
• User ID
• Source application or module

Sort Order

Select the sort order for the report.

Consolidation Separator

Select this check box to print two separate consolidation reports. The first report is for transactions which can be consolidated and the second report is for transactions where consolidation is not allowed. These reports contain separate titles and totals.

Description

Provide a description for the job. You can also specify when to run the job.

Printer

Specify the printer to be used for printing reports. You can print on any device when you print a web page.

Print Header Page

Select this check box to include the header page when printing.

Add to My Reports

Select this check box to add the report in the My Reports grid in the Home screen.

To be included in the reporting process, the query must contain one or more entities. If you specify the search profile and query details, then the search profile details are overridden.

Dynamic Query

Specify a record to be processed or click the search icon to select an existing record. When the same Dynamic Query job is run multiple times, a different set of records is processed.

Note: Specifying a value in this field disables the Query Result field and vice versa.

Query Result

Specify a record to process or click the search icon to select an existing record. When the same Query Result job is run multiple times, the same set of records are processed.

Retain Query Result

Select this check box to retain the result stored in the database after the job is completed.