when I open the chart of accounts I get this error:
“Field show_balance_in_coa does not exist on Accounts Settings”
Hi @Eranna,
Please check the field Show Balances in Chart Of Accounts is available in Accounts Settings or not.
If not available then check the field in the delete document. if the field is available in the delete document doctype restore it and reload and check it.
Thank You!
Hi @NCP, I do not see the Chart of Accounts tab.
What do I need to search in delete document? I do not see any show_balance_in_coa
Not sure if this help debugging, I just created this ERPNext instance 5 days ago in Google Cloud Platform using ERPNext packaged by Bitnami image from marketplace. It is written that it uses:
ERPNext Bench (5.17.2)
ERPNext Frappe (14.50.0)
ERPNext (14.40.0)
Hi @lusiakpurnama,
Do you install the india compliance?
If not then please install it and reload and check it.
Thank You!
Hi @NCP, can you tell me how to install the India compliance?
Is this it? GitHub - resilient-tech/india-compliance: Simple, yet powerful compliance solutions for Indian businesses
I’m trying to install it via SSH, but got this:
/opt/bitnami/erpnext/frappe-bench$ sudo bench get-app --branch version-14 https://github.com/resilient-tech/india-compliance.git
Getting india-compliance
$ git clone https://github.com/resilient-tech/india-compliance.git --branch version-14 --depth 1 --origin upstream
fatal: could not create work tree dir 'india-compliance': Permission denied
ERROR: git clone https://github.com/resilient-tech/india-compliance.git --branch version-14 --depth 1 --origin upstream
subprocess.CalledProcessError: Command 'git clone https://github.com/resilient-tech/india-compliance.git --branch version-14 --depth 1 --origin upstream' returned non-zero exit status 128.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/bitnami/erpnext/bin/bench", line 8, in <module>
sys.exit(cli())
File "/opt/bitnami/erpnext/bench/bench/cli.py", line 132, in cli
bench_command()
File "/opt/bitnami/erpnext/bench/bench/commands/make.py", line 159, in get_app
get_app(
File "/opt/bitnami/erpnext/bench/bench/app.py", line 437, in get_app
app.get()
File "/opt/bitnami/erpnext/bench/bench/utils/render.py", line 126, in wrapper_fn
return fn(*args, **kwargs)
File "/opt/bitnami/erpnext/bench/bench/app.py", line 194, in get
self.bench.run(
File "/opt/bitnami/erpnext/bench/bench/bench.py", line 48, in run
return exec_cmd(cmd, cwd=cwd or self.cwd, _raise=_raise)
File "/opt/bitnami/erpnext/bench/bench/utils/__init__.py", line 158, in exec_cmd
raise CommandFailedError(cmd) from subprocess.CalledProcessError(return_code, cmd)
bench.exceptions.CommandFailedError: git clone https://github.com/resilient-tech/india-compliance.git --branch version-14 --depth 1 --origin upstream
Btw, why is that setting separated in a different app?
Update:
I’m able to pass the clone step after I chown root:root the folder.
But the next step (pip install) is an error.
bench get-app after chown
/opt/bitnami/erpnext/frappe-bench$ sudo bench get-app --branch version-14 https://github.com/resilient-tech/india-compliance.git
Getting india-compliance
$ git clone https://github.com/resilient-tech/india-compliance.git --branch version-14 --depth 1 --origin upstream
Cloning into 'india-compliance'...
remote: Enumerating objects: 371, done.
remote: Counting objects: 100% (371/371), done.
remote: Compressing objects: 100% (337/337), done.
remote: Total 371 (delta 33), reused 201 (delta 23), pack-reused 0
Receiving objects: 100% (371/371), 825.03 KiB | 4.94 MiB/s, done.
Resolving deltas: 100% (33/33), done.
Ignoring dependencies of https://github.com/resilient-tech/india-compliance.git. To install dependencies use --resolve-deps
Installing india_compliance
$ /opt/bitnami/erpnext/frappe-bench/env/bin/python -m pip install --quiet --upgrade -e /opt/bitnami/erpnext/frappe-bench/apps/india_compliance
WARNING: The directory '/usr/sbin/.cache/pip' or its parent directory is not owned or is not writable by the current user. The cache has been disabled. Check the permissions and owner of that directory. If executing pip with sudo, you should use sudo's -H flag.
ERROR: Could not install packages due to an OSError: [Errno 13] Permission denied: 'direct_url.json'
Check the permissions.
ERROR: /opt/bitnami/erpnext/frappe-bench/env/bin/python -m pip install --quiet --upgrade -e /opt/bitnami/erpnext/frappe-bench/apps/india_compliance
subprocess.CalledProcessError: Command '/opt/bitnami/erpnext/frappe-bench/env/bin/python -m pip install --quiet --upgrade -e /opt/bitnami/erpnext/frappe-bench/apps/india_compliance ' returned non-zero exit status 1.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/bitnami/erpnext/bin/bench", line 8, in <module>
sys.exit(cli())
File "/opt/bitnami/erpnext/bench/bench/cli.py", line 132, in cli
bench_command()
File "/opt/bitnami/erpnext/bench/bench/commands/make.py", line 159, in get_app
get_app(
File "/opt/bitnami/erpnext/bench/bench/app.py", line 444, in get_app
app.install(verbose=verbose, skip_assets=skip_assets, restart_bench=restart_bench)
File "/opt/bitnami/erpnext/bench/bench/utils/render.py", line 126, in wrapper_fn
return fn(*args, **kwargs)
File "/opt/bitnami/erpnext/bench/bench/app.py", line 242, in install
install_app(
File "/opt/bitnami/erpnext/bench/bench/app.py", line 573, in install_app
bench.run(
File "/opt/bitnami/erpnext/bench/bench/bench.py", line 48, in run
return exec_cmd(cmd, cwd=cwd or self.cwd, _raise=_raise)
File "/opt/bitnami/erpnext/bench/bench/utils/__init__.py", line 158, in exec_cmd
raise CommandFailedError(cmd) from subprocess.CalledProcessError(return_code, cmd)
bench.exceptions.CommandFailedError: /opt/bitnami/erpnext/frappe-bench/env/bin/python -m pip install --quiet --upgrade -e /opt/bitnami/erpnext/frappe-bench/apps/india_compliance
If I run the pip command on its own, it successfully run.
Result of running pip
$ sudo /opt/bitnami/erpnext/frappe-bench/env/bin/python -m pip install --upgrade -e /opt/bitnami/erpnext/frappe-bench/apps/india_compliance
Obtaining file:///opt/bitnami/erpnext/frappe-bench/apps/india_compliance
Installing build dependencies ... done
Checking if build backend supports build_editable ... done
Getting requirements to build editable ... done
Preparing editable metadata (pyproject.toml) ... done
Requirement already satisfied: python-barcode~=0.13.1 in ./env/lib/python3.10/site-packages (from india_compliance==14.16.2) (0.13.1)
Requirement already satisfied: titlecase~=2.3 in ./env/lib/python3.10/site-packages (from india_compliance==14.16.2) (2.4.1)
Requirement already satisfied: pypng~=0.20220715.0 in ./env/lib/python3.10/site-packages (from india_compliance==14.16.2) (0.20220715.0)
Building wheels for collected packages: india_compliance
Building editable for india_compliance (pyproject.toml) ... done
Created wheel for india_compliance: filename=india_compliance-14.16.2-py2.py3-none-any.whl size=2427 sha256=a2f979bfe5d4750c497fe7d38c914afae5acba77996854494081c6956ac01cba
Stored in directory: /tmp/pip-ephem-wheel-cache-l3wqqkv9/wheels/6c/dd/c0/260811ad3a188df512ee864b1372c28d5e37d8cc6f68f5364f
Successfully built india_compliance
Installing collected packages: india_compliance
Attempting uninstall: india_compliance
Found existing installation: india_compliance 14.16.2
Uninstalling india_compliance-14.16.2:
Successfully uninstalled india_compliance-14.16.2
Successfully installed india_compliance-14.16.2
But the next bench install-app doesn’t work:
Result of running bench install-app
$ sudo bench --site erpnext install-app india_compliance
App erpnext already installed
An error occurred while installing india_compliance: App india_compliance not in apps.txt
Traceback (most recent call last):
File "apps/frappe/frappe/commands/site.py", line 415, in install_app
_install_app(app, verbose=context.verbose, force=force)
File "apps/frappe/frappe/installer.py", line 275, in install_app
raise Exception(f"App {name} not in apps.txt")
Exception: App india_compliance not in apps.txt
I manually added the india_compliance in apps.txt, then the install-app works.
Though after I restart the server and reload the page, I still don’t see the Chart of Accounts tab in the setting
Hi @NCP,
I think I know what happened here.
I just saw this in the release notes (Release v14.40.0 · frappe/erpnext · GitHub)
feat: Toggle display of Account Balance in Chart of Accounts (backport #33502) by @mergify in #37125
But when I tested on local, the docker image version is frappe/erpnext:v14.37.1
And then I backup, and use it to restore in GCP, which is newer build v14.40.0.
And so the database entry for show_balance_in_coa is gone.
Can you tell me how to fix this? I’m not quite sure how to proceed.
I found how to fix it.
I found this bench migrate command in ERPNext docs.
Tried it, and now the Chart of Accounts tab in account settings appeared