ERPNext Frappe script report creation and coding

Published 4/2023
Created by ERPGulf Consultant
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 5 Lectures ( 5h 3m ) | Size: 2.4 GB

ERPNext and Frappe training for creating script reports
Free Download What you’ll learn
ERPNext implementors, consultants, programmers, accountants and small business owners
1000 Dollars
No risk
SQL creation , coding
Requirements
ERPNext basic knowledge
Description
In this session, we create a script report withReport summaryGraph with two legsData listingColor the value with conditionMessageClient side scriptingSQLand a little bit of Query report.Lets start by creating simple messageStandard – NO***** Note: Lot of indent issues with the following codes, please fix it if you are copying the code. Better you write on your owndata = columns, data, "Hello, here is my stock summary, graph and details", chart, report_summarydata = None, None, "Lets learn Script reporting", None, NoneNow lets have two columscolumns =[“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, NoneColor itcolumns =[“Letter”,”Number”,”Colour”] # listmydata =[['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 listdata = columns, mydata, "Lets learn Script reporting", None, Nonelets do report summaryreport_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_summaryHave a totalJust tick the boxLets plot a graphcolumns =[“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
Homepage

www.udemy.com/course/erpgulf-training/