MPI_0209 End of Day Processed Payrolls Report

This topic contains specific information about the MPI_0209 End of Day Processed Payrolls report. It includes explanations about the Report Properties dialog pertaining to this report.

For more information, see The Report Properties Dialog.

Overview

Use this report as a tool to track which payrolls were processed for the day, which in turn allows you to ensure that specific payroll(s) get delivered. You can specify multiple process dates that occur between and including the beginning date and ending date, as well as define the hour considered as the “end of the day” for payroll.

Note: The default settings include “today” as the beginning date and 17 (which stands for 17:00 or 5:00 PM) as the payroll end-of-day. For example, if you run the report on Thursday using the default settings, the report will list payrolls that were processed between 5 PM Wednesday through 5 PM Thursday.

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® usually bases each report on one or the other: the date or the process number.

This report is based on the check date, with the default of today’s date.

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

  • Today
  • Yesterday
  • This Week
  • Last Week
  • Override Dates
  • Current Month
  • Previous Month
  • Current Quarter
  • Previous Quarter

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:

  • CCalendar
  • CInfo

Subtotals/Breaks

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

Figure 2-403: Subtotals/Breaks page

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

The default Sort Order is Process Day. Available sorts include:

  • Process Day
  • Company
  • Company/Process Day

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

  • Company Code
  • Process Day
  • Check Date
  • Delivery Method

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

  • Company Code
  • Company Name
  • Delivery Method
  • process
  • status
  • Check Date
  • Actual Process Date

Additional Formulas

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

Figure 2-404: Additional Formulas page

For more information about using additional formulas, see Additional Formulas. The formula for this report is explained below:

Payroll end of day time

Use this drop-down list to select the hour considered as the “end of the day” for payroll. Valid entries are 01 through 24.

The value represents the hour according to a 24-hour clock; for example, 17 represents 17:00 or 5:00 PM.

Delivery Method

Use this field to filter the results of the report. Enter a value that exactly matches a value entered in the [company] > Company Maintenance > Master Company Setup > SB Info tab > Delivery sub-tab >Service field. If the value of a company’s Service field:

  • Matches the value you enter for this formula, its payrolls are included in the report
  • Does not match the value you enter here, its payrolls are excluded from the report

Leave this field blank to display all payrolls, regardless of delivery service.

Display check box

Put a check in this check box to include a check box next to each line of the report. This allows you to print out the report and mark off each payroll that has completed.