Frustration of settingup CoA in ERPNext

ERPNext Accounting
1

Hi all.

I am a new user of ERPNext and I installed ERPNext on my homeserver, hoping to use it for my small business accounting and management.

However, after a few days trying to setting up the COAs in ERPNext, I just can’t get it to work.

Here are what I’ve done so far and why it frustrate me.

  1. I can’t add a company with blank COA. Even if I already choose blank template, there are still entries in the COA for the new company.

  2. Editing COAs from the web interface is so cumbersome, I have to delete a non-group account first and then convert the group account to be non-group, then I can delete that one too.

  3. So I have also tried COA Importer tool. I download the Template from the page of COA Importer, and just translate the contents of the csv into my desired language. I didn’t add anything or remove anything. Then I tried to import it… Here is the error log:

App Versions

{
	"erpnext": "16.0.0-dev",
	"frappe": "16.0.0-dev"
}

Route

Form/Chart of Accounts Importer/Chart of Accounts Importer

Traceback

Traceback (most recent call last):
  File "apps/frappe/frappe/app.py", line 114, in application
    response = frappe.api.handle(request)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/api/__init__.py", line 49, in handle
    data = endpoint(**arguments)
           ^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/api/v1.py", line 36, in handle_rpc_call
    return frappe.handler.handle()
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/handler.py", line 49, in handle
    data = execute_cmd(cmd)
           ^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/handler.py", line 85, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/__init__.py", line 1822, in call
    return fn(*args, **newargs)
           ^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/utils/typing_validations.py", line 32, in wrapper
    return func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/desk/form/save.py", line 39, in savedocs
    doc.save()
  File "apps/frappe/frappe/model/document.py", line 340, in save
    return self._save(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/model/document.py", line 376, in _save
    self.run_before_save_methods()
  File "apps/frappe/frappe/model/document.py", line 1127, in run_before_save_methods
    self.run_method("validate")
  File "apps/frappe/frappe/model/document.py", line 979, in run_method
    out = Document.hook(fn)(self, *args, **kwargs)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/model/document.py", line 1362, in composer
    return composed(self, method, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/model/document.py", line 1340, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
                              ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/model/document.py", line 976, in fn
    return method_object(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/erpnext/erpnext/accounts/doctype/chart_of_accounts_importer/chart_of_accounts_importer.py", line 41, in validate
    get_coa("Chart of Accounts Importer", "All Accounts", file_name=self.import_file, for_validate=1)
  File "apps/frappe/frappe/utils/typing_validations.py", line 32, in wrapper
    return func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^
  File "apps/erpnext/erpnext/accounts/doctype/chart_of_accounts_importer/chart_of_accounts_importer.py", line 169, in get_coa
    data = generate_data_from_csv(file_doc)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/erpnext/erpnext/accounts/doctype/chart_of_accounts_importer/chart_of_accounts_importer.py", line 128, in generate_data_from_csv
    if not row[1] and len(row) > 1:
           ~~~^^^
IndexError: list index out of range

Request Data

{
	"type": "POST",
	"args": {
		"doc": "{\"name\":\"Chart of Accounts Importer\",\"owner\":\"Administrator\",\"modified\":\"2024-09-12 14:11:04.859715\",\"modified_by\":\"Administrator\",\"docstatus\":0,\"idx\":\"0\",\"company\":\"JT-SOE\",\"import_file\":\"/private/files/Chart of Accounts Importer(2).csv\",\"doctype\":\"Chart of Accounts Importer\",\"__unsaved\":1}",
		"action": "Save"
	},
	"freeze": true,
	"headers": {},
	"error_handlers": {},
	"url": "/api/method/frappe.desk.form.save.savedocs",
	"request_id": null
}

Response Data

{
	"exception": "IndexError: list index out of range",
	"exc_type": "IndexError",
	"_exc_source": "erpnext (app)"
}

Thank you for any help / suggestion

2

This is development branch, if you’re setting up production site use version-15 branch.

For the bug you found out, report issue on GitHub.

Share mock/sample CSV that fails, it might help developers

1 Like