how to load and display the trial balance in Odoo16 community edition

Question

Hii !
I'm currently trying to build an application in Odoo 16 community , in this application I need to load and display  the trial balance with the possibility to modify it's cases , So I created a model that can store the lines of the trial balance, but I don't know where I can find informations of the trial balance in the database  , and I also don't know how to show the trial balance in it's tabular format like in the accounting module in odoo entreprise edition .
Any one can help me?

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
Trial balance is not stored in the database, the report is taking data from the account.move.line [1]  model/table in the database. You can read data from here and create the report as per your need.
Also you can check the apps in apps store which provide the dynamic report functionality in the community. Either you can refer the code for learning purpose or you can use the module as it is:   https://apps.odoo.com/apps/modules/16.0/dynamic_accounts_report/ [2]
Thanks

[1] https://account.mo

İlgili Gönderiler	Cevaplar	Görünümler
Accounting Reports amount in currency odoo 16 accounting odoo16features	0 Şub 24	1919
AttributeError: 'dict' object has no attribute 'id' Çözüldü accounting odoo16features	1 Şub 24	4479
How can I raise a warning/message via a wizard in create function and continue with the transaction accounting odoo16features	0 Şub 24	2267
maximum recursion depth exceeded while calling a Python object while using action_post from account.move accounting odoo16features	0 Tem 23	2216
Price Difference Account & Its impact on COGS accounting odoo16features	1 Haz 23	3384

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!