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.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to use cr.execute? Ratkaistu sql odoo10	1 elok. 22	16036
Cursor not closed explicit Ratkaistu sql odoo10	1 jouluk. 19	8906
How to create my own view using "base_external_dbsource"? database odoo10	0 marrask. 18	3127
How can we display data from MongoDB in Odoo? database odoo10	2 marrask. 18	9151
Is there something like database seed in odoo10? Ratkaistu database odoo10	1 syysk. 17	4393

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!