I am having the following problem, i have made two different items for the same thing, and now i am trying to remove one of them, i cant delete because the item is linked to a sales invoice, so i tried to rename and mark "merge with existing" and nothing happens. I have renamed other items and merged and had no problems, but for this one its not working.
The console is showing the following error:
Traceback (innermost last):
File "../lib/webnotes/handler.py", line 113, in handle
execute_cmd(cmd)
File "../lib/webnotes/handler.py", line 153, in execute_cmd
ret = call(method, webnotes.form_dict)
File "../lib/webnotes/handler.py", line 170, in call
return fn(**newargs)
File "../lib/webnotes/model/rename_doc.py", line 29, in rename_doc
new = obj.on_rename(new, old, merge) or new
File "../app/stock/doctype/item/item.py", line 275, in on_rename
update_entries_after({"item_code": newdn, "warehouse": wh})
File "../app/stock/stock_ledger.py", line 29, in update_entries_after
previous_sle = get_sle_before_datetime(args)
File "../app/stock/stock_ledger.py", line 106, in get_sle_before_datetime
"desc", "limit 1", for_update=for_update)
File "../app/stock/stock_ledger.py", line 135, in get_stock_ledger_entries
}, args, as_dict=1)
File "../lib/webnotes/db.py", line 111, in sql
raise e
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n\t\tand ifnull(is_cancelled, 'No') = 'No'\n\t\tand timestamp(posting_date, posting_' at line 3")
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.