AX7 T&A: Pay Agreement Configurations

Most often there are differences between employees within an organization like additional bonuses should be triggered if something happens or an extra pay type should be triggered for all working hours for some users. There are SO many different ways of giving payment it is some times overwhelming. I believe that this is where the AX solution shines. You can create any type of delimitation rule to solve any issue. Please challenge me if you have a nut to crack.

By using pay agreements delimitation you can create common pay agreements that can fit the entire organization, but keep a good record of what you are doing as these can grow to be pretty big. This is how I do it. If someone has an input on the matter. Please share! 🙂

The reason why I like to create one pay agreement for the entire or at least the majority of the organization is that often there are some common denominators and these might be changed now and again. So if you have one pay agreement you only have to change this once and not replicate it to the entire organization. I would love to see the opportunity of adding multiple pay agreements to a user in the future.

So I use the pay agreement to mainly work for the entire day (No time entered). Then I use the configuration of the profile and/or worker to trigger the different agreements.

I’d thought I would go through each of the parameters and give an example to what it can be used for, but you have to open your mind to the possibilities here. Often combinations of more then one delimitation can be used for the wanted effect.

There is a button on the form called Delimitations which get even more Advanced. I’ll go in to those in another post later as the functionality does not seem to be finished at this time.


Use this to add more or less than one pr. each working hour. I had a case where they needed to add 25% more hourly pay if the user worked flex hours. I used this on the Flex+ type with 0,25 of the standard hourly pay type.

If the times only apply during a certain time span. I don’t use these and let the profiles control the triggering.

This is often used if you only want to trigger the pay type from, to or between between a given interval. For instance a bonus is paid if the worker works more then 12 hours. You can easily create a stair case modeling of pay types by using this delimiter.

Date Interval:
If you have pay types triggered differently between certain periods like summer or winter you can use this. This is not for Public holidays or Things like that. That is what the “special” day is used for.

The seniority is calculated based on the seniority date on the employees time and attendance settings. The seniority date can differ from the hire date and is not a mandatory field, so make sure to fill this out before you use this feature. I believe the fallback will be to the employement start date.

Round off:
Pretty common stuff, but I have never used it. In Norway we normally don’t round off until the payment is done.

Count unit:
These are measures that are counted within a period. Meaning it is set to zero at the start of each period. If the count unit is between the min and max values the pay type is triggered. This is mostly used to limit the amount of transactions within a period.

Switch code:
This was mentioned in the Profiles setup as well. These are codes that are triggered by the users and can be used to switch to a secondary profile type. It can also be used to select what type of pay type to be triggered. I use this often for building up a “time-off” account (as opposed to using flex time) when the user should not have overtime but is outside the normal working hours. I then put this delimiter on the overtime records to get this to trigger. Often used in conjunction with a “Count unit” and a secondary factor if for example they get 1,25 for each overtime hour worked, but only up to 5 hours pr. week.


I use this A LOT! This is the manufacturing operations. If a user should get a premium for each hour he does an certain operation, then this is triggered. Customers love this as this is normally solved by using extra time sheets, and with this it just works by it self.

Project ID and activity:
I guess this could be used for standardized internal projects or if a customer pays extra for a special Project, but if a type of Project Activity or category should give a premium as standard across multiple projects; then the “Advanced delimitations” must be used.

This is the indirect activities of type “Jobs”. For instance some companies does not pay for union meetings.
I had a customer who would not allow contractors to have their time be posted to the systems waiting job. So they said that for all Contractors the Activity: “System job” should deduct 1:1 hour pay. This really increased the accuracy for their time registrations!

Absence code:
I use this a lot because some rules for payment of absence types often only apply to some types of workers. I use this as opposed to use the pay type settings directly on the absence code. I often use the “Advanced delimitations” for this as I can then trigger on a group level.

On Call Activity:
These are indirect activities of the type On Call. I use these for the Forman or Team leader permiums to be triggered if someone not normally in this position has to fill in during absence. The On Call is active for all working hours within the profile. I also use this when a person triggers his own permiums like emergency call outs, but then often with a fixed quantity.

I use this to trigger shift premiums for night or evening shifts. I often use “Advanced delimitations” if more then one profile triggers the same pay type.

Skill (with leveling):
Skills are set on the individual employee. I use this for Premiums related to a skill some times.

I use this for individual separation and multiple grouping of employees. You can also use skill for this purpose. The difference is that skill is leveled, and certifications can expire. I separate the worker types and special Premiums for this. So a user can for instance be a part of the manufacturer, hard laborer and forman, while another might not have the forman or hard laborer active. Both on the same pay agreement, but different terms.

Special day:
In the profile calendar you can determine special days. This does not need to trigger the “special pay agreement day type”, but could be a special Tuesday for some reason… Thus giving a special premium for that particular day.

Invert sign:
This gives a negativ amount of the pay type triggered.

Cancel payment:
If this checkbox is active the system post the cost, but does not create a pay transaction. So this is just for a costing perspective. As I don’t use the costing in time and attendance this doesn’t apply to my setup.

Hour rate / Piece work:
You can select both or one or the other.

Profile type:
I use this actively as I differentiate between 100% or 50% overtime payment in my profiles. You can also create your own type of profile types. I have had an example where the users working Friday after lunch got 1,25. In that case I used a special profile type of the type work and added a pay type with 0,25 extra for each of the hours worked on this profile type.

Go to the AX 7 – Time and Attendance guide page

AX7 T&A: Pay agreements

Pay agreements are the settings for what pay types or cost elements that should be generated based on the workers approved registrations, profile and calculation parameters.

Pay types:
First you have to create the Pay Types (Time and attendance > Setup > Payroll > Pay Types). If the ID in AX differs from ID in the external payroll system you can enter External Pay Type to translate the pay type to the correct type. You can also have to pay types in AX become have the same External pay type.


You can set up generic rates for the pay types by clicking Rates in the menu.


You can also go even more granular and set a rate for each worker by clicking Worker rates from the rates item.


The worker rates are in relation to the pay type generic rate.
You can use percentage variance from the generic pay type or set a specific rate.

There is also a job on the pay type rates form to do an all over pay increase (“Change pay”) by setting a percentage, amount increase or a direct new value. Running this will update the generic and corresponding worker rates.


Pay agreements:
The pay agreements are a header/line type of configuration. I try to keep as few pay agreements as possible. Preferably only one. I rather use delimitations to restrict for each employee grouping within the same pay agreement. The reason for this is that if you need to apply a new rule for everyone you just need to do it once.

Go to Time and attendance > Setup > Payroll > Pay agreement to create a new agreement.

You need to put in a valid period in the header to be able to use the pay agreement.


Pay agreement lines:
Keep in mind that the registered time and the profile limit the range of the payment type. So entering records should be taking in to account and cover all the different profiles. In the example below the pay type 1201 is generated for all standard time being triggered.


There is a section for filtering each wage type (Sat to “Standard time” in the example above). The relation between these and transactions from the profile calculation is set in the calculation parameters. Keep in mind that as a part of the standard configuration; overtime also triggers standard time. If you don’t want to do this, you can change this in the calculation paramters (Time and attendance > Setup > Calculation parameters).

The pay agreement lines has a day by day setup as well as a “Special day”. This is a setup done in the profile calendar that defines if a day is a special day. Christmas might fall on a Tuesday, so this is pretty important to notice.

Pay agreement lines delimitations:


As you can see there is a wide range of delimitations you can do and I’ll run through what I normally do in my next blogpost.

Go to the AX 7 – Time and Attendance guide page

AX7 T&A: Indirect activities

Indirect Activities is used for all other job types that does not involve absence, manufacturing execution, projects or project activities.

You can set up all you need for general tracking by just creating indirect activities. It is possible to set up costs for the different indirect activities. You can even set your own GL posting and financial dimensions, so you can get a lot of good financial data out of this. For instance this can be used to run costing for departments where you have people moving between departments and doing different work. It works very well, but I would recommend using the projects accounting module for proper internal cost tracking, as it is a lot more configurable and able to handle more aspects then just the employee hours.

First you need to create the categories. You can access these in Time and attendance > Setup > Indirect activity categories.


There are four types of indirect activities:

  • Job (General jobs and system tasks)
  • Break
  • Switch code
  • On Call

You can only have one type of activity within each category and each type activate/deactivate different parameters in the setup. You can also allow registration on the category by activating the registration for Time and attendance.

In AX7 you can also maintain all activities in a flat structure in the Indirect activities form (Time and attendance > Maintain indirect activities > Indirect Activities)

Job Activities:
There are some job activities created by the configuration wizard. These are the system specific jobs that are connected to a system function other then the type “Jobs”.

The system jobs are:

  • Clock in
  • Clock out
  • Start assistance
  • Stop assistance
  • Change pilot
  • Submit registrations
  • Clear
  • System waiting
  • Stop break
  • Info
  • Switch bundle mode

If you are missing any of the system tasks, you might want to create these in the indirect activities Group called “System” (Created by the wizard) later on.

Other then the system jobs, you can create a job of type: job… Which is simply just a way to handle your internal costing. These are the jobs that will contain miscellaneous type of work like machine, equipment or building repairs, meetings or other type of work performed that need tracking.


Break activities:
You can either create default breaks in the profiles, but you can also set it up, so the users them selves can select when they take a break and how long it should be.

You can create different types of break activities that will holt the cost allocation to the operation beeing executed on.


You can choose if the break is a paid break and to set a timer for the activity. If the user does not punch a cancel break activity within a given time frame (with tolerance settings) the break will turn in to an unpaid break activity.

You can activate the “Cancel break” to create activities that cancel an active break. This can be different types of cancelation reasons like if there is a machine issue, you would like to track that as opposed to user related cancelations (like if they just wanted to go back to work).

Switch code activities:
Switch codes are used to toggle different types of pay agreements and profile types in the profile.

I use these to mostly toggle overtime and toggle flex vs. overtime for flexi time users.

If you have a special type of pay account build up as well you can use this parameter to toggle this on or off.

You can demand an approval of a switch code. Like in most cases you would not approve overtime automatically, but you need an extra action to do so.


A switch code can also cancel or exclude another switch code, so for the overtime scenario you will also want a cancel overtime activity that negate the overtime switch codes.


On Call:
The on Call activity is a special activity that is called once for each shift (the time between clock in and clock out).

If the user triggers this at any time durring a shift, the entire work time will be “marked” with this On Call activity.

So you can use this as a to trigger where the user gets a special added pay type to each working hour.

I use this for triggering self-managed bonuses. For example if a worker needs to go to jobb in the middle of the night because a machine has stopped or something.


Go to the AX 7 – Time and Attendance guide page

AX7 T&A: Absence setup

Absence registration can be done by the time registration users them selves. If the clock-in or clock-out does not match the expected user profile, the user is prompted with an absence dialogue and can register either the reason why they are late or the reason why they are early.

In 2012 there where several separate ways to handle absence. Which I talked about in this post: Two (three) different absence solutions in AX? I suspect there are some improvements as there seems to be a parameter missing concerning this interaction in the general parameters that are missing.

To configure this go to Time and attendance > Setup > Groups > Absence Groups.


Create the groups with payroll in mind. For instance paid, unpaid, vacation and so on. This can make the payroll setup easier later.

After creating groups you need to create the codes. Click Absence codes in the menu.


Make it available for the time registration user:
The setup for absence codes are the reasons for why the employee is not present. Not all the codes are natural to have in the terminal Interface. To make them available. Set “Registration” to “Yes” under Time and attendance fasttab.

The icons are embedded resources in 2012, but I’m not sure how you find them in AX7. I’ll figure it out and replace this paragraph on how to do it.

Continued or not:
The parameter “Continue absence” determines if the absence code should be active until next clock-in by the user (“Yes”) or only until the next expected clock in stated in the profile (“No”).

Post pay types:
If you want to make the absence post a pay type to payroll you can add a pay type to the record as well. You can do it here if it is the rule for all employees. If they differ for some employees you can do this in the pay agreement setup later.

Absence method:
For absence like Vacation that should result in a full day. You set the “Days” parameter to 1. You might be tempted to try out the Hour/Day toggle in “Method”, but that only works with the Human resources type of absence. Keep it to hour.

All done!

Now… Try clocking outside the expected profile times and see the nice interface pop up.


Go to the AX 7 – Time and Attendance guide page

AX7 T&A: Time Profiles

You create profiles to determin the users actual working times (Time and attendance > Time profiles > Profiles). You can do this in so many different ways that it is could be a dauntfull task to attack. I’ve got my own way of doing it and I’ll show you my way and some other methods of creating this. There is a lot to say here, but jump to: “Create a standard profile” and do that to quickly get started or read all to become a wiz.

Note: Name these based on function or department (Production, Administration, 50%, Day Shift, Night Shift, Flex daytime…) and not on users(eg. Jhonny, Frank, 105, FRS…).

Profile types:
You can configure the profile types at Time and attendance > Time profiles > Profile types. Durring the wizard execution we got some standard profile types, but to get the full functionality you will need atleast:

  • Break
  • Clock in
  • Clock out
  • Overtime
  • Paid Break
  • Standard Time
  • Flex +
  • Flex –


Create a standard profile
A standard profile has expected clock-in and clock-out records and could looks like this:

Profile type Start End Start day End day
Overtime 00:00:00 07:00:00 Monday Monday
Clock in 07:00:00 07:00:00 Monday Monday
Standard 08:00:00 09:00:00 Monday Monday
Paid Break 09:00:00 09:15:00 Monday Monday
Standard 09:15:00 12:00:00 Monday Monday
Break 12:00:00 12:30:00 Monday Monday
Standard 12:30:00 15:30:00 Monday Monday
Clock out 15:30:00 15:30:00 Monday Monday
Overtime 15:30:00 08:00:00 Monday Tuesday

Before 07:00 the user gets Ovetime. After 07:00 they have standard time untill a paid break for 15 minutes at 09:00 and a break at 12:00 for 30 minutes. The clock out is at 15:30 and time after this is overtime. The profile has tolerances for 5 minutes before and after clock-in/out making the rounding within the clock-in/out times.

After creating one day, you can copy this to the rest of the days in the week by using the copy function.


Note: Always check the “Profile time day:” to see the total work hours for that day and “Profile time total:” for the entire week after copying is done.

Microsoft has some great information and examples on this on MSDN for AX 2012 that still applies: Click here

Profiles that need overtime approval
As I don’t want the system to automatically give the users overtime if they register before or after clock-in/out because this has a great economic impact. I use switch codes and secondary profile type to introduce a approval step for this action. The user can clock in early, but they have to enter a switch code to get the overtime. The switch codes are set up with the approval parameter active and available to be registered on.


You can create new switch codes by going to the Indirect Activity Categories (Time and attendance > Indirect Activity Categories) and adding a group and corresponding activities.


Then add a switch code to the line.


I use Break as the default profile type, because this has no payment associated with it. So if the employee works after 15:30 without registering overtime. No payment will be triggered after 15:30.

Note: The final record goes past 24:00 on to Tuesday because a user can then work past 24:00 and still get paid. The calculation is for the profile date and it only looks at the day it is activated. It does not look at the next day after 24:00.

Create a profile without clock-in/out constraints
The simplest profile type is the one without clock in or out times. This solution is pretty quick to set up and covers anyone who clocks in at any time of the day. It is mostly used for “Contractors” (external workers/hired help) and part time workers that is paid hour by hour. It will not prompt the user for absence codes.

Note: This type require users to register in and out from breaks. These can be added to the profile if needed, but are then static.
Punching in and out of breaks require the right Indirect activities system jobs to be created.


Notice that the lines are chronological, and since the first line lasts untill 24:00 the second line last untill 23:00, but on the day after. This way anyone can clock in durring the entre day from 00:00 to 23:59 and work untill 23:00 the next day without any issues. It is important to check the “Profile time day:” to controll this.

Same type with approval for overtime:


Flex time profiles:
We will cover is in Flex time section later.

Prepair for work planner:
While creating profiles. Select a color for the profile. Try grouping them logically, so you can look at the color and kind of an impression on the type of profile.

My standards are:

  • Green for day shifts
  • Amber/orange for evening shifts
  • Red for night shift
  • Grey for generic profiles
  • Yellow for reduced times
  • White for free or NA
  • Blue for flex profiles

Go to the AX 7 – Time and Attendance guide page

AX7 T&A: Basic concepts

It might be hard to get an overview on how the module works, so I made this chart that I feel pretty well illustrates the process and flow of the module in general.


When doing training I feel that this is a great point to start.
An alternative view is this top down approach with a little more detail.


Data input:
Time and attendance uses jobs to that is registered in raw registrations at the time of input from the user. It creates multiple jobs for each production operation depending on the settings, a job for each project and project activity, a job for each indirect activity and absence code and absence group.

Calculating work times:
When the person doing the calculation/approval opens the profile day for control of the hours the system creates the time journal header and time journal transactions based on the raw registrations. The journal can be changed. It can also be reverted back to it’s original transactions by importing the raw registration transactions again. The system require absence to be identified at calculation.

Calculating parameters and Pay agreements:
The pay agreements are used to set the base for what pay types that will be generated.
After the work times are calculated and approved it runs through the calculation parameters where the profile types corresponding with the raw registrations generate pay agreement types based on the calculation parameter settings and pay agreements.


After calculating and approving the user will transfer the journals. This results in the lines being removed from the view of the user and pay types being locked in. These can later be exported to an external payroll system and the pay type transactions will be flagged as exported.

At the time of transfer the production orders and projects will get hours amended in the time journals posted as discrepancies in new route cards/Job Cards and Hour journals.

That should cover the basics!

Go to the AX 7 – Time and Attendance guide page

AX7 T&A: General Parameters

There are a lot of parameters, but I’ll focus on the ones you mostly need to take in to account early on. We’ll get in to the different parameters later, but the default parameters are pretty OK.

No surprise. The general parameters are located at: Time and Attendance > Setup > Time and Attendance Parameters.


I most often keep “Auto insert flex-/absence” blank. If not you will automatically get an absence suggested when approving hours. You would probably want to allocate this and be alerted when absence is registered.

I seldom “Use password”. This is a security feature giving you an extra box in the check in dialogue. It is a field on the worker setup. Leaving it blank lets you only require the user ID. I have a customer where the factory floor workers only authenticate with a barcode ID (no password) and the administration use ID + Password.

I often “Use badge ID” because most companies don’t have a good number sequence on the employee numbers. This requires you to add an ID to the Badge ID field on the worker setup.

Check out the post on user setup for the Password and Badge ID fields.

I recommend using centihours as “Time presentation” as this is easier in conjunction with payroll.

I normally set “Restart at clock-in” to “Yes”. That allows the workers to check in and the system will try to continue on the job they where active on when signing out. If not, they will have to sign in to the job as well after they checked in.

If you set up the “Automatic” clock out function, the system will try checking the user out at the clock out time in their active profile if they forget to clock out after the given “Max. working minutes” has transpired since they clocked in.

I prefer to have a separate journal type for the “Inventory Adjustment” journals then what is standard to be able to see what is created from the terminals as opposed to the journal entry form.


I would recommend to have different journal types for the Hour, Fee and Item journals then standard to be able to distinctly identify the T&A journals.

“Post automatically” set to Yes will post the journals at time of registration and post a offset journal when transferring approved time registrations. Setting it to No will post the journal, but waits until you have approved and then transfer the time registrations to do so.

If you want to use “Cost categories” as opposed to the hour rates from time and attendance for the project activities, then activate this.

Dimensions decide what way the dimensions should be inherited and what should be master in cases of conflicts where both jobs (projects/activities) and the workers have the same dimension filled out.


You can actually run time and attendance with a great insights by only using the indirect activities. You set up the cost handling here.

Set up a separate “Ledger journal” to be able to track the journals in the general ledger. You can use cost categories, which is a set cost for all activities, or get the data from the payroll transactions if you use this to the full extent.

Dimension can be set to a hierarchy or to a single record type either worker or the job. Most often use a hierarchy of “Worker -> Job” because that takes both in to account and the one (Worker in that case) overrides the other.


In Time and Attendance you can either use cost categories or get the cost price from the payroll transactions. You will have to add rates to the pay types, but that gives you the possibility to have more accurate costing.

In this setup you select what is added to your cost price. I’ll go in to this more closely in a separate post.


Best described by Microsoft help wiki: (Formated by me)

Specify whether the user can roll back registrations after pay transactions have been exported to a file. The following options are available:

  • Error (the user receives an error message, and the rollback is not performed),
  • Warning (the user receives a warning message before the rollback is performed)
  • Accept (the rollback is performed; no message is displayed to the user).


More on this in “Electronic time card”.


Setting up number sequences as in any other module: Use prefixes if you want to easily identify the series and never start a series with only zeros.


This will restore your settings to the default setup if you get to far off… which i find kind of odd…

Go to the AX 7 – Time and Attendance guide page

AX7 T&A: Getting started

This is the first post in the AX 7 T&A guide series.

Time and attendance is a very flexible solution for registering attendance and absence as well as manufacturing execution and realtime project feedback.


This is a pretty big setup job if you want it to be done properly. You can however get started right away! Following these steps will get you to start registering time clocking in and out.

1. First you need to run the configuration wizard under Wizards. This will create the required setting like system jobs in indirect activities (clock in/out, wait time, abort pause and more), terminal configurations and profile types.

This slideshow requires JavaScript.

2. Go to time profiles (Time and attendance > Setup >Time profiles > Profiles) and set up a profile single. This define the workers actual working times. You do not need to enter anything in to the profiles, but you need atleast to create a blank one for setting the required parameters on a user.

3. Create the necessary groups. Just create a simple common group for the entire company.
  • Profile group
    Time and attendance > Setup > Time profiles > Profile groups
  • Calculation group
    Time and attendance > Setup > Groups > Calculation groups
  • Approval group
    Time and attendance > Setup > Groups > Approval groups

This slideshow requires JavaScript.

4. Go to the Workers (Human resources > Workers > Workers). On the “Time” pane in the menu bar under the “Maintain” group: Click on “Activate on registration terminals” and fill inn the required fields.

This slideshow requires JavaScript.

5. Now launch the Time and attendance registration terminal and select a terminal setup.
Common > Common > Time and attendance > Clock in/out (Punch clock)

Use the “Clock in and out” for attendance.

You can now clock in and out using the employee Id (Leave password blank if not set) and do the same to clock out.

This slideshow requires JavaScript.

This is the bare minimum to actually start registering attendance. Cool thing is… If you’re only looking for the attendance part of the solution you can start punching time and do the rest of the setup later.

Go to the AX 7 – Time and Attendance guide page


Time and Attendance (Part 29/30): Teams and assistance

In a dynamic factory setting where human resources go back and forth between different jobs, roles and machines it is important to track each resource to get a good overview of the costing. Some times people go around helping each other on tasks and also work as a team throughout the entire day or for a longer period of time.

When many workers work together on multiple production orders within a period, you can task one of the persons to be responsible to register time for all users. This is done by creating a “team”.

Creating a team

In a team you have the pilot and the team members. The pilot is responsible for the terminal registrations for all the team members. This is done by simply changing jobs as usual. The team members use the “assistance” functionality to join a team. Simply click Assistant and select another signed in worker to start a team.



Managing your team

An overview of current teams can be shown in the Teams form (Human resources > Inquiries > Time and attendance > Teams)

This slideshow requires JavaScript.

Teams can not be “nested”, meaning that a team can not be a part of another team. Not because of the functionality. The tree view is clearly there to illustrate a multi level hierarchy. There just isn’t any way for a team pilot to assist another team pilot. You would have to hack it to do so, and then I don’t know what happens to cost calculations.

The team pilot, Bill Malone in the example above, will change jobs and the cost of the team members (Dana and Christina) will be assigned to the jobs that the pilot is working on.

Before the pilot checks out for the day, and still is pilot, he will get a message saying he has to change pilot before checking out.

The pilot then uses the “Assistant” function as well, but since he/she is a pilot, the menu will say: Change pilot.


After selecting one of the team members to be pilot, the user will be demoted to team member. A dialogue shows to confirm this.


Setup: System jobs needed

If you try to work with assistance and you get a message about missing jobs, it is because your system is not ready.

Go to the Indirect Activities (Human resources > Setup > Time and attendance > Indirect Activities), enter the “System” group and add the required jobs like this:


Add jobs for the following system functions:

  • Start assistance
  • Stop assistance
  • Change pilot

Remember to check the “registration” to be able to use it in time and attendance.

Smart use of this feature for shifts/hand off

A smart way to use this feature is if you have a resource that handles many jobs at once and do a shift change. I have a customer that has a production line where many (40-100) jobs can be active at once from about 1000 released jobs.

Instead of the shift coming on has to register to all the jobs and select them from the enormous list of jobs, he/she uses this feature for a hand-off.

This is what you do:

  1. The shift coming on signs in and registers as assistant on the one working on all the jobs.
  2. The shift going home registers the person coming on as pilot and checks out.

The jobs are then handed over. A great time saver.

Time and attendance (Part 27/31): Payroll statistical groups

Payroll employees are continuously hammered with questions like: How many vacation days do I have left? What is my flex account balance? How many overtime hours do I have so far this period? What is the balance of “this” account?
These data are often presented to the worker on the payroll report or payment slip and at that time often spark a debate with a bunch of employees all at once.

Putting continuously updated account balance information in to the hands of the worker is pretty important as it frees up a lot of time for the payroll employees. Some, but not all, of this info is presented as default in the time and attendance (Paytime, Overtime, Absence and flex). However, you may want to present the worker with other account balances, like vacation for instance.
The way you do this is by grouping together different payroll types in to “Payroll statistical groups”.

The Payroll Statistical Group also has other usages like weighing average balances within a period and I’ll go in to that in a later post, but today we’re just looking at showing balances to end users.

It is a set of accounts that you group together to show a balance, and you can choose if it should show only for the current period (Paytime, Overtime, Bonus that are paid regularly) or the total account balance (Flex and Vacation). The groups are then presented to the worker in a list that you can access in the time and attendance registration form called “Balance”, F1 shortcut in the image below.


Note: The flex account and overtime are displayed in the users status window, but can also be added to this list. Also on the balance overview list you’ll find your standard payment


To set this up you must first set up the entity that group your accounts for a summed balance. Go to Human Resources > Setup > Time and attendance > Payroll > Payroll Statistics.

Create the summary groups for your accounts. “Transfer” means that the account balance for previous periods are accumulated in the view.


Go to “Setup” and add your accounts.


Now choose what balances you want the workers to view in the time and attendance registration form.


That is it! Now you can present any kind of account balances to an employee and ease off many questions to the HR/payroll department.

Good luck!