1 person found this helpful
Without Inventory Module, it's not possible to track the stock. You have to develop the custom solution for that
You can create one database Trigger on MTL_MATERIAL_TRANSACTIONS table.
One new record is adding with transaction type in this table for each inventory transaction.
For Transaction Types, Review the Oracle standard table : MTL_MATERIAL_TRANACTIONS.
Create one custome table : XX_MTL_STOCK
CREATE OR REPLACE TRIGGER XX_MTL_STOCK_TRIG
FOR EACH ROW
IF :new.transaction_type_id = 18 /* PO Receipt txn */
-- logic to Add stock to table xX_MTL_STOCK for that item & inventory org.
ELSIF :new.transaction_type_id = 33 /* sales order issue txn */
-- logic to Less stock from table xX_MTL_STOCK for that item & inventory org.
One doubt to me is that MTL_MATERIAL_TRANSACTIONS is not available if you have not installed the inventory module. please check your end.