I am trying to create a standard reply when creating an invoice email.
Most of the information I can pull from the Sales Invoice, but I am trying to also pull one field that is from the Sales Order, status. Is there a way I can reference the Sales Order on the Standard Reply. I tried using {{ frappe.db.get_value(“Sales Order”, doc.name, “status” ) }}, but am getting an error:
Traceback (most recent call last):
File “/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/app.py”, line 62, in application
response = frappe.handler.handle()
File “/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/handler.py”, line 22, in handle
data = execute_cmd(cmd)
File “/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/handler.py”, line 53, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/init.py”, line 939, in call
return fn(*args, **newargs)
File “/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/email/doctype/standard_reply/standard_reply.py”, line 22, in get_standard_reply
“message” : frappe.render_template(standard_reply.response, doc)}
File “/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/utils/jinja.py”, line 69, in render_template
return get_jenv().from_string(template).render(context)
File “/opt/bitnami/apps/erpnext/htdocs/venv/lib/python2.7/site-packages/jinja2/environment.py”, line 880, in from_string
return cls.from_code(self, self.compile(source), globals, None)
File “/opt/bitnami/apps/erpnext/htdocs/venv/lib/python2.7/site-packages/jinja2/environment.py”, line 591, in compile
self.handle_exception(exc_info, source_hint=source_hint)
File “/opt/bitnami/apps/erpnext/htdocs/venv/lib/python2.7/site-packages/jinja2/environment.py”, line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File “”, line 1, in template
TemplateSyntaxError: unexpected ‘<’
Has anyone come across this situation?
Thank you.
JR