Finance | Project Operations, Human Resources, ...

Valid time state table in D365 FO

(0) Share

Report

Posted on by Waed Ayyad

8,972 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

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.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,825 Moderator on at

Like (1)

Report

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.

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

Like (1)

Report

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.

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

Like (0)

Report

RE: Valid time state table in D365 FO

Yes I am trying to change valid to to future date

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

Like (0)

Report

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)

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

Like (2)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (1)

Report

RE: Valid time state table in D365 FO

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,563 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,049 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No