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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Position effective date - mass change

(1) ShareShare
ReportReport
Posted on by 126

Hello,

I have a case where I need to change the effective date in all positions.  The date must be filled with the "Available for assignment" date.
pastedimage1667466642877v1.png

I tried to do it with Data Management, but get an error:
pastedimage1667466283575v2.png

Are there any ways, how could I mass-update the records? Maybe X++?

I have the same question (0)
  • Suggested answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    Hi Mantas,

    You can achieve via data management too. When you want to change the position details then earlier position needs to adjust based on new position.

    For eg.

    Position A : 01/01/2022 to 01/11/2022

    Position B : 02/11/2022 to Never

    In your case, the effective and expiration is same for the position and that does not work. Position tables are date effective. It means when you can this position manually in the system then it adjusts position dates accordingly.

    Check reference link.

    learn.microsoft.com/.../date-effectivity

  • Mantas Sedys Profile Picture
    126 on at

     Parag Chapre , thanks for the anwer.
    In Excel, there are two different positions and they're not related.
    pastedimage1667474752122v1.png
    My main task is to find a way to change the effective date value to the same as Available for assignment.

  • Verified answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    You can write the X++ code and make a date correction according to this link.

    learn.microsoft.com/.../date-effectivity

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 692 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 364 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans