Home Technology
Category:

Technology

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
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
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
4 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
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
Frappe/ERPNextSoftware DesignTechnology

How To Remotely Host ERPNext Database

by karani
written by karani 3 mins read

Good software design will emphasize the importance of separating the database from the software application. The server where the database is hosted needs an extra layer of protection as it contains all the data. This is sometimes known as remote database setup. This can also be achieved in ERPNext and the Frappe Framework.

In this article I will demonstrate to you how this can be achieved with simple steps.

Setup the remote DB to accept remote connections

After you have installed your database in the remote server (You may use the script provided on my GitHub repository), you will need to set it up to allow remote connections by doing the following:

Edit MariaDB configuration file to accept remote connections by changing its bind-address from 127.0.0.1 to 0.0.0.0

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

Login to your MySQL and create a database user that Frappe will use to authenticate.

CREATE USER 'root'@'[IP ADDRESS FOR ERPNext HOST]' IDENTIFIED BY '[YOUR PASSWORD OF CHOICE]';

Grant the created root user permissions to make changes to the created databases.

GRANT ALL PRIVILEGES ON *.* TO 'root'@'[IP ADDRESS FOR ERPNext HOST]' IDENTIFIED BY 'YOUR PASSWORD OF CHOICE' WITH GRANT OPTION;

Flush the privileges to effect changes to the database and log out from MySQL.

FLUSH PRIVILEGES;

EXIT;

Restart MySQL server to effect all the made changes.

sudo service mysql restart

Test the connection using the below command:

mysql -u root -h [IP ADDRESS FOR DATABASE HOST] -p

If the request doesn’t go through, you may need to ensure that there is no firewall that blocks connections to TCP port 3306 of the MySQL server. We use the below command to allow an IP address on Ubuntu servers:

ufw allow from [IP ADDRESS FOR ERPNext HOST] to any port 3306
Setup your ERPNext or Frappe Framework Installation to connect to your remote Database
bench set-mariadb-host [IP ADDRESS FOR DATABASE HOST]

Restart supervisor if your instance is in production mode

supervisorctl restart all

If your instance is in development mode, restart bench

bench restart

At this point you may decide to test the connection or dive in and create a new site. The database that Frappe will create will be in the server you just set up 🙂

bench new-site erp.upeosoft.com --mariadb-root-password [YOUR PASSWORD OF CHOICE]
0 comment
2 FacebookTwitterPinterestEmail
Newer Posts
Older Posts
Close