Error in Financial Statement (Could not retrieve the information for [Account Name]

ERPNext Reports
1

I am getting the error in financial statements like balance sheet, profit and loss, cash flow. If any body encountered similar issue and fixed them please let me know how can it be fixed.

Screenshot

image

Error Log

   Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 61, 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 56, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1036, in call
    return fn(*args, **newargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 511, in wrapper_fn
    retval = fn(*args, **get_newargs(fn, kwargs))
  File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py", line 201, in run
    result = generate_report_result(report, filters, user)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py", line 76, in generate_report_result
    res = frappe.get_attr(method_name)(frappe._dict(filters))
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/cash_flow/cash_flow.py", line 27, in execute
    accumulated_values=filters.accumulated_values, ignore_closing_entries=True, ignore_accumulated_values_for_fy= True)
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py", line 152, in get_data
    accounts_by_name, gl_entries_by_account, period_list, accumulated_values, ignore_accumulated_values_for_fy)
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py", line 178, in calculate_values
    raise_exception=1
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 346, in msgprint
    _raise_exception()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 317, in _raise_exception
    raise ValidationError(msg)
ValidationError: Could not retrieve information for 20001 - Trade Payable AED - S.

I run the bench update, to check if this will fix the problem, but it didn’t fix the error.

ERPNext: v11.1.46 (master)
Frappe Framework: v11.1.41 (master)
Error: Could not retrieve information for [Account Name]

Affected Reports: Balance sheet, profit and loss report for a particular company only. Reports for all the companies are not affected.

The account is present in chart of account, and the transactions on particular account can also be seen in general ledger report.

Any suggestions are most welcome.

Regards,
Koshish Koirala

2

Did you find any work arround?

3

Happened to us and solution is elsewhere in the forum. Forget where so sorry cannot attribute correctly.

Solution is a hack, worked for us. Create a new account with similar details. Go to account named in your error and merge it into the new account (which has no transactions, but no problems). You can then rename the account back to what you had originally if that is important

1 Like
4

The solution worked. Thanks a lot.

5

Thank you, worked for us as well!