Dear ERPNext forum users,
i face this problem when i check my budget variance report
Traceback (most recent call last):
File “/home/egteuser/frappe-bench/apps/frappe/frappe/app.py”, line 55, in application
response = frappe.handler.handle()
File “/home/egteuser/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/home/egteuser/frappe-bench/apps/frappe/frappe/handler.py”, line 36, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/egteuser/frappe-bench/apps/frappe/frappe/init.py”, line 882, in call
return fn(*args, **newargs)
File “/home/egteuser/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 88, in run
res = frappe.get_attr(method_name)(frappe._dict(filters))
File “/home/egteuser/frappe-bench/apps/erpnext/erpnext/accounts/report/budget_variance_report/budget_variance_report.py”, line 17, in execute
cam_map = get_cost_center_account_month_map(filters)
File “/home/egteuser/frappe-bench/apps/erpnext/erpnext/accounts/report/budget_variance_report/budget_variance_report.py”, line 109, in get_cost_center_account_month_map
actual_details = get_actual_details(ccd.cost_center, filters.fiscal_year)
File “/home/egteuser/frappe-bench/apps/erpnext/erpnext/accounts/report/budget_variance_report/budget_variance_report.py”, line 82, in get_actual_details
cc_lft, cc_rgt = frappe.db.get_value(“Cost Center”, cost_center, [“lft”, “rgt”])
TypeError: ‘NoneType’ object is not iterable
please any solution for this?thanks
Hi @Sachine_P1
Seems that cost center is missing in the budget, can you check cost center is defined against all the budgets
i have created cost centers,by default it takes “main cost”, and also i have defined budget for all cost centers !
i have created cost centers,by default it takes “main cost”, and also i have defined budget for all cost centers !
Hi @Sachine_P1,
I am able to replicate the issue, we have fixed the issue and soon we’ll release the fix
Thanks
ok thanks shall i wait he fix or your replay here?