News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Updating Opportunity S...

Customer experience | Sales, Customer Insights,...

Answered

Updating Opportunity Status

(0) Share

Report

Report

Posted on by handedee

182

Hi,

I am trying to migrate Opportunities from On-premise to Online env.

These are the steps I am following:

Migrate all opportunities in draft/open status
Migarte Opportuniy Lines
Migrate all activities related to opportunities
Update the status/status reason of Opportunities.

While performing the last step (updating status), I get this error: Sequence contains no elements

Am I missing anything? I also tried importing OpportunityClose entity but no luck.

We are using Scribe Insight to migrate data

Cheers

Deeksha

All responses Img

All responses (2)

Answers Img

Answers (1)

handedee 182 on at

Like (0)

Report

RE: Updating Opportunity Status

Thanks Leo. I was using Opportunity Id as a look up key, which is a primary key.

But when I used a different field for lookup value, it worked! That's strange. But it's sorted. Thanks a lot :)

Cheers

Deeksha
Verified answer

LeoAlt 16,329 on at

Like (0)

Report

RE: Updating Opportunity Status

Hi Partner,

This issue is a coding issue which may be caused by querying columns that do not exist.

That may be the issue with Scribe Insight, so you could contact with them for more help.

And in D365, you could export the data you need first by excel from OP env and then import them into online.

You should import the parent records first(in your case is Opportunity), and then import the child records(Opportunity line, activity).

Regards,

Leo

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans