Announcements
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?
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
Also, as per this thread you can't update both ValidFrom and ValidTo fields at same time.
As Girish mentioned, please try Correction mode and also check this thread
community.dynamics.com/.../date-effective-record-not-updating
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.
Manual update I am trying to update (valid from to date >= today) and (valid To to future date)
Yes I am trying to change valid to to future date
Hi, Are you trying to update manually or through data entity and what values are you updating in Valid from and Valid To dates.
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.
Error says that you cannot update if change tracking is enabled. May be you can disable that and try.
André Arnaud de Cal...
293,302
Super User 2025 Season 1
Martin Dráb
232,108
Most Valuable Professional
nmaenpaa
101,156
Moderator