Screenshot 2023-10-25 at 10.48.41 PM.png
ERPNext Analytics
We are please to announce our best ever update. ERPNext Analytics.


Rushabh Mehta


Sep, 21 2012



min read

We are please to announce our best ever update. ERPNext Analytics.

Some background:

Now there are many customers using ERPNext for quite sometime (including ourselves, in the 5th year!), hence we have collected a lot of data. But so far it was hard to get any reports, other than standard ones out of ERPNext.

There were 2 major issues:

  1. Reports are expensive: They take a lot of processing and since we host many customers on one server, we were vary of have too any queries clogging our servers.

  2. Browser has its limitations: Until recently, it was not possible to show a lot of data on the browser. The performance would degrade rapidly after a few hundred rows of data.

So what happened?

Well, we killed both the birds with the same arrow :). What we did is probably unique in the world of ERP systems. So here is the magic recipe we tried: Instead of letting the server do all the heavy processing, we decided that we will dump all the required data in the client (based on permissions ofcourse!) and let the browser compute all the analysis.

Also thanks to fantastic open source projects like Slick Grid and Flot, it is now possible to show huge amount of data in the browser without making it sweat too much.

And it worked! And how!

Try it out right now!

The results of our experiment are ready for you to see. Here is a list of reports we have released:


  1. General Ledger: New ledger report, with instant filtering etc.
  2. Trial Balance: Drill down tree view of all Accounts.
  3. Financial Analytics: Fully graphical multi-year trend analysis of all accounts!


  1. Stock Ledger: Track and plot stock movement.
  2. Stock Ageing: Identify slow moving items.
  3. Stock Analysis: Graphical, multi-year trend analysis by item / group.


  1. Sales Analytics: Graphical trend analysis of all sales (based on Sales Invoice).


  1. Purchase Analytics: Graphical trend analysis of all purchases (based on Purchase Invoice).

As usual, we would love to have your comments.

Also don't forget to join our forums!

Published by

Rushabh Mehta


Sep, 21 2012


Add your comment






September 24, 2012

Hi Rushabh, Nice to have a analytics module.. I don't use your services but your regular mailers

Robert Becht


September 23, 2012

Brilliant, examined capabilities for an hour or so, a big step, amazing

Sonal Ramnathkar


September 22, 2012

Just checked it out....its amazing! very exciting...



Paul Mugambi


3 days


Beautiful read, and an insight into an individual I respect and have learned a lot from. Am inspired to trust the process and never give up.


Anna Dane


5 days


I must say this is a really amazing post, and for some of my friends who provide Best British Assignment Help, I must recommend this post to them.

Add your comment