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.
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
How to use cr.execute?
Résolu
|
|
1
août 22
|
15268 | |
|
Cursor not closed explicit
Résolu
|
|
1
déc. 19
|
8386 | |
|
0
nov. 18
|
2452 | ||
|
2
nov. 18
|
8314 | ||
|
1
sept. 17
|
3676 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
