How to get item Price with discounts in Excel

Hello Experts,

We are having one requirement to have Net prices for items after calculating discounts in report format in excel. To reduce the data in report, we can extract basis on customers, address, state or item category.

But the aim is to get final price for an item in report. Like if we create any Sales Orders and select any item then same price should populate there in Excel report.

How to achieve this requirement. Do we have any API, any logic to do this.

Regards,

Shubham Billore