Does anyone know the API to update Item quantities in the subinventories? I found one named "inv_quantity_tree_pub.update_quantities", but according to the comments in the package, it will not update the database.
Basically I just want to update the Item quantities from the database. I will be so thankful if anyone shows me an API like this or just get me another similar way to do that.
Thanks very much!
you will need to populate data in MTL_TRANSACTIONS_INTERFACE table with transaction_type_id as 42 (Miscellaneous Receipt)
You will need to provide an org, item, subinventory, quantities, uoms, account (that will get credited).
If item is lot controlled, you will also need to populate mtl_transacion_lots_interface table.