How to build "Prepayments from vendors" Report

Hi team,

I hope you are doing well.

I have a question:

I would like to build a report detailing the composition of the Vendor Prepayment account per period grouped by vendors.

The goal is that the report will only show bills that have been paid and have not yet had a bill credit.

If possible - to have the possibility to present the report at the level of each of the Subsidiaries and Consolidated as well as by choice of Primary / Local currency books.

For example, filter the data to June and see a bill from April that is paid in full and without applying for bill credit, even though there was a Bill credit created in August. If I would look at the same bill and filter it to August, I will not see the bill as this account is balanced for this transaction.