This question has been flagged
4 Replies
18739 Views

Odoo's Profit & Loss Report just show income total and expense total but not the net balance. How can I make it to show the net balance like other other accounting software do?

Is there a better report module that shows more detail report?

Avatar
Discard
Best Answer

Hey try this out..

A simple method to get Net value in PL account

1. Go to Invoicing->Financial Report->Account Reports

2. Click Create and fill the fields as follows:-

            Report Name: Net

            Parent            : Profit and Loss

            Type                : Account Type

            Sign on Reports: Reverse balance Sign

            Financial report Style : Automatic Formating

3. In "Report" tab of the same window

        Account Type-> Add an item

                    -Choose Income.

                        -> Add an item

                    - Choose Expense


Save this. Now check the Profit and Loss report. You can see the Net value



Thank U       

Avatar
Discard
Best Answer

You need Customisation.

Avatar
Discard
Best Answer

This isn't a perfect solution, but it works. Basically profit and loss is calculated, but not printed on the report. You can add this after the </table> tag through the web interface for editing views:

<t t-foreach="get_lines(data)" t-as="a">

<t t-if="a.get('level')==0">

<h2> Profit: </h2>

<h3><span t-att-style="style" t-esc="formatLang(a.get('balance'), currency_obj=res_company.currency_id)"/></h3>

</t>

</t>

Avatar
Discard

Hello,

I have been trying to follow through with this but I keep getting an error.

Error to render compiling AST

TypeError: 'NoneType' object is not callable

Best Answer

Accounting (menu item) --> Configuration (dashboard) --> Financial Report --> Account Report --> hit "CREATE" button


here you can create Net Profit or anything you want to add on the report..

Avatar
Discard

First you have to activate developer mode