thanks for reply Samir,  I found this sample code and adapted in my module , it updates the on hand quantity properly but left the stock records like something still pending.

here the code

[CODE UPDATED!] now works fine

warehouse = self.env['stock.warehouse'].search([('code', '=', 'T006')],limit=1)



new_quantity = 742

for product in products:

self.env['stock.quant'].with_context(inventory_mode=True).create({

'product_id': product.id,

'inventory_quantity': new_quantity,

'location_id': warehouse.lot_stock_id.id,

}).action_apply_inventory()