ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

Add new report in erpnext

i added new field in purchase invoice item
i need to see thie field in report with qty
how i can add this

you have to modify the report in python side

@eliyaskhan18
how i can do that

Report builder (the one you are attempting), doesn’t have a way to fetch child tables (where you have those columns which you need).

You would need to do either what @eliyaskhan18 says OR, another option which I have frequently used is:

But, do note that in this (the script report created from UI) - 1) you need a certain script report permission and 2) it’s not a typical python structure and you cannot simply import libraries as you would normally do in Python.

@shreyansh
can give me example for that
thanks

follow this link to make report builder
https://docs.erpnext.com/docs/v13/user/manual/en/customize-erpnext/articles/making-custom-reports