Balance Sheet Giving Error on Opening

Ashish_Dhingra · July 25, 2016, 11:36am

Traceback (most recent call last):
  File "/home/aafpl/frappe-bench/apps/frappe/frappe/app.py", line 55, in application
    response = frappe.handler.handle()
  File "/home/aafpl/frappe-bench/apps/frappe/frappe/handler.py", line 19, in handle
    execute_cmd(cmd)
  File "/home/aafpl/frappe-bench/apps/frappe/frappe/handler.py", line 36, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/home/aafpl/frappe-bench/apps/frappe/frappe/__init__.py", line 876, in call
    return fn(*args, **newargs)
  File "/home/aafpl/frappe-bench/apps/frappe/frappe/desk/query_report.py", line 88, in run
    res = frappe.get_attr(method_name)(frappe._dict(filters))
  File "/home/aafpl/frappe-bench/apps/erpnext/erpnext/accounts/report/balance_sheet/balance_sheet.py", line 13, in execute
    asset = get_data(filters.company, "Asset", "Debit", period_list, only_current_fiscal_year=False)
  File "/home/aafpl/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py", line 109, in get_data
    calculate_values(accounts_by_name, gl_entries_by_account, period_list, accumulated_values)
  File "/home/aafpl/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py", line 127, in calculate_values
    d[period.key] = d.get(period.key, 0.0) + flt(entry.debit) - flt(entry.credit)
AttributeError: 'NoneType' object has no attribute 'get'

tkhamdan · July 26, 2016, 6:43am

+1 on this

Ashish_Dhingra · July 27, 2016, 8:32am

Hi …

Please help on this.

nabinhait · July 27, 2016, 1:14pm

Can’t replicate.

Seems like, somehow the nestedset model for the account tree has been broken. Try to execute rebuild_tree function from Console.

github.com

frappe/frappe/blob/develop/frappe/utils/nestedset.py#L138


      
          	).run()
          
          
	# shift left rgts of ancestors whose only rgts must shift
          	frappe.qb.update(Table).set(Table.rgt, Table.rgt - diff).where(
          		(Table.lft < doc.lft) & (Table.rgt > doc.rgt)
          	).run()
          
          
	if parent:
          		# re-query value due to computation above
          		new_parent = (
          			frappe.qb.from_(Table)
          			.select(Table.lft, Table.rgt)
          			.where(Table.name == parent)
          			.for_update()
          			.run(as_dict=True)[0]
          		)
          
          
		# set parent lft, rgt
          		frappe.qb.update(Table).set(Table.rgt, Table.rgt + diff).where(Table.name == parent).run()
          
          
		# shift right at new parent

Ashish_Dhingra · August 3, 2016, 9:51pm

Hi please suggest how to do the same as the error is still continued.

pdussail · August 8, 2016, 7:22pm

Same error after V7 update, running on ubuntu 14.04

Ashish_Dhingra · August 12, 2016, 3:47pm

Hi ,

Please Help of this issue !!

Ashish_Dhingra · August 23, 2016, 7:23am

Hi ,

Please update the issue !

mulyadi-agtechsg · March 22, 2017, 8:00am

@Ashish_Dhingra any update on this issue? Facing the same problem and raising an issue on Github for this.

https://github.com/frappe/erpnext/issues/8088