web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Cannot delete a write in product in SalesOrder, which was created and trying to delete programmatically. "salesorderdetail With Id Does Not Exist"

(0) ShareShare
ReportReport
Posted on by 45

In salesorder entity, I create a write-in line item if I have freight amount. The Line is created if there is a tax on freight. If the freight amount is completely taken out then I want to delete that item. But I get the following error "salesorderdetail With Id = c471fe88-a3cd-e811-a973-000d3a1a9407 Does Not Exist"

In fact the line Id does exists with same id in the db.

Here is the code to insert the line in the salesorder 

Guid freightDetailId = new Guid();
Entity freightLine = new Entity("salesorderdetail", freightDetailId);
freightLine["salesorderid"] = new EntityReference("salesorder", gEntityId);
freightLine["isproductoverridden"] = true;
freightLine["priceperunit"] = new Money(0);
freightLine["quantity"] = Convert.ToDecimal(1);
freightLine["productname"] = "Freight Tax line";
freightLine["productdescription"] = "Freight Tax line";
freightLine["tax"] = new Money(10.00);
service.Create(freightLine);


Here is the code I use to delete the same line from salesorderdetail if freight is either 0 or not present at all

if (freightLineExists) // if freight line exists then delete it as freight is not available anymore
{
     tracer.Trace("freight exists");
     tracer.Trace("Freight ID = "+ ec.Entities[freightLineNumber].Id);
     service.Delete(ec.Entities[freightLineNumber].LogicalName, ec.Entities[freightLineNumber].Id);
}

*This post is locked for comments

I have the same question (0)
  • a33ik Profile Picture
    84,331 Most Valuable Professional on at

    Hello,

    Can you please provide code how to do you retrieve ec - from line ec.Entities[freightLineNumber].Id

  • newtomsworld Profile Picture
    45 on at

    Here is my code

    QueryExpression query = new QueryExpression("salesorderdetail");

    query.ColumnSet.AllColumns = true;

    query.Criteria.AddCondition("salesorderid", ConditionOperator.Equal, entityId);

    EntityCollection ec = service.RetrieveMultiple(query);

    I think I have figured out why. Its solved now.

    I have service.update(entity) in multiple places which updated other entites in the "ec". and once that is done there is data.refresh on clinet side which triggers save. I think this double saving may have caused it. I now removed all

    service.Update(ec.Entities[i]); and it solved the problem

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans