I am using Odoo 18.0 online.
I am trying to create a profit and loss report that displays all revenue and expense accounts from the chart of accounts, including those with zero balance. However, I am really struggling with this.
In developer mode: navigating to Configuration > Accounting Reports, I've revised the formulas for the reporting lines to include accounts with zero balance. However, this does not achieve the outcome I want. The only zero-balance accounts that get added to the report are those that are somehow "active" -- e.g., loan interest expense, which has a zero balance but is connected to an outstanding loan. (Note, also, that the standard "hide if zero" and "hide lines at 0" options only apply to the main report headings and do not affect individual accounts.)
Based on the above and after reviewing the XML code for the report through "inspect" in the browser, I concluded that there is a line in the XML code that is suppressing zero-balance accounts from being displayed. So I would like to edit the XML code for the profit and loss report. However, I cannot find where this can be done.
On the report page, when I navigate to User Interface > View: Form, I only get to the view for account.report.form -- not the form for the profit and loss statement itself. I've also tried searching the views through the Settings app > Technical, but I cannot find anything related to profit and loss.
Can anyone please advise on where the XML code for the profit and loss report is housed or, more generally, if I am approaching this problem correctly? Your help would be much, much appreciated.
Thank you!