Skip ke Konten
Pertanyaan ini telah diberikan tanda
databasesqlpostresqlodoo10
1 Balas
3611 Tampilan
Avatar
DonferaRRi

What I have done is, I entered Opening Balances in journal Entry through a sql query mentioned below.

insert into account_move_line (move_id,journal_id, company_id, account_id, operating_unit_id, partner_id, name, currency_id, debit, credit, date_maturity) values(18467,79,1,3,10,11091,'TN',21,25538.71,0,'2018-03-31');
Both debit and Credit are showing. Balance being a compute field should reflect automatically but its showing 00.0. Any Idea where I have been wrong in this case?


Avatar
Buang
Avatar
Ray Carnes
Jawaban Terbai

Computed fields are only triggered to calculate when ORM is used to create or edit data. When you import via SQL you are bypassing ORM - Odoo knows nothing about these kinds of updates. SQL isn't a good method to import data, especially without a good understanding of the data model and corresponding calls to ORM functions that trigger the Odoo business logic.

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
How to use cr.execute? Diselesaikan
sql odoo10
Avatar
Avatar
1
Agu 22
15225
Cursor not closed explicit Diselesaikan
sql odoo10
Avatar
1
Des 19
8356
How to create my own view using "base_external_dbsource"?
database odoo10
Avatar
0
Nov 18
2422
How can we display data from MongoDB in Odoo?
database odoo10
Avatar
Avatar
Avatar
2
Nov 18
8217
Is there something like database seed in odoo10? Diselesaikan
database odoo10
Avatar
Avatar
1
Sep 17
3623