web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Salary Comparison Report
Microsoft Dynamics AX (Archived)

Salary Comparison Report

(0) ShareShare
ReportReport
Posted on by DEEPAKNONU 207

Dear Experts,

I  have one requirement to create a report for payroll which have

1)  Employee Id , Name, Department and current year salary details.

2)  On other side the previous year salary detail.

3)  In last the difference between the current year salary and previous salary package.

Can please anybody suggest me how can i create this report.

step - 1) Completed

But i don't know how can i get previous year salary package and package details.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Zain Bokhari Profile Picture
    Zain Bokhari 3,208 Moderator on at

    What do you mean you cannot get the previous salary?

    How are you getting the current salary details for your report?

    Salary Details are stored in a ValidTimeState enabled table. You can simply get the current and previous records using that.

  • DEEPAKNONU Profile Picture
    DEEPAKNONU 207 on at

    Thanks, Zain for your response. In on my Onsite client this facility available on Payroll salary package module may be this form is customized. In this form you get the current salary amount and their is previous salary amount is also available i need to create compare report from previous to current salary.

  • Zain Bokhari Profile Picture
    Zain Bokhari 3,208 Moderator on at

    Then you should just go to the AOT and take a look at how that previous salary value is being shown in that form then you can do the same for you report.

  • DEEPAKNONU Profile Picture
    DEEPAKNONU 207 on at

    Actually they just create as a header row and then create the header detail lines . Just like as a sale order and inside sales order has lines.

  • Zain Bokhari Profile Picture
    Zain Bokhari 3,208 Moderator on at

    The report you developed is it a Query based report or RDP class?

  • DEEPAKNONU Profile Picture
    DEEPAKNONU 207 on at

    I tried with query base report if it finished then otherwise need to create RDP class. But i don't know how i can get the previous salary package.

  • Suggested answer
    Zain Bokhari Profile Picture
    Zain Bokhari 3,208 Moderator on at

    Like I said the table you are trying to get data from is a ValidTimeState key enabled table.

    You need to understand how ValidTimeState works. Take a look at these forum discussion for instance:

    https://community.dynamics.com/ax/f/33/t/238447

    https://community.dynamics.com/ax/f/33/t/153938

    and following help from Microsoft. 

    How to use Query with ValidTimeState

    Select statement with validTimeState

    Just a hint: The current record like any other record you select has an effective start date and an effective end date. After going through the above links you should be able to figure out how to get the current and previous salary records by using the effective start and end dates.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans