Combine fields from 2 doctypes in one report


Hello, I am new to ErpNext / Frappe and am not a programmer. Hoping to solve this without coding.

I have added few custom fields in form “Item (Stock)”. I am trying to create a report for Sale order and want to bring in all the custom fields from “Item (Stock)” in the same report. Could you guide me how to go about doing this?

Thank you,


Unfortunately, you will have to write a special query if your report involves joins.

Thanks Rushabh for the prompt reply. I would suggest if a solution could be build around this, it could help a lot of users who are not used to coding.