Hello, I want to add "Net Profit With Tax" and "Net Profit Without Tax" in the Accounts > Profit Loss Report in odoo 15 enterprise. It is possible to add these two fields in the profit loss report ?
Now it has only " Net Profit " . but i need with Tax
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
Navigate to the Accounting module in Odoo.
Go to "Configuration" -> "Accounting" -> "Accounting Reports".
Find the "Profit and Loss" report template and click on it to edit.
In the report editor, you'll see different sections like "Header", "Lines", and "Footer". You can add new lines to display the "Net Profit With Tax" and "Net Profit Without Tax" fields.
To add a new line, click on the "Add a new line" button within the desired section. Give it a suitable name like "Net Profit With Tax".
In the "Type" field, select "Account".
In the "Formula" field, enter the formula to calculate the "Net Profit With Tax". You can use Odoo's expression language to perform calculations. For example, if the "Net Profit With Tax" is calculated as the sum of two accounts, you can use the sum function like sum(account.code for account in accounts).
Repeat steps 5-7 to add a new line for "Net Profit Without Tax" with the appropriate formula.
Save the changes to the report.
Once saved, you can generate the Profit Loss Report with the added fields by going to "Reporting" -> "Accounting Reports" -> "Profit and Loss".
By customizing the Accounting Reports feature, you can add new lines with calculated fields to the Profit Loss Report. This approach allows you to modify the report directly from within the Odoo user interface without the need for custom development.
I hope this clarifies the process for customizing the Profit Loss Report in Odoo using the Accounting Reports feature.
Thanks for commenting. can you help me with the formula to calculate the Net Profit Without Tax ? If you have and if you could share that will be great help.
Hi Mahfujul,
https://www.odoo.com/documentation/16.0/applications/finance/accounting/reporting/customize.html
you can check this link for the formula.
Hi,
Yes it is possible to add these fields in the report upon customization.
Thanks
Thanks for commenting. can you help me with the formula to calculate the Net Profit Without Tax? If you have and if you could share that will be great help.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
5
Jan 18
|
9165 | ||
|
0
Aug 16
|
3202 | ||
|
0
Mar 15
|
4358 | ||
|
0
Jan 22
|
4958 | ||
|
1
Aug 18
|
2667 |