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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to assign a calend...
Microsoft Dynamics AX (Archived)

How to assign a calender for all the workers in dynamics

(0) ShareShare
ReportReport
Posted on by Mohammed Abdul Aziz 1,875

Experts,

Right now i have to select each worker , edit profile , go to employment section and assign a calender to them. 

Please let me know if there is a way using which i can select all workers and assign them the calender at one go .

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: How to assign a calender for all the workers in dynamics

    Please review folllowing link if this helps you for your requirements

    technet.microsoft.com/.../aa549057.aspx

    There are different way by which we can setup up calender and Periods to a worker

    Please verify and update us if this helps you

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,260 Super User 2025 Season 2 on at
    RE: How to assign a calender for all the workers in dynamics

    Hi Mohammed,

    The link provided by Nitesh is a article about Project periods, not the Calendars.

    The steps to update the Calendar you are decribing is the only functional supported method.

    Note that it is posssible to have multiple active Employments for one user. On the Worker details form you can select the Legal entity for which you want to update the details.

    You could or use e.g. Data Import/Export Framework to do a mass update or consider a customization.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: How to assign a calender for all the workers in dynamics

    Hi Mohammed,

    Agreed with Andre that there is no standard out of the box function available to do this.

    The field which you are pointing is the calendarID field of WorkCalendarEmployment table. So if you have X++ knowledge and you want to assign same value in all the workers then you can write a simple job to update the field using update_recordset command.  

    Please note before running this job in any production environment, test it in your TEST/SBOX and verify that the results are matching your expectation. The below job will update the value of calendarID for all the records so if there are any exceptions then you might need to add some where conditions.

    So your job should be something like below if for example your calendarID is 'STD' :

    static void Job10(Args _args)

    {

       WorkCalendarEmployment workCalendarEmployment;

       update_recordset workCalendarEmployment

       setting CalendarId = 'STD';

    }

    Refer to below link on how to use update_recordset

    msdn.microsoft.com/.../aa674382.aspx

    Hope this helps.

    Thanks,

    Priyanka Agarwal

  • Mohammed Abdul Aziz Profile Picture
    Mohammed Abdul Aziz 1,875 on at
    RE: How to assign a calender for all the workers in dynamics

    Thanks Guys for answering my queries.

    Since i am not familiar with X++. I used excel add in to upload calender for all the employees.

    Steps:

    1. Add Table - (HCMEmpolyment).

    2. Drag Columns and Publish - It gets all the records from table with ( Company.Dataarea, worker.personal number, employment start date and employment end date).

    3.Open a new excel sheet and Add Table -(WorkCalenderEmployment).

    4. Drag Columns and Publish - It gets all the records from table(Employment.DataArea, Employment.Employment end date, Employment.Employment start date, Employment.Personnel number, Calendar,RecId).

    5. Copied all the rows from HCMEmployment sheet and pasted them in WorkCalenderEmplyment sheet.

    6. I have to fill in Recid for WorkCalenderEmployment table by dragging down the column and fill it with series.

    7. Publish it back and all the employees are associated to a calender.

    Experts advice me the way i followed is correct or not. I am familiar with little programming and i want to learn X++ and customize dynamics ax. Please let me know if there are any good online instructor for this.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans