Time Registration for Holidays in Microsoft Dynamics AX 2012

In Microsoft Dynamics AX 2012 R2 and R3 Time and Attendance functionality can be used to setup in advance to pay a worker for planned company holidays using absence profiles. To setup the Absence Time profile complete the following steps

Time Registration: Time Entry for Holidays

The profile calendar is used to apply a specific work time profile to one or more workers on specific dates. During the holidays, an Absence time profile can be applied to all workers who will be absent. For hours worked, a Holiday time profile is created and assigned a special Holiday pay agreement.

The path to Time profiles setting in Microsoft AX 2012 is Human resources > Setup > Time and attendance > Time profile > Profiles

Absence Time Profile

Absence payable hours are the hours with the regular pay.

In our example, the Absence time profile has straight 8 hours with no break for lunch.

The path to the Approve form in Microsoft AX 2012 is Human resources > Common > Time and attendance > Approve

When a worker has a day off for a holiday, the Absence profile can be applied by manager on the Approve form. Then the workers get 8 straight hours recorded. For the Paid holiday, the Absence code will be selected as paid (Reference = PDO as Paid Days off) and the Job identification as holiday:

Note: no pay agreement is linked to the Absence profile.

Holiday Profile and Pay Agreement

Holiday worker day profile is a regular profile but it has a Holiday pay agreement assigned to it. If a company uses the open profile (24 hours), the Holiday profile might look as following:

Usually, if a worker clocks in his time during a holiday, special pay agreements are applied for the hours worked. The path to Pay agreements setting in Microsoft AX 2012 is Human resources > Setup > Time and attendance > Payroll > Pay agreements. In this example, when a worker works on a day that is considered a holiday, 8 hours are paid for the holiday day as well as double time for any actual work time, which is considered overtime calculation.

This is how standard time is set with the pay type for double pay:

Additionally, the premium of 8 hours can be setup for Holiday pay (General tab -> Fixed quantity fields section -> Use fixed quantity checked, constant = 8):

In combination with other days of the week, the overtime calculation for the whole week is based on the Holiday pay agreement. The agreement is set with a Pay adjustment that makes overtime calculated based on the total of regular time and time worked during the holiday:

With the adjustment pay type to offset overtime to the regular pay type:

Have other Microsoft Dynamics AX inquiries or needs? Visit our Help Desk for AX page to see how our experts can help!

For more information please contact Ellipse Solutions at info@ellipsesolutions.com or by calling our corporate office at (937) 312-1547.

  December Update for Dynamics AX 2012 R3