I would like to see total sales of each supplier in my report. can we have ?
No, there is no link between your purchases and your sales other than your inventory.
You can report on sales by product but if a product is supplied by various suppliers there is no way to distinguish which sales came from which supplier
In some applications, billable expenses from suppliers billed to customers can be seen in tables.
But I don’t know how useful it is.