Observer not saving insert on another model

@rubendn Based on the code you have provided, it looks like you are on the right track. The save() method should persist the data in the database. However, there could be a few things that are causing the data not to be saved.

One possible issue could be that there is a validation rule on the InventoryChange model that is preventing the data from being saved. You can try temporarily disabling any validation rules to see if this is the issue by using the saveQuietly() method instead of save().

Another possible issue could be related to the database transaction. When you save data to the database, Laravel wraps the operation in a transaction. If an error occurs during the transaction, the data will not be saved. You can try disabling the transaction by using the saveOrFail() method instead of save().

Here's an updated version of your code that uses saveQuietly() and saveOrFail() to see if either of these solutions works:

public function updated(Item $item): void
{
    if($item->ItemQuantity <> $item->getOriginal('ItemQuantity')){
        $InventoryChange = new InventoryChange;
        $InventoryChange->ItemID = $item->ItemID;
        $InventoryChange->InventoryChangeNote = session('InventoryChangeNote');
        $InventoryChange->Quantity = $item->ItemQuantity - $item->getOriginal('ItemQuantity');
        $InventoryChange->saveQuietly(); // try disabling validation rules
        // $InventoryChange->saveOrFail(); // try disabling transaction
        dd('Item Quantity New: ' . $item->ItemQuantity . ' : ' . 'Item Quantity Old: ' . $item->getOriginal('ItemQuantity') . ' : ' . 'Session: ' . session('InventoryChangeNote') . ' : ItemID: ' . $item->ItemID . " : Change Amount: " . $item->ItemQuantity - $item->getOriginal('ItemQuantity'));
        session(['InventoryChangeNote' => '']);
    }
}

If neither of these solutions works, it may be helpful to check the database logs or error logs to see if there are any errors or exceptions being thrown when you try to save the data.

@rubendn

the table columns all named like this ?

ItemID
InventoryChangeNote
Quantity

or

item_id
inventory_change_note
quantity

check both model $fillable is correct

if you wrap $item->save() in Transaction in controller, your code should work

    public function updated(Item $item): void
    {
        if($item->ItemQuantity <> $item->getOriginal('ItemQuantity')){
            $InventoryChange = new InventoryChange;
            $InventoryChange->ItemID = $item->ItemID;
            $InventoryChange->InventoryChangeNote = session('InventoryChangeNote');
            $InventoryChange->Quantity = $item->ItemQuantity - $item->getOriginal('ItemQuantity');
            $InventoryChange->save();

            session(['InventoryChangeNote' => '']);
        }
    }

after $InventoryChange->save();, getOriginal() is useless.

@newbie360 It is working now. Issue was the DD I was using for troubleshooting was not allowing the DB transaction of the Item Update to commit.