Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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'); |
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.
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
How to use cr.execute?
Risolto
|
|
1
ago 22
|
16023 | |
|
Cursor not closed explicit
Risolto
|
|
1
dic 19
|
8884 | |
|
0
nov 18
|
3123 | ||
|
2
nov 18
|
9149 | ||
|
1
set 17
|
4387 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
