Question regarding "Date Change" alert

Hi all,

I have got a question regarding Date Change alert.

We are working with quotations…what I want is an email alert when the quotation (transaction_date) reaches a specific age … e.g. 5 days.

Means…we submit it on 20th January and on 25th January the system sends a reminder to remind the customer.


Set days in advance to -5


Thanks mate…this was my first guess…I will try and report :slight_smile:

Hi @rmehta

I tried it with the following setup:

DocType: Quotation
Date Change: transaction_date
Days in Advance: -1

And I read, it should send out the mail at midnight? It didn’t!

Is your scheduler working? did you check your the Scheduler Log?

I think negative date should be fine.

That looks ok.

Here is the last Error from the Scheduler Log:

Method: daily, Handler: erpnext.controllers.recurring_document.create_recurring_documents
Traceback (innermost last):
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/", line 77, in scheduler_task
  File "/home/erpnext/frappe-bench/apps/erpnext/erpnext/controllers/", line 25, in create_recurring_documents
    manage_recurring_documents("Purchase Order")
  File "/home/erpnext/frappe-bench/apps/erpnext/erpnext/controllers/", line 40, in manage_recurring_documents
    and next_date <= ifnull(end_date, '2199-12-31')""".format(doctype, next_date))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/", line 121, in sql
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 OperationalError: (1054, "Unknown column 'recurring_id' in 'field list'")

You need run bench update - seems like the patches have not been executed.

– deleted post —

I’ll repost in a minute