@Naveen B Thanks for the reply.Can you share the steps to reverse Payments and related Invoices.
@Naveen B Thanks for the reply.Yes, Acumatica check the Key and if the record exist then it updates the record.I don’t want to update the record instead of update it should skip the record.
@Naveen B Yes, we are planning to move for REST API soon. I have tried your code but in my case it is still update only first record of detail line item.Please see my below code.Acumatica 2020 R1try { var commandList = new List<Command>(); string acushipmentNbr="007110"; string LineNbr="4"; commandList.Add(new Key { Value = "='Shipment'", LinkedCommand = SO302000.Result.ShipmentSummary.Type }); commandList.Add(new Key { Value = "='" + acushipmentNbr + "'", LinkedCommand = SO302000.Result.ShipmentSummary.ShipmentNbr }); commandList.Add(new Key { Value = "='" + LineNbr + "'", LinkedCommand = SO302000.Result.DocumentDetails.LineNbr, Commit = true }); commandList.Add(new Key { Value = "='" + acushipmentNbr + "'", LinkedCommand = SO302000.Result.DocumentDetails.ShipmentNbr, Commit = true }); commandList.Add(new Value { Value = shipmentLine
@Naveen B - Thanks for the reply. I have implemented your code in following format but it always update “Shipped Qty” of first row of the Detail record, even we provide different LineNbr. (Shipment have multiple line items)Please see my below code snippet. try { var commandList = new List<Command>(); commandList.Add(new Value { Value = "Shipment", LinkedCommand = SO302000.Result.ShipmentSummary.Type, Commit = true }); commandList.Add(new Value { Value = acushipmentNbr, LinkedCommand = SO302000.Result.ShipmentSummary.ShipmentNbr, Commit = true }); commandList.Add(SO302000.Result.DocumentDetails.ServiceCommands.RowNumber); commandList.Add(new Value { Value = "4", LinkedCommand = SO302000.Result.DocumentDetails.LineNbr,Commit = true }); commandList.Add(new Value { Value = acushipmentNbr, LinkedCommand = SO302000.Result.DocumentDetails.Shipmen
@Naveen B Thanks for reply. Following is the code.Acumatica 2020 R1Build 20.106.0005 try { var SO302000 = LoadAndSetSchemaSOShipment(); var commandList = new List<Command>(); commandList.Add(new Key { ObjectName = SO302000.Result.DocumentDetails.LineNbr.ObjectName, FieldName = SO302000.Result.DocumentDetails.LineNbr.FieldName, Value = LineNbr.Trim(), Commit = true }); commandList.Add(new Key { ObjectName = SO302000.Result.DocumentDetails.ShipmentNbr.ObjectName, FieldName = SO302000.Result.DocumentDetails.ShipmentNbr.FieldName, Value = acushipmentNbr.Trim(), Commit = true }); commandList.Add(new Value { Value = shipmentLines.ShippedQty.ToString(), LinkedCommand =
@Naveen B Yes, its a ON HOLD record. Manually, I can update the “Shipped Qty”.
@Naveen B I’m saving the document as below before submitting it. commandList.Add(new Value { Value = shipmentLines.ShippedQty.ToString(), LinkedCommand = SO302000.Result.DocumentDetails.ShippedQty,IgnoreError=true, Commit = true });commandList.Add(SO302000.Result.Actions.Save); var list = commandList; SO302000Content[] SO302000Content = context.SO302000Submit(list.ToArray());if (SO302000Content.Length > 0) { return true; //return Operation<string>.CreateFromOperationSucess(SO302000Content[0].ShipmentSummary.ShipmentNbr.Value.ToString()); }
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.