Statement of Account

A customer has asked for a statement of their account. I have tried to filter this in the ledger as suggested in other threads but this does not seem to work.

How do I create one for the customer showing their remaining balance?

What do you mean by “but this does not seem to work”?

What is your exact requirement?

I need to show the customer exactly what they owe

That’s not called statement of account, that is called “Account Payable”

Are you looking for something like this?

https://github.com/frappe/erpnext/pull/17356

checked accounts payable, that didnt seem to work either

What does and does not seem to work - a screenshot or two might help explain?