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 :
Finance | Project Operations, Human Resources, ...
Answered

Mass re-assignment of timesheet period for Workers under specific legal entity

(0) ShareShare
ReportReport
Posted on by 104

Hi 

We have a legal entity which used to run their working week Sunday to Thursday but now they have moved over to Monday to Friday. The Timesheet period type for this legal entity was setup to reflect the Sunday to Thursday working so I need to change this. 

After investigating I found I can't edit the existing setup so I made a second period for this legal entity which I intend to start when the periods on the current Period setup ends which gets around the lack of ability to edit the existing period setup.

pastedimage1678889795668v1.png

The issue I have is this period type option is setup per user and there are 60 odd people under this entity so I need a way of mass assigning the new period type to there employee records, is there a way to do this or do I need to access each users record under this entity one by one then change it?

Cheers;

Neil

I have the same question (0)
  • Median Profile Picture
    104 on at
    RE: Mass re-assignment of timesheet period for Workers under specific legal entity

    As always thank you Girish.

    I assumed if I clicked on the excel edit option once your in the Project Setup part against a user it would just pull through that users information for that section.

    Thanks I'm good now :)

    Cheers;

    Median

  • Verified answer
    GirishS Profile Picture
    27,825 Moderator on at
    RE: Mass re-assignment of timesheet period for Workers under specific legal entity

    I assume that you are talking about assigning period type to the worker. Its available under Worker >> Select any worker >> Project >> Project Setup >> Under Timesheet Group you can see "Period code".

    Inside this form on the top right corner there will be office button - You can click on that download the open in excel option >> Sign in with your login inside excel - Add period code for all the workers and click on publish.

    Thanks,

    Girish S.

  • Median Profile Picture
    104 on at
    RE: Mass re-assignment of timesheet period for Workers under specific legal entity

    Hi Girish

    Thanks for your response, I'm not sure I follow what you mean, but let me explain what I think you meant and go form there -

    Do you mean editing it via the excel option from the list view of under Employees or Workers? If so below is a list of columns I can add to the Employees under this Entity when I go to the Employees or Workers section -

    employee-columns.png

    I ordered the above by alphabetical order so I could show the period code isn't a selectable option.

    I also tried to view the list of Workers by clicking the "Workers option within the Timesheet period type section, but the list view brought up was ultimately the same column options as above -

    pastedimage1678950315730v1.png

    Cheers;

    Median

  • Suggested answer
    GirishS Profile Picture
    27,825 Moderator on at
    RE: Mass re-assignment of timesheet period for Workers under specific legal entity

    Hi Median,

    You can make use of open in excel option to update worker timesheet period code.

    Thanks,

    Girish S.

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

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,257

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 913 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 611 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans