Print Pay Statement

(0) Share

Report

Posted on by Ethan Ong

Hi all,

Was wondering, how does the sequence in generating periodic Pay statement from the report?What order or rule does it goes by? Is it by employee name. Personnel number????

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Fredrik Sætre 12,644 on at

Like (0)

Report

Most likely employee number by default.

Was this reply helpful? Yes No
Ethan Ong on at

Like (0)

Report

Hi Fredrik, just solve it. Is actually the lasted sequence statement to the earliest by period.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

First, I believe the pay statements are based on the order of the earning statements. The earning statements are based on the RECID for HCMWorker table assigned when you enter a new employee. Could be wrong but that is the way it looks.

Was this reply helpful? Yes No
Ethan Ong on at

Like (0)

Report

Hi Sam,

Thanks for the answer.

It is exactly retrieving sequence from Earning statement.

However, I am curious to what extend, it was arrange during generating earnings statement in the first place?

As far I know is doesn't follow employee number or employee name (alphabetical order).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ethan,

The pay statements are in the same order as the earnings statements. There is an entry in the table HCMWorker that is a record ID field. It is basically a system generated number that follows the order of when the workers were put into AX. This number is the sort order for these reports. I don't particularly like this being the sort order. I would prefer the personnel number. As you enter a new employee, they will end up at the end of the batch.

Was this reply helpful? Yes No