Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Adding New Column in View Ax 2012

(0) ShareShare
ReportReport
Posted on by 131

Dear All,

I want to add new column in PayrollStatementGenerationView and I have Add enum type (HCMEmploymentType) but it is not syncnorizing in database

what is the solution for that?

Here is the screenshot of View

payroll

  • Verified answer
    Laraib Profile Picture
    Laraib 131 on at
    RE: Adding New Column in View Ax 2012
    [quote user="Laraib"]

    Dear All,

    I want to add new column in PayrollStatementGenerationView and I have Add enum type (HCMEmploymentType) but it is not syncnorizing in database

    what is the solution for that?

    Here is the screenshot of View

    Image

    [/quote]

    I have resolve this issue by editing PAYROLLPOSITIONWORKERASSIGNMENTGROUP query. I just add column there from sourced table then add field in query and then add field in View and the issue resolved.

    Thanks everyone for guiding me  

  • Laraib Profile Picture
    Laraib 131 on at
    RE: Adding New Column in View Ax 2012
    [quote user="MuthuKumaranAX"]

    then I believe sync would have taken place already, I would suggest to check the field list in SQL server once for the view?

    [/quote]

    I have checked on sql serever but it is also not showing there. Screenshots are attached

    I want employee type field in this view

    payroll

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,996 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,853 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans