2023 ~ Gerry Conrado

ERPNext and Jasper Server integration for easy Report and Form Creation.

I find it hard to create highly customized report in ERPNext default tools when creating report so I tried to solve it using Jasper Report Server.

In this blog I will show you how I achieved to integrate ERPNext to Jasper Report Server.

Happy Learning!

01 - Install Jasper Server on Linux- step by step

In this video, I will show you easy steps to install Jasper Server.

1. Download Jasper server installer

>wget https://sourceforge.net/projects/jasperserver/files/JasperServer/JasperReports%20Server%20Community%20Edition%208.2.0/TIB_js-jrs-cp_8.2.0_linux_x86_64.run

2. Make the file executable

>chmod +x TIB_js-jrs-cp_8.2.0_linux_x86_64.run

3. Run the installer and follow the installation wizard

>./TIB_js-jrs-cp_8.2.0_linux_x86_64.run

4. Go inside the directory

> cd jasperreports-server-cp-8.2.0/

5. Start the service >./ctlscript.sh start

02 - Configuring Jasper Server to use ERPNext Database as data source

Jasper server need a data source where the data will be pulled. In this video I will show you how to configure Jasper server data source which is in our case its ERPNext database.

03 - Configuring Jasper Studio with ERPNext and Jasper Server

Jasper Studio is the report designer tool for creating forms and reports for Jasper server. In this video I will show you how to configure Jasper Studio to connect to our ERPNext database so that when we are designing the report we are able to get the data from ERPNext.

In addtion, I will show you here how to configure Jasper Studio to connect to Jasper server for easy deployment of report.

04 - Creating the First Report

In this video, I will show you how to create a basic report using Jasper Studio and deploy it to Jasper server .

05 - ERPNext Integration with Jasper Report Server

This is the fun part of ERPNext's and Jasper Server. In this video, I will show you the steps how to integrate ERPNext with Jasper Server.

ERPNext Disaster Recovery

If I'm going to implement ERPNext in on-prem environment, I would propose this plan.

Happy learning!

Why ERPNext?

I explain here why you should take a look at ERPNext and chose to implement it in your company.

ERPNext Auto Backup to Google Drive

ERPNext Autobackup to Google Drive through integration.

See how automatic backup works in ERPNext. This is one of the best solution for disaster recovery.

Happy learning!

007 - Sales Cycle with Advance Payment

Sales Cycle with Advance Payment.

Complete sales transactions from Quotation to Sales Order to Payment Entry to Pick List to Delivery Note/Delivery Receipt to Sales Invoice.

Happy learning!

006 - How ERPNext Sales Cycle works

How ERPNext Sales Cycle works.

Sales cycle is a complete sales transaction from Quotation to Sales Order to Pick List to Delivery Note/Delivery Receipt to Sales Invoice to Payment Entry.

Happy Learning!