Push Script for updating the value in another document

SAJOIJOM · January 29, 2015, 7:55am

Hi,
I am looking for push script to update a value in a previous document from a current document. To explain - We are using the hosted version of ERP Next and so only custom java scripts can be used for customization.
We have process flow from opportunity to quotation to sales order. Once sales order is submitted, we would like to update the source opportunity custom field as “order processed”. this field is allowable on submit.
As per the concept, we believe it has to be done via a custom script by pushing the value from sales order. But please help us how to do it. (I am a bit weak in development ).

rmehta · January 29, 2015, 9:41am

The best way to do this would be to add this in the on_update event of Sales Order.

There is already a method for this but it is not called (?)

github.com

frappe/erpnext/blob/develop/erpnext/selling/doctype/sales_order/sales_order.py#L139


      
          
          
	def validate_sales_mntc_quotation(self):
          		for d in self.get("items"):
          			if d.prevdoc_docname:
          				res = frappe.db.sql(
          					"select name from `tabQuotation` where name=%s and order_type = %s",
          					(d.prevdoc_docname, self.order_type),
          				)
          				if not res:
          					frappe.msgprint(_("Quotation {0} not of type {1}").format(d.prevdoc_docname, self.order_type))
          
          
	def validate_delivery_date(self):
          		if self.order_type == "Sales" and not self.skip_delivery_note:
          			delivery_date_list = [d.delivery_date for d in self.get("items") if d.delivery_date]
          			max_delivery_date = max(delivery_date_list) if delivery_date_list else None
          			if (max_delivery_date and not self.delivery_date) or (
          				max_delivery_date and getdate(self.delivery_date) != getdate(max_delivery_date)
          			):
          				self.delivery_date = max_delivery_date
          			if self.delivery_date:
          				for d in self.get("items"):

Please create a GitHub Issue for this and follow up with @neilLasrado - we will fix it in v5.

Thanks!

SAJOIJOM · January 29, 2015, 10:23am

Hi,
As i told you, i am bit weak in the technical side. :). Can i Copy paste this script in the custom script as it is? Or should I update the document names and i can make it work? I am posting it as per your comment in the Github issues.

rmehta · January 30, 2015, 5:25am

This needs to be done on the server side. We will fix it with version 5.