Createing new report

Frappe Framework
1

Hi,

How can i create new report look like profit and loss statement

The things i want to achieve is create new looks for profit & loss statement by grouping them for example i want to group the COA myself so i can show gross profit in there (which no gross profit COA , there is only production cost & sales COA , so i need create new rows to count sales deducted by production cost to get gross profit)

Thanks

2

You should make a query / script report

https://frappe.io/developers/how-to/query-report

https://frappe.io/developers/how-to/script-report

3

Hi rusabh,

im succed create a new report but i wonder how i can add from and to date field in my report so i can filter the result to transaction within those dates ?

and i cant see the report shown in report menu on the module that assign it, why?

Thanks

4

What kind of reports are you making? You need to be in developer mode to make these reports.

5

Hi rusabh,

Ya im already set developer mode option

im already can create the report without any filter but i cant find it in report menu

Thanks

6

Please read this to learn how to add filters:

https://frappe.io/developers/how-to/script-report