DannyC wrote:Do I need to write a separate code block for GRN activation, shipment book-in activation, transfer activation, inventory transaction import, sales order credits, and every other event that writes to IN_SOH?
Yep.
DannyC wrote:I could write a trigger on the database on INSERT, but I'd always thought SQL triggers are somewhat frowned upon.
We dislike them because where sites are poorly documented, these types of things get forgotten about. Use them at your own peril... if it is documented well it shouldn't be a problem.
We recommend sites have their own
Confluence (free for up to 10 users) to document their business specific workflows with Jiwa, and within that a page for "Upgrade Checklist and Prerequsites" which, if there are triggers, should have a step to disable triggers before upgrade, and another to enable them afterwards.