I’m creating a stock manager, but I’m finding it difficult to return the item to stock, I’m not finding a way to get the quantity that was sent to the event to be added back to stock.
I created a table to register all stock items; I created a table to add all stock issues; and I related the table of events that require the item to the inventory departure table.
Hi there, I hope you are doing well.
To return stock for an event, retrieve the issued quantity from the Stock Issues Table and add it back to the Stock Items Table. Mark it to avoid duplicates, and consider automating with a stored procedure or trigger.
Thanks,
Mike Taku.