How Do I Use the Labor Distribution Detail Report?

The Labor Distribution Detail report shows how templates are applied to time records. You can create the report from Payroll Close (PR197) by choosing Report Only in the Update field and Yes in the Labor Distribution Report field.

It is important to note that if you run Payroll Close (PR197) in Update mode and the Labor Distribution Report field set to No, you cannot get the report.

The report includes time records and the template applied. If the template is successfully applied, the new distributions print, along with the template information and salary percentages. If all the time record's earnings could not be distributed according to the labor distribution template, an error message appears. Refer to the following table.

PR197 Error Message Description
Labor distribution < 100%, time record activity/account used

When the total approved salary percentages are less than 100 percent, one payroll distribution is created for each approved labor distribution line and the remainder of the time record's earnings and hours is charged to the activity and general ledger account from the time record.

For example, the labor distribution template has three lines. Two lines are approved, each contains a salary percentage of 40 percent. The third line is unapproved and contains a salary percentage of 20 percent. Three payroll distributions are created. The first two are created from the approved lines, charging 40 percent of earnings and hours to the activity and general ledger account in the labor distribution line. The third distribution is for the remaining 20 percent of earnings and hours, but since the distribution line is not approved, it is charged to the activity and general ledger account in the time record.

No approved lines; time record's activity/account used

If no labor distribution templates exist for the employee in the time record, or any existing templates have an effective date in the future with respect to the time record date, one payroll distribution is created using the activity and general ledger account on the time record.

Only approved labor distribution lines are used to create payroll distribution records. If the most recent labor distribution template has no approved lines, the distribution is charged to the activity and general ledger account on the time record. Since previous approvals carry forward to new templates, it is not likely that all labor distribution lines would be unapproved.

Labor distribution end date < TR date; TR actvy/acct used If the end date in a labor distribution template line is earlier than the date of the time record, the distribution for the line reverts to the activity and general ledger account in the time record, since the template distribution line has expired.
No eligible labor distributions found; TR activity/acct used If no eligible labor distribution templates exist for the employee, or labor distribution templates are in the future with respect to the time record, the distribution reverts to the activity and general ledger account in the time record.
Expense for deduction code {0} did not follow pay If the company-paid deduction does not follow pay, the labor distribution template is not used.
Effort pct used but not approved; TR actvy/acct used If the planned effort percentage appears in the template distribution lines, but a particular distribution line's status is not approved, the planned effort distribution for that line reverts to the activity and general ledger account in the time record.
Effort pct < 100%; time record activity/account used If the total planned effort percentages in the approved distribution lines equals less than 100, the remaining planned effort reverts to the activity and general ledger account in the time record.
Note: 
  • If the activity and general ledger account combination from a labor distribution template line is invalid, the payroll distribution for that line will go to error suspense when the transaction is updated during General Ledger Distribution (PR198).

  • Earnings amounts and hours in the payroll distribution records will equal the amounts and hours in the time record from which the distribution records were created. Any rounding differences are accommodated in the last distribution record.