Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
ERPNext Frappe script report creation and coding
Rating: 4.0 out of 5(4 ratings)
54 students

ERPNext Frappe script report creation and coding

ERPNext and Frappe training for creating script reports
Last updated 5/2023
English

What you'll learn

  • ERPNext implementors, consultants, programmers, accountants and small business owners
  • 1000 Dollars
  • No risk
  • SQL creation , coding

Course content

5 sections6 lectures6h 18m total length
  • Introduction1:16:21

    In this session, we create a script report with

    Report summary

    Graph with two legs

    Data listing

    Color the value with condition

    Message

    Client side scripting

    SQL

    and a little bit of Query report.


Requirements

  • ERPNext basic knowledge

Description

In this session, we create a script report with

Report summary

Graph with two legs

Data listing

Color the value with condition

Message

Client side scripting

SQL

and a little bit of Query report.


Lets start by creating simple message

Standard - NO


***** Note: Lot of indent issues with the following codes, please fix it if you are copying the code. Better you write on your own


data = columns, data, "Hello, here is my stock summary, graph and details", chart, report_summary

data = None, None, "Lets learn Script reporting", None, None


Now lets have two colums

columns = ["Letter","Number","Colour"]

mydata = [['Row-1',2,'Red'],['Row-2',2,'Blue'],['Row-3',8,Yellow'],['Row-4',7,'Violet']]

data = columns, mydata, "Lets learn Script reporting", None, None


Color it


columns = ["Letter","Number","Colour"] # list

mydata = [['Row-1',2,'<span style="color: red;">Red</span>'],['Row-2',2,'Blue'],['Row-3',8,'Yellow'],['Row-4',7,'<span style="color: violet;">Violet</span>']] # list within list

data = columns, mydata, "Lets learn Script reporting", None, None


lets do report summary


report_summary = [

{"value": "100", "label": "label1", "datatype": "Data"},

{"value": "200", "label": "label2", "datatype": "Data"},

{"value": "300", "label": "label3", "datatype": "Data"}

]

data = None, None, None, None, report_summary


Have a total

Just tick the box


Lets plot a graph


columns = ["Letter","Number"]

data = [['c',2],['a',2],['t',8],['s',7]]

mydataset = {"values": [3000, 6500, 4250, 1000]}

chart = {'data':{'labels':['Saudi','Qatar','UAE','Oman'],'datasets':[mydataset]},'type':'bar'}

data = columns, data, None, chart, None


Who this course is for:

  • Creating reports and charts on ERPNext