Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Valid time state table in D365 FO

(0) ShareShare
ReportReport
Posted on by 7,963 Super User 2025 Season 1

Hi all,

When I am trying to update valid time state table using ValidTimeStateUpdate::CreateNewTimePeriod) mode an error is returned as below:


Message=Cannot edit a record in Category change status (VendProcurementCategoryStatus). 'Expiration' column cannot be updated in change tracking mode.

Any hint?

  • Suggested answer
    Komi Siabi Profile Picture
    12,789 Most Valuable Professional on at
    RE: Valid time state table in D365 FO

    Hello Waed,

    Since you are trying to update the field and not newly creating , the validTimeStateUpdateMode should be Correction.

    community.dynamics.com/.../error-when-updating-hcmpositiondeatil-table-x

  • Mohit Rampal Profile Picture
    12,556 Moderator on at
    RE: Valid time state table in D365 FO

    Also, as per this thread you can't update both ValidFrom and ValidTo fields at same time.

    community.dynamics.com/.../effective-can-only-be-updated-to-today-or-a-value-in-future-in-change-tracking-mode

  • Suggested answer
    Mohit Rampal Profile Picture
    12,556 Moderator on at
  • GirishS Profile Picture
    27,823 Moderator on at
    RE: Valid time state table in D365 FO

    I think if you want to update the valid to the future date then it can be done only in the Correction mode. You cannot do that in a Create new time period mode as the valid to will be automatically update based on the scenario.

    Thanks,

    Girish S.

  • Waed Ayyad Profile Picture
    7,963 Super User 2025 Season 1 on at
    RE: Valid time state table in D365 FO

    Manual update I am trying to update (valid from to date >= today) and (valid To to future date)

  • Waed Ayyad Profile Picture
    7,963 Super User 2025 Season 1 on at
    RE: Valid time state table in D365 FO

    Yes I am trying to change valid to to future date

  • Mohit Rampal Profile Picture
    12,556 Moderator on at
    RE: Valid time state table in D365 FO

    Hi, Are you trying to update manually or through data entity and what values are you updating in Valid from and Valid To dates.

  • Suggested answer
    GirishS Profile Picture
    27,823 Moderator on at
    RE: Valid time state table in D365 FO

    Hi Waed,

    I think you are trying to update "Valid to" (Expiration date). You cannot update the valid to in valid time state table since it will adjust automatically.

    Thanks,

    Girish S.

  • Bharani Preetham Peraka Profile Picture
    3,624 Moderator on at
    RE: Valid time state table in D365 FO

    Error says that you cannot update if change tracking is enabled. May be you can disable that and try.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,302 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,108 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans