Hello, thank you very much for your quick response.

I had thought about it before, however, this report is native to Odoo and comes without established lines, which seemed strange to me from what you told me, but after analyzing more in depth, I think I have found a way to follow.

It turns out that if you have lines created but they are not visible, and you can see these lines, it is in the base code.

From there I realized that the report is more complex than what is seen in the interface, and I think that is why it does not take my modifications into account. Apart from the fact that I must include the columns and lines in the same way as in the base code, they use a custom function to consult and group the information to be consulted, and looking at the select, I see that it clearly does not consult the information that I need, and this is where my dilemma would lie.

What I think we will have to do is create a new report inheriting from the original, and from another view consult the information of each report. This to simplify the implementation of the new logic.

However, I appreciate any other comments or recommendations that can help me with this requirement.

@RGonzalez
Hi, I am doing something similar and used the same approach that you used, which is to do it from the front end. However, I realised early on that it needed to be done from the backend because Odoo 18 has a dynamic reporting system, and it does need to expose the field from the backend. i am able to add the field in the GL and its value now im stuck on the part of how to get the sum of it like the debit and credit field show on the account level and then total sum.
if you know or have done this, please can you share something on it.