Home Author
Author

karani

CEO and Founder of Upeosoft Limited

Technology

Simplifying Financial Management: Automating Bank Reconciliation in ERPNext

by karani
written by karani

Introduction

In today’s fast-paced business environment, efficient financial management is crucial for the success of any organization. Bank reconciliation, a vital component of financial record-keeping, can often be time-consuming and prone to errors when performed manually. However, thanks to the power of automation, this process can now be streamlined and made more accurate than ever before. In this blog post, we will explore a video by Geoffrey Karani, the esteemed founder of Upeosoft Limited, as he demonstrates how bank reconciliation can be automated within ERPNext—an all-in-one ERP system. Get ready to witness the transformative potential of automation in financial management.

Overview

In his video, Geoffrey Karani expertly guides viewers through the process of automating bank reconciliation in ERPNext. With his vast knowledge and experience in the field, Geoffrey highlights the key steps and features that make this automation possible. Let’s delve into the video’s key highlights:

  • Bank Statement Import:
    • Geoffrey demonstrates how ERPNext simplifies the bank reconciliation process by allowing users to import bank statements directly into the system. He showcases the flexibility of the import feature, accommodating multiple file formats, such as CSV or Excel, making it easy to bring in bank transaction data.
  • Automatic Matching:
    • Geoffrey highlights ERPNext’s intelligent algorithms that automatically match bank transactions with corresponding accounting entries. He explains how the system factors in transaction amounts, dates, and references to identify potential matches, reducing the need for manual intervention. This automation significantly speeds up the reconciliation process while maintaining accuracy.

Conclusion

Through his insightful video demonstration, Geoffrey Karani, founder of Upeosoft Limited, sheds light on the automation possibilities within ERPNext for bank reconciliation. By showcasing the system’s import functionality, automatic matching algorithms, exception handling, real-time updates, and reporting capabilities, Geoffrey highlights how this ERP solution can revolutionize financial management. With ERPNext’s bank reconciliation automation, businesses can save time, reduce errors, and gain valuable insights into their financial position.

As Geoffrey Karani demonstrates, embracing automation in ERPNext empowers organizations to focus on strategic financial decisions rather than getting lost in the intricacies of manual reconciliation. Streamline your financial management processes today and unlock the full potential of your business with ERPNext.

0 comment
0 FacebookTwitterPinterestEmail
ERPNext for Business

Bank Reconciliation In ERPNext

by karani
written by karani

In very simple terms, a bank reconciliation statement is one that shows you the differences in your bank statement that you get from your bank, and the balances that are showing in your accounting software.

There are two types of Bank Reconciliation in ERPNext. The Manual and the Semi-automated types. In today’s article, we will only look at the semi automated bank reconciliation, but we may mention one or two things about the manual bank reconciliation.

See more details from this ERPNext documentation link.

0 comment
2 FacebookTwitterPinterestEmail
Technology

How to Set-up Promotional Schemes (Free Items) in ERPNext

by karani
written by karani

In this video I will demonstrate how you can setup promotional schemes in ERPNext. This setup will allow you to offer free items to your customers when they hit a pre-determined threshold when buying a given product.

In this example we are going to give:

  • 1 item when a customer buys 5 – 10 items
  • 2 free items when a customer buys 11 – 20 items
  • 3 free items when a customer buys 21 – 30 items
  • 4 free items when a customer buys 31 – 40 items
  • 5 items when a customer buys more than 40 items.
0 comment
3 FacebookTwitterPinterestEmail
ERPNext for BusinessFrappe/ERPNext

How to create a Purchase Invoice in ERPNext

by karani
written by karani

A purchase invoice is an invoice that is used in conjunction with a purchase order. It is used to indicate how much money the buyer owes to the seller. Purchase invoices are also commonly known as bills, statements or sales invoices.

In ERPNext, the process of creating this document is easy and almost straightforward, and this video is a step by step demonstration on how you can create it.

0 comment
1 FacebookTwitterPinterestEmail
Frappe/ERPNextTechnology

ERPNext Installation Issue – ERROR: There was a problem while creating karani

by karani
written by karani

When installing ERPNext, you may run into an issue that displays the message:

ERROR: There was a problem while creating karani

This error message is then followed by the following message:

 Do you want to rollback these changes? [y/N]:

See below screenshot:

This can be a frustrating feeling especially because there isn’t a clear reason why your installation is failing. This is the reason I put up this brief article to help.

The issue here is squarely a pip issue, and it can most of the time be solved by running the following command.

pip3 install --upgrade --user pip

If that doesn’t seem to save the day, run the following command:

pip3 install --user "setuptools<45"
0 comment
3 FacebookTwitterPinterestEmail
Developer CornerFrappe/ERPNext

Custom Buttons – Client Scripts in Frappe Framework and ERPNext

by karani
written by karani

Client scripts are powerful! They give you the flexibility to control how you want your application to behave. With these pieces of code we can even alter how our application works currently.

In this video, we are going to have a quick introduction to the Frappe Framework and ERPNext client scripts. We will also explore the following topics in custom buttons:

  • How to create a custom button
  • How to create a group of buttons
  • How to add a custom button to a group button created by Frappe or ERPNext
  • How to rename a button created by Frappe or ERPNext

See more from Documentation

Client Script: Click here to view

Adding Custom Buttons: Click here to view

0 comment
1 FacebookTwitterPinterestEmail
Frappe/ERPNextTechnology

Using Frappe / ERPNext with any DBaaS

by karani
written by karani

Hosting your database files to a different server from the one hosting your software files is most of the time the best approach to ensuring safety and security of your data. This is because you can emphasize security on the different layers as required.

In this article, I will walk you through the process of using Frappe / ERPNext with any DBaaS. This tutorial is universal and will work with any trusted DBaas whether you are on Amazon RDS, MariaDB, Azure or any other DBaaS you prefer.

ERPNext allows you to specify the host of your database in the common_site_config.json file. This file is located in your sites directory.

Setup an RDS Instance on AWS

In this tutorial, we will use Amazon RDS.

Log in to your Amazon RDS and follow the below steps:

  1. Click the “Create database” button.
  2. Choose “Standard Create” and select “MariaDB” as the database engine.
  3. Choose a supported MariaDB Version (at the time of writing this article it is 10.3)
  4. Set the “Master username” to “root” and choose a password. This is the password that bench wants to know when it asks for the “root password”.
  5. Choose the size of the DB instance (at least “t2.small”).
  6. Optional: Enable Multi-AZ deployment for redundancy.
  7. Choose the same VPC that contains your frappe server EC2 instance.
  8. Select or create a parameter group that matches the below settings (for MariaDB 10.3).
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
default-character-set = utf8mb4
  1. Create the database and wait until it’s ready
  2. Note down the “Endpoint” for that instance (for example, karani.rds.amazonaws.com)

Setup Frappe

This is done on the server where ERPNext files will be hosted. It could be an EC2 instance or a VPS running on another provider like Digital Ocean, Google Cloud Platform or any other VPS service you prefer.

Do the following:

First, test whether you can connect to the database by running the following command and provide the root password you set up earlier.

mysql -h karani.rds.amazonaws.com -u root -p

Open sites/common_site_config.json with an editor of choice.

Add a key db_host and set it to the endpoint you just noted down. Add a key rds_db and set it to 1. Below is a sample of the lines you need to add:

{
        "db_host": "karani.rds.amazonaws.com",
        "rds_db": 1
}

You can not create a new site with the bench new-site command.

Move an existing database to RDS

  1. Take a database backup of your site with bench backup.
  2. Change the configuration as described in “Setup Frappe”.
  3. Create a new site and restore the backup into it.
0 comment
3 FacebookTwitterPinterestEmail
FeaturedFrappe/ERPNext

How to Install ERPNext Version 14 in Ubuntu 22.04 – A step by Step Guide

by karani
written by karani

In this article, I will take a step-by-step approach to configure our newly installed ubuntu 22.04 OS to set up an environment and install ERPNext version 14. Let’s get to work!

Prerequisites

The below prerequisites are advised in order to get an optimal functionality of ERPNext on your server.

Software Requirements

  • Updated Ubuntu 22.04
  • A user with sudo privileges
  • Python 3.10+
  • Node.js 16

Hardware Requirements

  • 4GB RAM
  • 40GB Hard Disk

Server Settings

Update and Upgrade Packages

sudo apt-get update -y
sudo apt-get upgrade -y

Create a new user – (bench user)

In linux, the root user processes escalated privileges to perform any tasks within the system. This is why it is not advisable to use this user on a daily basis. We will create a user that we can use, and this will be the user we will also use as the Frappe Bench User.

sudo adduser [frappe-user]
usermod -aG sudo [frappe-user]
su [frappe-user] 
cd /home/[frappe-user]

Ensure you have replaced [frappe-user] with your username. eg. sudo adduser frappe

Install Required Packages

A software like ERPNext, which is built on Frappe Framework, requires a number of packages in order to run smoothly. These are the packages we will be installing in this step.

Install GIT

sudo apt-get install git

Install Python

ERPNext version 14 requires Python version 3.10+. This is what we will install in this step.

sudo apt-get install python3-dev python3.10-dev python3-setuptools python3-pip python3-distutils

Install Python Virtual Environment

A virtual environment helps in managing the dependencies for one software at one place, without having to interfere with other sections in the computer or server in which the software is running.

sudo apt-get install python3.10-venv

Install Software Properties Common

Software Properties Common will help in repository management.

sudo apt-get install software-properties-common

Install MariaDB

ERPNext is built to naively run on MariaDB. The team is working to have the same working on PostgreSQL, but this is not ready yet.

sudo apt install mariadb-server mariadb-client

Install Redis Server

sudo apt-get install redis-server

Install other packages

ERPNext functionality also relies on other packages we will install in this step. These will load fonts, PDFs, and other resources to our instance.

sudo apt-get install xvfb libfontconfig wkhtmltopdf
sudo apt-get install libmysqlclient-dev

Configure MYSQL Server

Setup the server

sudo mysql_secure_installation

When you run this command, the server will show the following prompts. Please follow the steps as shown below to complete the setup correctly.

  • Enter current password for root: (Enter your SSH root user password)
  • Switch to unix_socket authentication [Y/n]: Y
  • Change the root password? [Y/n]: Y
    It will ask you to set new MySQL root password at this step. This can be different from the SSH root user password.
  • Remove anonymous users? [Y/n] Y
  • Disallow root login remotely? [Y/n]: N
    This is set as N because we might want to access the database from a remote server for using business analytics software like Metabase / PowerBI / Tableau, etc.
  • Remove test database and access to it? [Y/n]: Y
  • Reload privilege tables now? [Y/n]: Y

Edit MYSQL default config file

sudo nano /etc/mysql/my.cnf

Add the following block of code exactly as is:

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

Restart the MYSQL Server

sudo service mysql restart

Instal CURL, Node, NPM and Yarn

Install CURL

sudo apt install curl

Install Node

curl https://raw.githubusercontent.com/creationix/nvm/master/install.sh | bash

source ~/.profile

nvm install 16.15.0

Install NPM

sudo apt-get install npm

Install Yarn

sudo npm install -g yarn

Install Frappe Bench

sudo pip3 install frappe-bench

Initialize Frappe Bench

bench init --frappe-branch version-14 frappe-bench

Switch directories into the Frappe Bench directory

cd frappe-bench

Change user directory permissions

This will give the bench user execution permission to the home directory.

chmod -R o+rx /home/[frappe-user]

Create a New Site

A site is a requirement in ERPNext, Frappe and all the other apps we will be needing to install. We will create the site in this step.

bench new-site [site-name]

Install ERPNext and other Apps

Download all the apps we want to install

The first app we will download is the payments app. This app is required when setting up ERPNext.

bench get-app payments

Next, we will download ERPNext app

bench get-app --branch version-14 erpnext

Download any other app you may be interested in in a similar manner. For instance, if you need the Human Resource app to be installed, use the following command.

bench get-app hrms

Install all the apps on our site

bench --site [site-name] install-app erpnext

Install all the other apps you downloaded in the same way. For example, if you downloaded the human resource app, use the below command to install it.

bench --site [site-name] install-app hrms

We have successfully setup ERPNext version 14 on ubuntu 22.04. You can start the server by running the below command:

bench start

If you didn’t have any other ERPNext instance running on the same server, ERPNext will get started on port 8000. If you visit [YOUR SERVER IP:8000], you should be able to see ERPNext version 14 running.

Please note that instances which are running on develop mode, like the one we just setup, will not get started when you restart your server. You will need to run the bench start command every time the server restarts.

In the below steps, we will learn how to deploy the production mpde.

Setting ERPNext for Production

Enable Scheduler

bench --site [site-name] enable-scheduler

Disable maintenance mode

bench --site [site-name] set-maintenance-mode off

Setup production config

sudo bench setup production [frappe-user]

Setup NGINX to apply the changes

bench setup nginx

Restart Supervisor and Launch Production Mode

sudo supervisorctl restart all
sudo bench setup production [frappe-user]

If you are prompted to save the new/existing config file, respond with a Y.

When this completes doing the settings, your instance is now on production mode and can be accessed using your IP, without needing to use the port.

This also will mean that your instance will start automatically even in the event you restart the server.

See Version 14 release notes on this link.

All the best! 🙂

0 comment
24 FacebookTwitterPinterestEmail
Developer CornerFrappe/ERPNextTechnology

Unknown log format “main” – Nginx

by karani
written by karani

This error can occur during installation of ERPNext as nginx: [emerg] unknown log format “main” in /etc/nginx/conf.d/frappe-bench.conf:101. This error can also occur when setting up nginx outside ERPNext. Either-way, here is a brief on the causes of the error and how to get it resolved.

The main reason for the failure was that I had explicitly commented out log_format main.

Configuring Access Logs in Nginx Under Nginx, all client requests to the server are recorded in the access log in a specified format using the ngx_http_log_module module.

The default log file is log/access.log (usually /var/log/nginx/access_log on Linux systems) and the default format for logging is normally the combined or main format (this can vary from one distro to another).

The access_log directive (applicable in the HTTP, server, location, if in location and limit except for context) is used to set the log file and the log_format directive (applicable under the HTTP context only) is used to set the log format. The log format is described by common variables and variables that generated only at the time when a log is written.

The syntax for configuring a log format is:

log_format format_name 'set_of_variables_to_define_format';
Open the file etc/nginx/nginx.conf in a text editor of choice

Add the below piece of code inside http as shown in the section following the code snippet:

log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';
Sample Nginx file with changes
user www-data;
worker_processes auto;
pid /run/nginx.pid;
include /etc/nginx/modules-enabled/*.conf;

events {
	worker_connections 768;
	# multi_accept on;
}

http {

	##
	# Basic Settings
	##

	sendfile on;
	tcp_nopush on;
	tcp_nodelay on;
	keepalive_timeout 65;
	types_hash_max_size 2048;
	# server_tokens off;

	# server_names_hash_bucket_size 64;
	# server_name_in_redirect off;

	include /etc/nginx/mime.types;
	default_type application/octet-stream;


	log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';


	##
	# SSL Settings
	##

	ssl_protocols TLSv1 TLSv1.1 TLSv1.2 TLSv1.3; # Dropping SSLv3, ref: POODLE
	ssl_prefer_server_ciphers on;

	##
	# Logging Settings
	##

	access_log /var/log/nginx/access.log;
	error_log /var/log/nginx/error.log;

	##
	# Gzip Settings
	##

	gzip on;

	# gzip_vary on;
	# gzip_proxied any;
	# gzip_comp_level 6;
	# gzip_buffers 16 8k;
	# gzip_http_version 1.1;
	# gzip_types text/plain text/css application/json application/javascript text/xml application/xml application/xml+rss text/javascript;

	##
	# Virtual Host Configs
	##

	include /etc/nginx/conf.d/*.conf;
	include /etc/nginx/sites-enabled/*;
}


#mail {
#	# See sample authentication script at:
#	# http://wiki.nginx.org/ImapAuthenticateWithApachePhpScript
# 
#	# auth_http localhost/auth.php;
#	# pop3_capabilities "TOP" "USER";
#	# imap_capabilities "IMAP4rev1" "UIDPLUS";
# 
#	server {
#		listen     localhost:110;
#		protocol   pop3;
#		proxy      on;
#	}
# 
#	server {
#		listen     localhost:143;
#		protocol   imap;
#		proxy      on;
#	}
#}
0 comment
1 FacebookTwitterPinterestEmail
Technology

What Modules Are Available in ERPNext? | What are the capabilities of ERPNext?

by karani
written by karani 3 Mins read

ERPNext is a cloud based, free and opensource Enterprise Resource Planning (ERP) software.

This article introduces a walk-through video for ERPNext, looking at the modules and capabilities within the ERP. In the video, we will look at:

  • What ERPNext is?
  • What modules are available in ERPNext?
  • Where you can test ERPNext?
  • Where you can get help with ERPNext?
0 comment
3 FacebookTwitterPinterestEmail
Newer Posts
Older Posts
Close