ERPNext

ERPNext is an open source ERP software licensed under GPL3 which is accessed via the web browser. Functionalities are separated into logical sections which makes it convienient to only choose those capabilites which are needed. This enables many different use cases.

There is plenty of documentation. Moreover, a forum serves as a gathering point for discussions among users.

In contrast to its alternative Odoo, it is completely open source and does not have a proprietary version.

Installation

Install the package erpnext^AUR. Internally, the software is unusual to install because it uses it own installer frappe-bench^AUR.

You may want to use an HTTP server like Nginx or Apache to run ERPNext behind a reverse proxy.

ノート:

Your git configuration will likely be altered. The section [safe] will be added. You can safely remove it.

Dependencies

The installer uses a virtual environment for Python. Therefore, Python dependencies are not required system-wide.

Bug (Access to database denied)

During the setup, a database needs to be created. This happens with the own user. For the database creation, the user "root" is needed. By default, it has set an empty password but is accessed via the user "root". As this is not possible in the installation, the user "root" needs to be set a password.

Update

Updating requires manual action because the installation will fail if the software's database named "erpnext" already exists.

Save your database and delete it.

# mariadb-dump -p -u root erpnext > /tmp/erpnext.sql
# mariadb -e "DROP DATABASE erpnext;" -p -u root

Save your files.

# cp -r /usr/share/webapps/erpnext/sites/erpnext/private/ /tmp/erpnext-private/
# cp -r /usr/share/webapps/erpnext/sites/erpnext/public/ /tmp/erpnext-public/

Uninstall erpnext^AUR and remove its lingering files.

# rm -r /usr/share/webapps/erpnext/

Afterwards, install the package erpnext^AUR.

Now, restore your old database and files and remove the backups.

# mariadb -e "DROP DATABASE erpnext;" -p -u root
# mariadb -e "CREATE DATABASE erpnext;" -p -u root
# mariadb -p -u root erpnext < /tmp/erpnext.sql
# cp -r /tmp/erpnext-private/* /usr/share/webapps/erpnext/sites/erpnext/private/
# cp -r /tmp/erpnext-public/* /usr/share/webapps/erpnext/sites/erpnext/public/
# rm /tmp/erpnext.sql
# rm -r /tmp/erpnext-private/
# rm -r /tmp/erpnext-public/

Upgrade the database.

# tmux new-session -s erpnext "erpnext"
# cd /usr/share/webapps/erpnext/
# sudo -u erpnext bash -c "bench migrate"
# tmux send-keys -t erpnext C-c

Ultimately, assure the correct ownership.

 # chown -R erpnext:erpnext /usr/share/webapps/erpnext/

Removal

As the software creates files on its own pacman cannot keep track of all files. For a complete removal, run:

# rm -r /usr/share/webapps/erpnext/

Backup

Create a backup of the database, see MariaDB#Backup. Additionally, save your files which are located in /usr/share/webapps/erpnext/sites/erpnext/private/ and /usr/share/webapps/erpnext/sites/erpnext/public/.

Usage

Start the executable erpnext. The root password is required to access the user "erpnext". The server runs and can be accessed via http://localhost:8000.