We have an issue with stock availibility
The MRP system works well, creating new shop orders when customers place an order giving an availibility date that is generally correct.
However, we have an issue if the products fail testing. The customer orders cannot be honoured and its quite a task to undo and warn the customer.
We have created a quick report which shows customer orders affected when shop order dates are changed. Now we would like an event which fires when dates are changed on the shop order, it runs the quick report and emails it to users.
Is it possible for an event to run a quick report and email out?