I am looking for a report that will list all vendors in a line format which will include the foloowing columns:

 

Vebdor Name     Total Bills enterd       Total Payments against Total bills  Balance Due

 

At rhe bootom of this report I would like to see the total of each column