@Ron_Taylor - Currently, one cannot send Report when price is changed. But, it is possible to send the record (for example “Item Price” in this case) when it is changed. Let me know if it would serve the purpose, and further help required.
As far as informing for “stock going below reorder level”, it automatically creates “Material Request”, when stock goes below reorder level. You may create alert when New Material Request is created alternatively.
The problem with the Material Request is that it can only be accessed one a day after the system creates it - at midnight. So we are looking for a way to inform production of a shortage as soon as the order is made.
Hi @Ron_Taylor! You can definitely use Email Alerts for this kind of situation! I have 2 suggestions.
I suggest you create a validation that checks every time you do delivery if the item is under re-order level. Then you can use a trigger like a custom check box field within your Delivery Note Item doctype that will tell you it is already for ordering. Then you use that for your condition in the Email Alerts.
Since you don’t prefer the automatic creation of the Material Request as mentioned by @Deven_Shah, you can actually modify this one. You trace the code for this and copy it under you app and call in in hooks. Put in under “scheduler_events” in “all”. This way, it will always check every 3 minutes. Thus, when re-order level is reach, it will automatically creates the Material request without waiting for the next day.
Hi @Ron_Taylor! Do you have access with your Python scripts under your custom App? You can make changes there. As on how to create Pyhton scripts, you can see a lot of examples here in some of the discussions. As for the information about hooks, you can see this link here under Scheduler Events https://frappe.github.io/frappe/user/en/guides/basics/hooks