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
สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!
ลงชื่อ| Related Posts | ตอบกลับ | มุมมอง | กิจกรรม | |
|---|---|---|---|---|
|
0
ก.ย. 19
|
5156 | ||
|
Odoo Saas edition: Report customization
แก้ไขแล้ว
|
|
1
ม.ค. 17
|
5989 | |
|
0
มี.ค. 15
|
4716 | ||
|
1
มี.ค. 15
|
10957 | ||
|
1
มี.ค. 15
|
7063 |
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.