Consolidated Report for Item-wise Purchase and Sales History in ERPNext?

I’ve noticed that ERPNext offers reports like “Item-wise Sales History” and “Item-wise Purchase History.” However, I’m looking for a consolidated report that shows both the purchase and sales information for each item. Specifically, I would like to know:

  • From whom the item was purchased (Supplier details)
  • To whom the same item was sold (Customer details)

Is there a way to create such a report, or has anyone implemented a similar solution?

In by default, erpnext does not provide this type of report, it can be complex to develop like whom the item was purchased and whom the same item was sold. you have to develop the custom server script report and set it according to the scenario.

Thanks for your support @NCP