MPI_0504 Tip Allocation Report (hard-coded)

This topic contains specific information about the hard-coded MPI_0504 Tip Allocation (hard-coded) report. It includes explanations about the Report Properties dialog pertaining to this report.

Note: A “hard-coded” report is one that is not designed using Crystal Reports, but defined using code within Millennium® itself. Few reports are written this way; almost all reports in the system are written using Crystal Reports.

For more information, see The Report Properties Dialog.

Overview

This report displays the total tip allocation, by employee, for all checks between the starting and ending dates you enter. Along with the tip totals, the report also displays the totals for tipped hours, gross receipts, and allocated tips.

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 check date.

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. However, this report does not allow you to create a filter.

Subtotals/Breaks

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

Figure 2-421: Subtotals/Breaks page

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

The default Sort Order is DeptName. Available sorts include:

  • Dept Name
  • Dept ID
  • Name
  • ID

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

Table 2-361: Available Groups

CC1

CC2

CC3

CC4

CC5

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

Table 2-362: Available Sorts

Employee Name

Employee ID

Employee Clock

Employee SSN

Additional Formulas

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

Figure 2-422: Additional Formulas page

Explanations of the additional formulas are as follows:

Employee Line 1

Use this drop-down list to add one line of employee information to the report.

The valid entries include:

Table 2-363: Available formula values for employee lines

Employee SSN

Employment Type

Hire Date

Location

Employee Clock
Include Recalcs

Put a check in this check box to include recalculated payrolls.