Transfer Materials For Production

Hi, i am receiving the following error when executing material transfers.

Traceback (innermost last):
File “/home/erpnext/frappe-bench/apps/frappe/frappe/app.py”, line 51, in application
response = frappe.handler.handle()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py”, line 62, in handle
execute_cmd(cmd)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py”, line 85, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 718, in call
return fn(args, **newargs)
File “/home/erpnext/frappe-bench/apps/erpnext/erpnext/manufacturing/doctype/production_order/production_order.py”, line 326, in make_stock_entry
production_order = frappe.get_doc(“Production Order”, production_order_id)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 470, in get_doc
return frappe.model.document.get_doc(arg1, arg2)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 45, in get_doc
return controller(arg1, arg2)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 76, in init
self.load_from_db()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 104, in load_from_db
d = frappe.db.get_value(self.doctype, self.name, "
", as_dict=1)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 390, in get_value
ret = self.get_values(doctype, filters, fieldname, ignore, as_dict, debug)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 425, in get_values
return self._get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 516, in _get_values_from_table
conditions, order_by), values, as_dict=as_dict, debug=debug, update=update)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 129, in sql
self._cursor.execute(query, values)
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
ValueError: month must be in 1…12

My system is updated, as well as virtual box.

Any help will be greatly appreciated.

Regards,
Tjommie

@DieTjommie does it persist, can you reproduce it? We have never been able to replicate this in a test system/

Yes the issue persists. Please note that this is a instance that has been copied from another one. Could that be the issue?

This occurs on the original system as well.

Can you share a screenshot of the date values?

Morning,

Have you had any luck on reproducing the issue?
What should my course of action be? Create a new instance? How would I know that this wont occur again?

Regards
Tjommie

Still unable to replicate. what is your date format under system settings ?

Date format:
dd/mm/yyyy
Number Format:

###.##

Float Precision:
3

I hope this helps.

Excuse the number format, I don’t know what happened there. But if you need it, it is: # ###.##

I was trying to complete the setup of a new instance to see if the problem persist there and I came across the following error. Any insights as to what is going on here?

Hey did you import the Production Order via Data Import Tool ?

Also the screenshot of the production order that you earlier send is not saved. send me a screen shot of the submitted production order which is giving errors. I want to verify the format of the date values in the production order.

Also try to Stop the production order and confirm if you still get the error on clicking stop.