Updating Won and Lost Opportunity Fields, Dynamic 365

Normally when you update won or lost opportunity from UI, you need to reopen the opportunity, update field and then close opportunity as won or lost. However, this implies that the modified date and the Actual close of opportunity will change.

In this blog, we will show you how to update fields of won or lost opportunity without changing the actual close date field. This is relevant for data clean-up without losing track of when the opportunity was closed. This is an important business problem because of closed date effects sales pipeline.

Search your record from Advanced Find.

advanced find in crm

Add the Column you want to update. In my case, I am updating the “Lead Source” field.

lead source in crm

Export the record, click on Export opportunities and then click on a static worksheet.

static work sheet in crm

Open the excel sheet and Update the field you want- in my case I set Lead source field.

opportunity advanced find views

Save the excel file and go to Opportunities in CRM. Import your file.

opportunity in dynamics 365 d=c===rm

Once your record is uploaded, your required field will be updated without changing the Actual Close date. Only “modified on” field will change.'

modified field on dynamics crm 365

This export and import method will work for all entities.

That’s it for today, I hope it helped you!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.