When you instantiate the objINItemXRef, instead of doing a PXSelect, try to search the itemxrefrecords view, there by when you later update the view with that object, the key values match exactly.

Like-

INItemXRef objINItemXRef = Base.itemxrefrecords.Search<INItemXRef.inventoryID, INItemXRefCExt.usrCAltIDExists, INItemXRef.alternateType>(row.InventoryID, boolTrue, INAlternateType.global);

 

//…

//make update to the necessary fields

//...

Base.itemxrefrecords.Cache.Update(objINItemXRef);

Hi @Raj Gopinathan  Is it possible to share the sample code?

Yup, I accidentally hit send before updating example. Updated now.

Hi @Raj Gopinathan  As suggested, I have tried with the below code and it is also behaving the same.

It is creating a new record instead of updating.

  INItemXRef objINItemXRef = Base.itemxrefrecords.Search<INItemXRef.inventoryID,
                            INItemXRefCExt.usrCAltIDExists, INItemXRef.alternateType>(row.InventoryID, true, INAlternateType.Global);

                        if (objINItemXRef != null)
                        {
                            INItemXRefCExt refExt = objINItemXRef.GetExtension<INItemXRefCExt>();


                            if (objINItemXRef.InventoryID == row.InventoryID && refExt.UsrCAltIDExists == true && objINItemXRef.AlternateType == INAlternateType.Global)
                            {
                                objINItemXRef.AlternateID = objCSAnswers.Value.Trim();
                                Base.itemxrefrecords.Cache.Update(objINItemXRef);
                            }
                        }

Oh! Also do Base.itemxrefrecords.Update(objINItemXRef) instead of Base.itemxrefrecords.Cache.Update(objINItemXRef).

Also add a line after that as follows:

Base.itemxrefrecords.Cache.Persist(PXDBOperation.Insert);

Let me know if that helps.

Sorry about multiple edits, I’ve not tested these code suggestions, I’m just thinking and making suggestions.

Hi @nsmith51 ,

Cross reference allows for adding multiple records. So we need to use the for each loop to load all details and add the logic to update the data. Try like below

                       foreach (INItemXRef CrossRef in Base.itemxrefrecords.Select())
                        {

                     // Write the logic to get the values and assign them to the field like below and update the view.

                           CrossRef.AlternateID = objCSAnswers.Value.Trim();

                                Base.itemxrefrecords.Update(CrossRef);
                            }
                        }
 

Hi @Raj Gopinathan  Thanks for the replies.

I have received an response from Acumatica team, that AlternateID is a Key so that we need to delete and insert the record instead of updating.

Here is the example.

       Base.itemxrefrecords.Current = Base.itemxrefrecords.Search<INItemXRef.inventoryID, INItemXRef.subItemID, INItemXRef.alternateType, INItemXRef.bAccountID, INItemXRef.alternateID>
              (objINItemXRef.InventoryID, objINItemXRef.SubItemID, objINItemXRef.AlternateType, objINItemXRef.BAccountID, objINItemXRef.AlternateID);


                            INItemXRef newCrossRef = new INItemXRef();
                            newCrossRef.InventoryID = Base.itemxrefrecords.Current.InventoryID;
                            newCrossRef.AlternateType = Base.itemxrefrecords.Current.AlternateType;
                            newCrossRef.SubItemID = Base.itemxrefrecords.Current.SubItemID;
                            newCrossRef.AlternateID = "1217";
                            newCrossRef.BAccountID = Base.itemxrefrecords.Current.BAccountID;


                           Base.itemxrefrecords.Delete(Base.itemxrefrecords.Current);
                           Base.itemxrefrecords.Cache.Insert(newCrossRef);

Thank you for sharing the solution @nsmith51 !