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

Announcements

No record found.

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans