Net Profit report

Hello @Abdullah_A_Ansari

There are 4 kinds of built-in reporting mechanisms in ERPNext : Report Builder, Query Report, Script Report and Query Builder.

For both Query Reports and Script Reports the same UI view is used to render them : Query Report View.

  1. Report Builder allows for simple reports to be built from the web user interface (WUI) without any coding, unlike the others
    Reports

  2. Query Report is a SQL query defined within the WUI by a user with System Manager permissions
    How To Make Query Report

  3. Script Reports are written client-side in the WUI or in JS/Python and stored as files server-side by a user with Administrator permissions in Developer mode
    Script Report
    Also look at this tutorial
    [Tutorial] Script Report / Chart

  4. Query Builder
    Query Builder

Making use of these methods you should be able to build whatever your requirements are, especially using Script Reporting.

2 Likes