search

frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
19.75k stars 7k forks source link

[Bug] Unable to View Balance Sheet #8088

Closed addymuliady closed 7 years ago

addymuliady commented 7 years ago

Hi,

Faced with the following prompt when trying to view Balance Sheet. https://discuss.erpnext.com/t/balance-sheet-giving-error-on-opening/14423/7

Traceback (most recent call last): File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 55, in application response = frappe.handler.handle() File "/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py", line 19, in handle execute_cmd(cmd) File "/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py", line 36, in execute_cmd ret = frappe.call(method, *frappe.form_dict) File "/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py", line 890, in call return fn(args, **newargs) File "/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/query_report.py", line 93, in run res = frappe.get_attr(method_name)(frappe._dict(filters)) File "/home/ubuntu/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/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py", line 128, in get_data calculate_values(accounts_by_name, gl_entries_by_account, period_list, accumulated_values, ignore_accumulated_values_for_fy) File "/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py", line 148, 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'

rohitwaghchaure commented 7 years ago

Hi @addymuliady

Can you share the screenshots of your fiscal year, basically I want to see the start date and end date on the fiscal year

addymuliady commented 7 years ago

Hi @rohitwaghchaure

Thank you for picking this up.

2016 image

2017 image

addymuliady commented 7 years ago

Hi @rohitwaghchaure

Any updates on this issue? Critical.

GSLabIt commented 7 years ago

@addymuliady are u still facing the issue?

addymuliady commented 7 years ago

@joezsweet issue recently resolved as warehouse was in the wrong account type. It was supposed to be an Asset account type but user managed to change it to Expense account type.