Hi everyone, let me show you an example of the partner ledger report we are using where I work:

I am an Odoo developer, this is version 17. I have never worked on accounting reports and they seem quite complex and time consuming to learn, plus they deal in raw SQL, which is not what I'm used to. I would love to learn, but I tried for some time and got blocked trying to get that column to display its sum.

I tried inheriting the report and changing the methods where credit, debit and balance are summed up, but the best I got is the amount_currency column showing the sum of the balance column -_- and I don't understand why.

Perhaps there is another way to get this kind of detail that doesn't require to customize an accounting report? I'm also open to that possibility. This report I'm showing is a duplicate of partner ledger with some columns removed and a personal filter applied to it, so it only manages account move lines that have amount_currency (and filters out the ones in the company's currency).

Please please please someone help me, it would mean the world to me.