We expect this kind of debtors balance report with party wise and invoice wise report in ERPNext.
Thanks for reporting this! Fortunately whoever wants to can implement and contribute that https://docs.erpnext.com/docs/user/manual/en/customize-erpnext/articles/making-custom-reports
Start with the general ledger report. This will give you a good starting point for what you need.