Hi,
I am developing stock control system.
I would like to know, where should I place the code of increase/decrease stock?
Do you think place code in insert/update/delete trigger in every relevant table such as stockin, sales, good return and etc to increase/decrease stock qty is a good ideas?
What about place it in data object .. and real world sample?

Thank you