MPI_0801 GL Journal Entry Report

This topic contains specific information about the MPI_0801 GL General Ledger Journal Entry report. It includes explanations about the Report Properties dialog pertaining to this report.

For more information, see The Report Properties Dialog.

Overview

This report displays the general ledger information for all check dates between the dates entered when running the report.

Date Selection

In the Report Properties dialog, click on the Date Selection tab. The system displays the Date Selection page.

As explained in Date Selection, you can use Override Dates  to select specific check date/process number combinations. Millennium® bases most reports on one or the other: the date or the process number.

This report is based on the process number.

This report uses company-style default date ranges, which are:

• Most Recent Pay Period
• Current Month
• Current Quarter
• Year-to-Date
• Override Dates
• Quarters 1–4
  

Data Selection

In the Report Properties dialog, click on the Data Selection tab. The system displays the Data Selection page.

As explained in Data Selection, you can use this page to include company filters to narrow down the selected data for this report. If you want to create a filter, design it to access the following database tables:

• CInfo—Company information.
• CCalendar—Company calendar information.
• CJEntries—Company journal entries.

Subtotals/Breaks

In the Report Properties dialog, click on the Subtotals/Breaks tab. The system displays the Subtotals/Breaks page:

Figure 2-437: Subtotals/Breaks page

If you choose to customize groupings, you can select up to eight levels.

The default Sort Order is GLAccount. Available sorts include:

• GLAccount
• GL1Account
• GL1-GL2Account
• GL1-GL3Account
• GL1-GL4Account
• GL1-GL5Account
• GL1-GL6Account
  

This report allows eight categories in the Groups column. If you select Custom Sort Order , the groups in Available Groups are available:

Table 2-384: Available Groups

Company	GL2
Service Bureau	GL3
Credit/Debit	GL4
D/E/T Code	GL5
Check Date	GL6
GL1	Process

This report allows four categories in the Sorts column. If you select Custom Sort Order , the sorts in Available Sorts are available:

Table 2-385: Available Sorts

Company	Process
D/E/T Code	Description
Check Date	Account

Additional Formulas

In the Report Properties dialog, click on the Additional Formulas tab. The system displays the Additional Formulas page:

Figure 2-438: Additional Formulas page

Explanations of the additional formulas are as follows:

Detail Line 1–6