How to update Created on field - the system field?

(0) Share

Report

Posted on by Peter Cong

137

Hi,

I am using MS Dynamics 365 version 1612 (8.2.2) on-premises, we know that the "Created On" in most models are system generated field, user can not modify it.

But my client asks to modify it to some back of date for some records, I have done some searches from the internet, it seems it is possible.

I found this video which shows me how to edit it and followed it:

https://www.youtube.com/watch?v=brWeeK1tve0

this is what I did:

1. Created a personal view to list some records I want to update the data of "Created On" field back to past date (2009-02-10)

2. Export the data to Excel and added new column called: OverriddenCreatedOn (some other posts also mentioned I can call it RecordCreatedOn), and entered date of "2009-02-10" and saved it as excel file to my local machine.

3. Closed the personal view

4. Reopen this personal view, and import the previous excel file, I can see the "OverriddenCreatedOn" is not mapped, I should map it to Created On field, but I can not field the Created On field on the right side.

Can anybody tell me what is wrong with it? Does this work on the old version of CRM, and it is not working with new version CRM I am using right now?

Thanks a lot,

Peter

I have the same question (0)

All responses (38)

Answers (1)

Suggested answer

Peter Cong 137 on at

Like (0)

Report

RE: How to update Created on field - the system field?

Hi Andrew, sorry, I didn't know how to make it when I replied,

Now, I have just marked it, you should see it, if not, please let me know,

Much appreciated again,

Peter

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: How to update Created on field - the system field?

Peter,

Thanks for this note, I will keep that in mind. If you have resolved your issue I would appreciate if you close the thread and mark reply (or replies ;) ) as an answer clicking "Yes" at the top of the reply under the question "Does this answer your question". Thumbs up are welcomed as well.

Was this reply helpful? Yes No
Suggested answer

Peter Cong 137 on at

Like (2)

Report

RE: How to update Created on field - the system field?

[quote user="Andrew Butenko"]
Unfortunately I have nothing to add. It should work but it doesn't and that's weird.
[/quote]

Hi Andrew,

Good news, finally the problem is resolved, just like you said, the plugin codes is correct, the Plugin registration process was correct. The only problem is the version of .NET class library I wrote, the CRM on-premise my company used needs .NET framework 4.5.2, but I was using the newest 4.8 version which caused the problem.

Again, thank you so much for your help, much appreciated,

I am sure that I will have some more questions need you help as I am just starting the CRM programing from now.

Have a great day,

Peter

Was this reply helpful? Yes No
Peter Cong 137 on at

Like (0)

Report

RE: How to update Created on field - the system field?

Hi Andrew,

I would like to try custom work flow to see if it is working, do you know how to convert my plugin codes to custom workflow?

Thanks

Peter

Was this reply helpful? Yes No
Peter Cong 137 on at

Like (0)

Report

RE: How to update Created on field - the system field?

HI Bipin, thanks a lot, actually, I have read that article and checked that I have that permission, since this is on-premise sandbox environment, I can set any permission I want.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

RE: How to update Created on field - the system field?

Hi,

I am not sure if this will help but worth looking at below article.

rajeevpentyala.com/.../

User who is creating record has system admin role if not can you please assign override created on field permissiona as per above article and then check.

Please mark my answer verified if i were helpful

Was this reply helpful? Yes No
Peter Cong 137 on at

Like (0)

Report

RE: How to update Created on field - the system field?

this is the form opened before saving

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: How to update Created on field - the system field?

Unfortunately I have nothing to add. It should work but it doesn't and that's weird.

Was this reply helpful? Yes No
Peter Cong 137 on at

Like (0)

Report

RE: How to update Created on field - the system field?

[quote user="Andrew Butenko"]
Your code and registration parameters look good. Do you populate that "dnd_pid_createddate" field when you create the record?
[/quote]
Hi Andrew, Yes, please find the populated field in the following screenshot, this is the record after saved. When I create a New record, that field labeled with pid_created_Date is blank, so I on purpose entered a past date 10/16/2019 and expected the Created On field is saved on that date, but it is still saved current today's date.

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: How to update Created on field - the system field?

Your code and registration parameters look good. Do you populate that "dnd_pid_createddate" field when you create the record?

Was this reply helpful? Yes No