Want to update the Item in the Database using Event

Hi ​@anupusefulbi,

What is ALLInventory  in your code? Have you created custom DAC named ALLInventory ?

alongside ​@Nilkanth Dipak  comment, you can use e.Cache.SetValueExt<YourDAC.yourField>(row, YourValue) to update the DB.

​@anupusefulbi 

One of the options to update a database record in Acumatica is by using PXDatabase.Update. This provides a direct way to modify a record in the database.

So, if you need to update a value directly, you can use it like this:

PXDatabase.Update<MyTable>(new PXDataFieldParam[]
{
    new PXDataFieldAssign(nameof(MyTable.Field), "FieldValue"),
    new PXDataFieldRestrict(nameof(MyTable.Key1), "Key1Value"),
    new PXDataFieldRestrict(nameof(MyTable.Key2), "Key2Value"),
});

This approach bypasses the DAC and graph logic, so be sure to use it carefully, especially when business logic or events (like RowUpdated) are involved.

Hi ​@anupusefulbi,

For updating inventory item:

           InventoryItemMaint itemGraph = PXGraph.CreateInstance<InventoryItemMaint>();
           InventoryItem item = PXSelect<InventoryItem,
Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>.Select(itemGraph, line.TSItem);

           if (item != null)
           {
               item.HSTariffCode = row.TSCommodity;
               itemGraph.Item.Update(item);
               itemGraph.Actions.PressSave();
           }

For refresh:

this.yourviewname.View.RequestRefresh();

Hope this helps!