New stock entry for sales return is error

[Bobby Hartanto]

Hi ,


I just got the following error :
Step to reproduce :
1. login
2. stock > stock entry > new
3. set prupose to be sales return
4. choose a delivery note / sales order

on my javascript console showing this error :

Traceback (innermost last):
  File "/root/frappe-bench/apps/frappe/frappe/app.py", line 46, in application
    response = frappe.handler.handle()
  File "/root/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
    execute_cmd(cmd)
  File "/root/frappe-bench/apps/frappe/frappe/handler.py", line 84, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/root/frappe-bench/apps/frappe/frappe/__init__.py", line 521, in call
    return fn(*args, **newargs)
  File "/root/frappe-bench/apps/erpnext/erpnext/stock/doctype/stock_entry/stock_entry.py", line 591, in get_party_details
    ["customer", "customer_name", "address_display as customer_address"], as_dict=1)
  File "/root/frappe-bench/apps/frappe/frappe/database.py", line 300, in get_value
    ret = self.get_values(doctype, filters, fieldname, ignore, as_dict, debug)
  File "/root/frappe-bench/apps/frappe/frappe/database.py", line 317, in get_values
    return self.get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update)
  File "/root/frappe-bench/apps/frappe/frappe/database.py", line 390, in get_values_from_table
    conditions, order_by), filters, as_dict=as_dict, debug=debug, update=update)
  File "/root/frappe-bench/apps/frappe/frappe/database.py", line 107, in sql
    self._cursor.execute(query, values)
  File "/root/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/root/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 OperationalError: (1054, "Unknown column 'address_display as customer_address' in 'field list'")

i dont have idea what should i do ?
anyway its still a fresh install erpnext im updated the scipt like 4 hours ago



Thanks,
Bobby

[Nabin Hait]

Pushed the fixes.

--
Note:
 
If you are posting an issue,
1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/6224cff8-59fd-48c8-901c-f3f7cb5912af%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.