Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi!
I am trying to create customized P&L report for which i have 3 heads in Revenue as per the product categories we manufacture.
The formula used in computation in all 3 is "[('account_id.account_type', '=', 'income')]"
However, sale made in one category is being reflected in all.
what should be added in formula to differentiate all 3. I know the formula just have account type and does not have account_id.
where to look for it and how to add it.
It would be great if you could give an example.
got the solution, used [('account_id.code', '=', '20%')]that is going with code instead of account type.
Dear Nikita,
Use the below formula to achieve this.
| [('account_id.user_type_id', '=', 13)] |
If you can include multiple account id like below
| [('account_id.user_type_id', '=', [8, 23])] |
We can get the account type id from Accounting -> configurations ->Account Type -> Database ID
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký| Bài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
|---|---|---|---|---|
|
0
thg 9 19
|
3626 | ||
|
1
thg 1 17
|
4417 | ||
|
0
thg 3 15
|
3671 | ||
|
1
thg 3 15
|
9558 | ||
|
1
thg 3 15
|
5589 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
I don't have karmas so putting it as comment.
Hi Ajin, it didn't work. To give more context, i have 3 sources of direct income. I want to distinguish based on these heads and reflect in P&L report.
Also, couldn't find account type under configurations.
You need to enable the developer mode to see the account type menu and if you find you can use the second suggested code I mentioned below.