Finance | Project Operations, Human Resources, ...

Valid time state table in D365 FO

(0) Share

Report

Posted on by Waed Ayyad

9,056 Super User 2025 Season 2

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?

I have the same question (0)

All responses (9)

Answers (0)

Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

GirishS 27,829 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Waed Ayyad 9,056 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Yes I am trying to change valid to to future date

Was this reply helpful? Yes No
Waed Ayyad 9,056 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GirishS 27,829 Moderator on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (1)

Report
Copy link

Link copied!

As Girish mentioned, please try Correction mode and also check this thread

community.dynamics.com/.../date-effective-record-not-updating

https://learn.microsoft.com/en-us/dynamicsax-2012/developer/effects-of-valid-time-state-tables-on-read-and-write-operations

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,190 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No