Skip to main content

Notifications

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

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

(0) ShareShare
ReportReport
Posted on by 94

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

  • Median Profile Picture
    Median 94 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
    GirishS 27,821 Super User 2024 Season 1 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
    Median 94 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
    GirishS 27,821 Super User 2024 Season 1 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

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... 292,111 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,934 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans