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

Related Posts	Replies	Views
Accounting Reports amount in currency odoo 16 accounting odoo16features	0 फ़र॰ 24	2677
AttributeError: 'dict' object has no attribute 'id' Solved accounting odoo16features	1 फ़र॰ 24	5731
How can I raise a warning/message via a wizard in create function and continue with the transaction accounting odoo16features	0 फ़र॰ 24	3294
maximum recursion depth exceeded while calling a Python object while using action_post from account.move accounting odoo16features	0 जुल॰ 23	3252
Price Difference Account & Its impact on COGS accounting odoo16features	1 जून 23	4127

This question has been flagged

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