Using GP Web Service: How do I delete a SalesOrderLine from a SalesOrder?

(0) Share

Report

Posted on by Community Member

Can someone help me delete a SalesOrderLine from a SalesOrder?

I'm using the GP WS Native Endpoint

My code executes without an error.

The bold line of code below is where I'm creating a new array without the line I want deleted. This code executes and newLines has the Lines without the one I want deleted.

However, after updating the SalesOrder, the line I removed still remains.

var salesDocumentKeyObject = new SalesDocumentKey {Id = salesDocumentKey, CompanyKey = this.CompanyKey};

var salesOrder = this.DynamicsGpClient.GetSalesOrderByKey(salesDocumentKeyObject, this.Context);

var newLines = salesOrder.Lines.Where(l => l.Key.LineSequenceNumber != lineItemSequence).ToArray();

salesOrder.Lines = newLines;

var salesOrderUpdatePolicy = this.DynamicsGpClient.GetPolicyByOperation("UpdateSalesOrder", this.Context);

this.DynamicsGpClient.UpdateSalesOrder(salesOrder, this.Context, salesOrderUpdatePolicy);

Thank you for any help,

Karl

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Community Member on at

Like (0)

Report

RE: Using GP Web Service: How do I delete a SalesOrderLine from a SalesOrder?

I don't think the update method will trigger a delete for things that don't exists. Instead try using the DeleteSalesOrder method.

msdn.microsoft.com/.../cc508447.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Using GP Web Service: How do I delete a SalesOrderLine from a SalesOrder?

I misread you're attempted delete the SalesOrderLine. Nonetheless, if you cannot reach a solution you could delete the whole SalesOrder and create new.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Using GP Web Service: How do I delete a SalesOrderLine from a SalesOrder?

Microsoft Dynamics GP Web Service has poor documentation and examples. Deleting a sales order line is a common scenario, but ZERO guidance is provided.

Do delete a sales order line, you retrieve the order, locate the line to delete and set the sales order line property, DeleteOnUpdate to true, and then save the order.

Updated code below:

var salesDocumentKeyObject = new SalesDocumentKey {Id = salesDocumentKey, CompanyKey = this.CompanyKey};

var salesOrder = this.DynamicsGpClient.GetSalesOrderByKey(salesDocumentKeyObject, this.Context);

var target= salesOrder.Lines.FirstOrDefault(l => l.Key.LineSequenceNumber == lineItemSequence);

if (target != null) {

target.DeleteOnUpdate = true;

}

var salesOrderUpdatePolicy = this.DynamicsGpClient.GetPolicyByOperation("UpdateSalesOrder", this.Context);

this.DynamicsGpClient.UpdateSalesOrder(salesOrder, this.Context, salesOrderUpdatePolicy);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Using GP Web Service: How do I delete a SalesOrderLine from a SalesOrder?

Thank you for the reply. Finally after hours, found the solution. See my reply.

Have a great day,

Karl

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Using GP Web Service: How do I delete a SalesOrderLine from a SalesOrder?

Again, thank you for your reply.

Was this reply helpful? Yes No

Community site session details

Using GP Web Service: How do I delete a SalesOrderLine from a SalesOrder?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

Using GP Web Service: How do I delete a SalesOrderLine from a SalesOrder?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates