Dynamics Community Forum Thread Details

Cannot edit a record in Customer invoice lines (CustInvoiceTrans). The operation cannot be completed, since the record was not selected for update. Remember TTSBEGIN/TTSCOMMIT as well as the FORUPDATE clause.

When i update

field on table, is calling this error on line code custInvoiceTrans.update(); Its problem with property update, but whe i need check and resolve this? Please, help.

public void initQuery()
{
........................
........................
while(queryRun.next())
    {
        queryRun.userUpdate(true);
        custInvoiceTrans = queryRun.get(tableNum(CustInvoiceTrans));
        
            try
            {
                salesLine = SalesLine::find(custInvoiceTrans.SalesId);

                dboSalesAcrossOpsAndRes.InventSiteId = inventSiteId;
                dboSalesAcrossOpsAndRes.CustAccount = custAccount;
                //dboSalesAcrossOpsAndRes.JmgJobId = jobIdProcess;
                //dboSalesAcrossOpsAndRes.RouteOprId = oprId;
                dboSalesAcrossOpsAndRes.SalesId = custInvoiceTrans.SalesId;
                dboSalesAcrossOpsAndRes.InvoiceId = custInvoiceTrans.InvoiceId;
                dboSalesAcrossOpsAndRes.InvoiceDate = custInvoiceTrans.InvoiceDate;
                dboSalesAcrossOpsAndRes.ItemId = custInvoiceTrans.ItemId;
                dboSalesAcrossOpsAndRes.SalesOrderedQty = custInvoiceTrans.Qty;
                dboSalesAcrossOpsAndRes.Weight = custInvoiceTrans.Weight; //salesLine.getGrossWeightPerItem();
                dboSalesAcrossOpsAndRes.SalesLineAmount = salesLine.LineAmount;
                dboSalesAcrossOpsAndRes.ValueByLine = salesLine.LineAmount *
                                                            custInvoiceTrans.Qty;

                dboSalesAcrossOpsAndRes.ValueByWeight = dboSalesAcrossOpsAndRes.Weight *
                                                            dboSalesAcrossOpsAndRes.SalesOrderedQty;

                dboSalesAcrossOpsAndRes.insert();
            ttsBegin;
                custInvoiceTrans.modifiedField(fieldNum(CustInvoiceTrans, DBOProcessed));
                custInvoiceTrans.DBOProcessed = true;
                custInvoiceTrans.update();
            ttsCommit;
                //open form DBOSalesAcrossOpsAndRes
                args = new Args(formStr(DBO_SalesAcrossOpsAndRes));
                formRun = classFactory.formRunClass(args);
                formRun.init();
                formRun.run();

                formRun.detach();


            }

Quick Links