How can I create a view of a customer's payment history?

[JhoanH]

I need help to create a view in SQL to get all the information about customers' payment history and their debts, including additional information such as the outstanding balance, the date the debt was acquired, and the due date of the debt.

[KennedyT21]

Financials>>Reports>>Accounting>>General Ledger>>select your BP code >>In expanded select Incoming

payments>>untick Accounts and mentioned other details as per your requirement.