Purchase Reciept Submit Error

[krishnanhemanth]

Hi Iam not able Submit a Purchase Reciept This is a scenario I create a purchase order for subcontracting do stock entry - selected subcontract - get items from Purchase order submit the stock entry then while recieving the material from subcontract i create a Purchase Reciept - select Get items from PO save submit ---- it dosent submit I get the following error Traceback (most recent call last): File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/save.py", line 19, in savedocs doc.submit() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 741, in submit self._submit() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 730, in _submit self.save() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 230, in save return self._save(*args, kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 280, in _save self.run_post_save_methods() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 793, in run_post_save_methods self.run_method("on_submit") File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 666, in run_method out = Document.hook(fn)(self, *args, *kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 887, in composer return composed(self, method, args, kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 870, in runner add_to_return_value(self, fn(self, *args, kwargs)) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 660, in fn = lambda self, args, kwargs: getattr(self, method)(args, kwargs) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/doctype/purchase_receipt/purchase_receipt.py", line 135, in on_submit self.make_gl_entries() File "/home/frappe/frappe-bench/apps/erpnext/erpnext/controllers/stock_controller.py", line 30, in make_gl_entries make_gl_entries(gl_entries, from_repost=from_repost) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py", line 19, in make_gl_entries save_entries(gl_map, adv_adj, update_outstanding, from_repost) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py", line 88, in save_entries make_entry(entry, adv_adj, update_outstanding, from_repost) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py", line 99, in make_entry gle.insert() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 192, in insert self.run_before_save_methods() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 772, in run_before_save_methods self.run_method("validate") File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 666, in run_method out = Document.hook(fn)(self, *args, *kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 887, in composer return composed(self, method, args, kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 870, in runner add_to_return_value(self, fn(self, *args, kwargs)) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 660, in fn = lambda self, args, kwargs: getattr(self, method)(args, **kwargs) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/gl_entry/gl_entry.py", line 27, in validate self.validate_currency() File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/gl_entry/gl_entry.py", line 119, in validate_currency account_currency = get_account_currency(self.account) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/account/account.py", line 233, in get_account_currency return frappe.local_cache("account_currency", account, generator) File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 1284, in local_cache local.cache[namespace][key] = generator() File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/account/account.py", line 227, in generator account_currency, company = frappe.db.get_value("Account", account, ["account_currency", "company"]) TypeError: 'NoneType' object is not iterable

Traceback (most recent call last): File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 56, in application response = frappe.handler.handle() File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 21, in handle data = execute_cmd(cmd) File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 52, in execute_cmd return frappe.call(method, frappe.form_dict) File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 913, in call return fn(*args, *newargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/save.py", line 19, in savedocs doc.submit() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 741, in submit self._submit() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 730, in _submit self.save() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 230, in save return self._save(args, kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 280, in _save self.run_post_save_methods() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 793, in run_post_save_methods self.run_method("on_submit") File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 666, in run_method out = Document.hook(fn)(self, *args, kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 887, in composer return composed(self, method, *args, *kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 870, in runner add_to_return_value(self, fn(self, args, kwargs)) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 660, in fn = lambda self, args, kwargs: getattr(self, method)(args, kwargs) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/doctype/purchase_receipt/purchase_receipt.py", line 135, in on_submit self.make_gl_entries() File "/home/frappe/frappe-bench/apps/erpnext/erpnext/controllers/stock_controller.py", line 30, in make_gl_entries make_gl_entries(gl_entries, from_repost=from_repost) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py", line 19, in make_gl_entries save_entries(gl_map, adv_adj, update_outstanding, from_repost) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py", line 88, in save_entries make_entry(entry, adv_adj, update_outstanding, from_repost) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py", line 99, in make_entry gle.insert() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 192, in insert self.run_before_save_methods() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 772, in run_before_save_methods self.run_method("validate") File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 666, in run_method out = Document.hook(fn)(self, *args, kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 887, in composer return composed(self, method, *args, *kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 870, in runner add_to_return_value(self, fn(self, args, kwargs)) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 660, in fn = lambda self, args, kwargs: getattr(self, method)(args, kwargs) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/gl_entry/gl_entry.py", line 27, in validate self.validate_currency() File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/gl_entry/gl_entry.py", line 119, in validate_currency account_currency = get_account_currency(self.account) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/account/account.py", line 233, in get_account_currency return frappe.local_cache("account_currency", account, generator) File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 1284, in local_cache local.cache[namespace][key] = generator() File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/account/account.py", line 227, in generator account_currency, company = frappe.db.get_value("Account", account, ["account_currency", "company"]) TypeError: 'NoneType' object is not iterable

i use INR as currency I do not use multicurrency Regards Hemanth

[rohitwaghchaure]

Hi @krishnanhemanth It seems that somehow account coming as None, can you please check account has assigned to the warehouse.

[krishnanhemanth]

Thanks rohitwaghchaure Could you please tell me how to check it i checked in the warehouse tree... the particular warehouse is not listed in the tree how do i assign an already created warehouse to accounts Thanks again hemanth

[rohitwaghchaure]

You can set the account in the warehouse or in the company(Default Inventory Account). To set the account in the warehouse check below link GIF

[krishnanhemanth]

Thanks for the Tip I assigned account to warehouse but the issue is not resolved it still is throwing up the same error Regards

[krishnanhemanth]

The issue seems to be only with Purchase Reciept There is no issues in creating a Purchase Invoice Regards Hemanth

[TipBioSystemsUser]

We're facing the same issue.. Cross-posting it.

https://discuss.erpnext.com/t/typeerror-nonetype-object-is-not-iterable-while-creating-a-purchase-receipt/25991

[umairsy]

Working fine in the test account. Please post this issue on the ERPNext community forum for continued support.

https://discuss.erpnext.com

[krishnanhemanth]

Hi Umairsy after doing a lot of testing with data, i have around 16 accounts under stock assets >>All Warehouses of the 16, in one account iam able to create Purchase Reciept without any error but all the remaning 15 accounts throws up the above error not able to figure out whats wrong any inputs please

[TipBioSystemsUser]

Hi Hemanth, Have you progressed any with the problem? I am still facing the exact same issue. Best Timo

[krishnanhemanth]

Hi TipBioSystemsUser No I couldnt solve the issue i downloaded a fresh instance of .OVA file and i have started the entire thing afresh for the last few days, i have been putting back my records on the fresh i stallation Hope at least it works now have spent lots of sleepless nights regards Hemanth

[TipBioSystemsUser]

It seems to be arising due to python coding error. https://stackoverflow.com/questions/41919651/python-unable-to-run-program

Hemanth, did you get any luck with it?