Customer and Supplier are the same person

1

Hello,
I have a person who is both a customer and a supplier. I buy goods from him and also sell goods to him.

Is there a way to combine both accounts into one statement so I can see the net balance between us?

2

No, not in Manager

Possibly with a custom report or exporting the details to Excel and combining them there

3

It would be better if a feature like the ability to merge accounts or transfer balances were added.

4

Customer and Supplier will maintain separate but balances can be transferred by JE.