I have some 4000 inventory items I want to check how what is the total balance of the supplier and how much inventory cost total regarding that supplier(from that supplier) I have. is there anyway or any report or custom report can be made of? thanks
You cannot get this, because inventory items are not associated with suppliers. (You could buy the same item from many suppliers in some situations.) And, once an inventory item is in inventory, it is indistinguishable from any other unit of the same item.