Balance is showing 00.0 when I imported the entries through a sql query in a Journal Entry. oddo10.

Question

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

Ray Carnes · Answer

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.

Bài viết liên quan	Trả lời	Lượt xem
How to use cr.execute? Đã xử lý sql odoo10	1 thg 8 22	15267
Cursor not closed explicit Đã xử lý sql odoo10	1 thg 12 19	8386
How to create my own view using "base_external_dbsource"? database odoo10	0 thg 11 18	2451
How can we display data from MongoDB in Odoo? database odoo10	2 thg 11 18	8313
Is there something like database seed in odoo10? Đã xử lý database odoo10	1 thg 9 17	3675

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!