How Are Templates Applied During Labor Distribution?

The following rules determine which template is applied to imported transactions:

• The template with the most recent effective date with respect to the imported record's transaction date is used. For example, the transaction date is October 6. There are three templates, one effective September 1, one effective October 1, and one effective October 15. GM500 uses the template with the October 1 effective date.

• If there are multiple templates for an employee with the same effective date, the template that matches all data in the imported payroll record is selected. The following flow chart explains how the eligible template is selected:

  

• When an eligible labor distribution template is found, its lines are used to create labor distribution from eligible imported payroll records. The following rules apply:

  • Only template lines with an approved status are used.

  • When the salary percentages in approved template lines total less than 100 percent, the distribution reverts to the activity and general ledger account in the imported record.

  • If the end date in a labor distribution template line is earlier than the payroll record's transaction date, the percentage distribution for that particular line reverts to the activity and general ledger account in the imported record, since the template distribution has expired.

  • If the most recent labor distribution template has no approved lines, the activity and general ledger account in the imported record is used.

  • If no labor distribution templates exist for the employee in the imported payroll transaction or any existing labor distribution templates have an effective date in the future (with respect to the imported record's transaction date), one distribution is created using the activity and general ledger account in the imported record.

  • The posting date for the transactions is specified on GM500.

    Note: GM500 does not provide the capability to split payroll postings over multiple accounting periods (for example, a weekly payroll that falls in two accounting periods is not pro-rated and posted into two periods). In this instance, two batches should be imported for a payroll, one for each applicable accounting period in which the payroll falls.