Hi,
Our company has just started working with ERPNext for this year 2023 and during the entering of the Opining balances for the Fixed Assets we get an error whenever we try to open the Asset module, and the Chart of the Account never get affected when I ignore this error and create a new Fixed asset.
could someone please help with this error?
Thanks a lot
“frappedesk”: “0.5.9”,
“hrms”: “1.0.0”,
“lms”: “0.0.1”,
“payments”: “0.0.1”
}
### Route
Workspaces/Assets
### Trackeback
Traceback (most recent call last):
File “apps/frappe/frappe/app.py”, line 69, in application
response = frappe.api.handle()
File “apps/frappe/frappe/api.py”, line 54, in handle
return frappe.handler.handle()
File “apps/frappe/frappe/handler.py”, line 45, in handle
data = execute_cmd(cmd)
File “apps/frappe/frappe/handler.py”, line 83, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “apps/frappe/frappe/init.py”, line 1590, in call
return fn(*args, **newargs)
File “apps/frappe/frappe/init.py”, line 784, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File “apps/frappe/frappe/desk/query_report.py”, line 251, in run
result = generate_report_result(report, filters, user, custom_columns, is_tree, parent_field)
File “apps/frappe/frappe/init.py”, line 784, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File “apps/frappe/frappe/desk/query_report.py”, line 87, in generate_report_result
res = get_report_result(report, filters) or []
File “apps/frappe/frappe/desk/query_report.py”, line 68, in get_report_result
res = report.execute_script_report(filters)
File “apps/frappe/frappe/core/doctype/report/report.py”, line 142, in execute_script_report
res = self.execute_module(filters)
File “apps/frappe/frappe/core/doctype/report/report.py”, line 159, in execute_module
return frappe.get_attr(method_name)(frappe._dict(filters))
File “apps/erpnext/erpnext/assets/report/fixed_asset_register/fixed_asset_register.py”, line 21, in execute
prepare_chart_data(data, filters)
File “apps/erpnext/erpnext/assets/report/fixed_asset_register/fixed_asset_register.py”, line 151, in prepare_chart_data
labels_values_map[belongs_to_month].asset_value += d.get(“asset_value”)
KeyError: ‘Jan 2023’
### Request Data
{
“type”: “POST”,
“args”: {
“report_name”: “Fixed Asset Register”,
“filters”: “{"status":"In Location","filter_based_on":"Fiscal Year","period_start_date":"2020-04-01","period_end_date":"2021-03-31","date_based_on":"Purchase Date","group_by":"–Select a group–","company":"Rikaz for Advanced Business Co. Ltd.","from_fiscal_year":"2023-2024","to_fiscal_year":"2023-2024","from_date":"2022-01-28","to_date":"2023-01-28"}”,
“ignore_prepared_report”: 1
},
“headers”: {},
“error_handlers”: {},
“url”: “/api/method/frappe.desk.query_report.run”
}
### Response Data
{
“exception”: “KeyError: ‘Jan 2023’”
}
