ERPNext Technical Training


Sr.

Description

Days

1

Prerequisites 


Python:

  • What is Python?

  • Python Syntax

  • Strings and Console Output

  • Conditionals and Control Flow

  • Functions

  • Data Structures in Python


MariaDB / MySQL:

  • SQL – Manipulation

  • SQL – Queries

  • SQL - Aggregate Functions

  • SQL - Multiple Tables


HTML / CSS:

  • HTML: Elements and Structure

  • HTML: Tags

  • HTML: Tables


JavaScript and jQuery:

  • Introduction to JavaScript

  • Control flow

  • Functions and Scope

  • Arrays and Loops

  • JavaScript and jQuery


Jinja Templating:


Git and GitHub:



1

2

Introduction:

What is ERPNext and Frappe framework ?


1

3

Environment setup for ERPNext:

To Manually install frappe/ERPNext here are the steps:


1. Install Pre-requisites:


  • Python 2.7

  • MariaDB 10+

  • Nginx (for production)

  • Nodejs (Latest Version)

  • Redis

  • cron (crontab is required)

  • wkhtmltopdf with patched Qt (for pdf generation)


2. Installing the Bench Repo


3. Installing the Frappe Bench


4. Create new custom app


5. Create new site


6. Add ERPNext apps using get-app command


7. Install ERPNext apps


8. Set developer mode


9. Bench start



1

4

Making a New App


  • App Structure

1

5

Making Models (Doctype)


1

6

Adding Fields


1. Layout helpers (section / column breaks)

2. Child tables (Table type field)

3. HTML

4. Actions (button)

5. Attach Images

6. Data

7. Barcode

8. Check

9. Code

10. color

11. Currency

12. Date

13. Date time

14. Dynamic Link

15. Float

16. Fold

17. Geolocation

18. Heading

19. Image

20. Int

21. Link

22. Text

23. Long Text

24. Password

25. Percent

26. Read Only

27. Select

28. Small Text

29. Text Editor

30. Time

31. Signature


1

7

DocType Naming and Linking

1

8

Form Client Scripting Code using JS


  • Frappe.call

  • Callback

1

9

Predefined methods of ERPNext


1. before_insert

2. validate (Before inserting and updating)

3. on_update (After saving)

4. on_submit (When document is set as submitted)

5. on_cancel

6. on_trash (Before it is about to be deleted)


1

10

Task Runner (Scheduled tasks)

1

11

Making Users and Records

1

12

Roles and Permisssions

1

13

Reports

1. Analysis Report

2. Query Report

3. Script Report


Charts

1. Line Chart

2. Bar Chart

3. Pie Chart


Views

1. Gantt View

2. Kanban View

1

14

Web Views (Website):


1. Web Page

2. Blog Post

3. Web Form

4. Blogger

5. Setup

6. Add Products To Website

7. Shopping Cart

8. Articles

9. Website theme

10. Website script

11. Home Page.

1

15

Bench Command


  • General Usage

  • Config

  • Development

  • Scheduler


1

16

3rd Party Integration Services

1. Paypal Integration

2. Razorpay Integration

3. Dropbox Backup

4. Ldap Integration

5. Braintree Integration

6. Gocardless Integration

7. Stripe Integration

4

17

Training on Real Time Example

1


Total

20