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
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:
https://frappeframework.com/docs/user/en/desk/reports/script-report
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.
follow this link to make report builder
https://docs.erpnext.com/docs/v13/user/manual/en/customize-erpnext/articles/making-custom-reports