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
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
0
wrz 19
|
5133 | ||
|
Odoo Saas edition: Report customization
Rozwiązane
|
|
1
sty 17
|
5944 | |
|
0
mar 15
|
4677 | ||
|
1
mar 15
|
10883 | ||
|
1
mar 15
|
6952 |
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.