Accounting: How to add hierarchies to accounting reports?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilità
- Magazzino
- PoS
- Project
- MRP
La domanda è stata contrassegnata
There are two ways to achieve hierarchies:
1 Using Accounting groups:
a) debug
b) accounting > conifugration > financial reports > choose reports
c) enable the hierarchy option
d) Configuration > account groups
2) Using Reporting lines:
a) debug
b) accounting > configuration > financial reports > Report Lines
c) Go to the line you wish to turn into a hierarchy
c.1) Put the type as foldable
c.2) Add all the children lines. make sure to define clear section names, codes, levels and sequences
c.3) Define the formula: usually you will want the balance of all the children lines. the balance is computed using the Code of each child. The formula is shown on the next picture.
d) Defining the children:
d.1) Define the Name, Code, sequence. make sure the level is the same for all children of the same level. !!! don't start the code of the section with a number or the formulas will not work.
d.2) Define formula:
If this report line has children lines too then use the method defined above.
If the report line has no more children use:
balance = sum.balance : to calculate remaining balance of all remaining lines
credit = sum.credit: calculate remaining sum of all credits
debits = sum.debits :calculate remaining sum of all debits
d.3) Define the domain: [('account_id.code', '=like', '20%')] this will take all the accounts that start with 20 . adapt as needed
d.4) group the remaining childs by id: account_id
Result:
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
RegistratiPost correlati | Risposte | Visualizzazioni | Attività | |
---|---|---|---|---|
|
0
ago 25
|
104 | ||
|
1
ago 25
|
869 | ||
|
1
lug 25
|
820 | ||
|
1
lug 25
|
3896 | ||
|
1
lug 25
|
864 |