HI,
1. Can we see the vendor balance details report in which we can see all the bills, bill payment, balance related to vendor.
2. Same report we need for customer.
For your reference I have attached the pdf which is from Quickbooks.
There are many different reports of a similar type. See the documentation and reports in the system
https://accountingsuite.io/docs/purchases-by-vendor/
https://accountingsuite.io/docs/sales-by-customer/
https://accountingsuite.io/docs/ap-aging/
https://accountingsuite.io/docs/ar-aging/
To create your variant of view use
https://accountingsuite.io/docs/user-interface-navigation/#31-toc-title
In these report it consist only receivable and payable transaction, not the invoice which was received already or the bill which is already paid.
We need 1 report in which we can see all transaction related to vendor and at the end the final balance.