odoodevelopments

Accounting Tips and Tricks Invoicing Module Migration Invoicing menu will not be seen anymore if you've installed Accounting module. Instead once accounting module is installed, it is migrated under the Accounting > Customers > Invoices section. Reconcile means "Reset to draft" When there's a duplicated payments upon clicking "Register Payment" twice from one invoice and in the account section, it's showing payments as doubles. To delete that payment from account, you need to select that payment > Edit > Reset to draft first or otherwise, it will show errors saying reconcile is needed. Email Servers After the outgoing email server is setup and "Test Connection" is successful. But you still can send emails from the setup mail server. You need to check the following. 1 - External email server option must be ticked from Settings > Emails

Update the system sudo apt-get update sudo apt-get upgrade Install pip3: sudo apt-get install -y python3-pip sudo apt-get install python-dev python3-dev libxml2-dev libxslt1-dev zlib1g-dev libsasl2-dev libldap2-dev build-essential libssl-dev libffi-dev libmysqlclient-dev libjpeg-dev libpq-dev libjpeg8-dev liblcms2-dev libblas-dev libatlas-base-dev  Install web dependencies sudo apt-get install -y npm sudo ln -s /usr/bin/nodejs /usr/bin/node sudo npm install -g less less-plugin-clean-css sudo apt-get install -y node-less Install wkhtmltopdf to print PDF reports sudo wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.5/wkhtmltox_0.12.5-1.bionic_amd64.deb sudo apt install -f sudo dpkg -i wkhtmltox_0.12.5-1.bionic_amd64.deb List of users in the system getent passwd Install PostgreSQL sudo apt-get install postgresql Login to admin postgresql user sudo su - postgres Create a new postgres user to access the database from odoo createuser --createdb --username postgres --no-

Install postgres sudo apt-get install postgresql Check postgres is running or not pgrep -u postgres -fa -- -D config_file=/etc/postgresql/12/main/postgresql.conf Run database cluster pg_ctlcluster 12 main start Run from service systemctl start postgresql systemctl status postgresql Check running port for postgres sed -n 4p /var/lib/postgresql/12/main/postmaster.pid Creating a new postgres database sudo su - postgres  (Login as postgres user) psql -c "create database db-test-01;" create database db_test_02; Create new user for database access create user dbadmin02 with encrypted password 'whitecat'; Change password if forgot psql ALTER USER dbadmin02 WITH PASSWORD 'whitecat'; Grant the user to access to that database grant all privileges on database db_test_02 to dbadmin02; Setting up firewall sudo ufw allow 22 sudo ufw allow 5432 sudo ufw enable //Allow to connect from anywhere nano /etc/postgresql/12/main/postgresql.conf listen_addresses = '*' //Edit

Installing Docker Reference from :  https://docs.docker.com/engine/install/ubuntu/ sudo apt-get remove docker docker-engine docker.io containerd runc sudo apt-get update sudo apt-get install \     apt-transport-https \     ca-certificates \     curl \     gnupg-agent \     software-properties-common Add Docker’s official GPG key: curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add - Verify fingerprint sudo apt-key fingerprint 0EBFCD88 Add repo sudo add-apt-repository \    "deb [arch=amd64] https://download.docker.com/linux/ubuntu \    $(lsb_release -cs) \    stable"     Update repo and Install docker engine sudo apt-get update sudo apt-get install docker-ce docker-ce-cli containerd.io Check docker is running ps ax|grep docker Test HelloWorld package sudo docker run hello-world Install docker on windows after instllation, restar tthe PC If the Linux kernel is not updated, install it manually Download from https://docs.microsoft.com/en-us/windows/wsl/ws

Create a new VPS server in Digital Ocean.  Login using Any SSH Client (Eg: Putty or Bitwise Client) =============================================== Open a terminal and run the following commands These steps are specifically for Ubuntu Version 18.  Before proceed, please check your OS version using command  ======================== lsb_release -a  STEP 1: - Get list of updates and install them ============================================== sudo apt update && sudo apt upgrade STEP 2 - install PIP and other Dependencies ============================================ sudo apt install git python3-pip build-essential wget python3-dev python3-venv python3-wheel libxslt-dev libzip-dev libldap2-dev libsasl2-dev python3-setuptools node-less libxml2-dev STEP 3 - Create System user odoo13 with home directory /opt/odoo13  =============================================== sudo useradd -m -d /opt/odoo13 -U -r -s /bin/bash odoo13 And setup password for the new user sudo passwd <username> Che