Dear all,
we have encountered a configuration problem for the following syntax:
[('account_id.user_type_id.type', '=', 'liquidity'), ('balance', '
The balance condition doesn't work.
Any help please.
Regards,
Ridha
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
877
Views
Odoo has special kind of fields that are called Computed Fields these fields can't be but in domain filters if they are not stored in the database. Witch means they don't have a value to be compared.
To make sure the balance is stored you can check if the balance has an attribute called store=True in the model. Other wise you have to calculate the balance by your self through SQL queries or Computed Fields.
.........
Another way is to calculate the balance your self form the credit and debit of your accounts try to make a formula with this equation:
balance = debit - credit
Happy to help :) an upvote will be awesome
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
[('account_id.user_type_id.type', '=', 'liquidity'),
('balance',=, 0.0)]
Please let me know where we can check store=True
@Ridah Please use comments instead of answers to discuss.
You can find the balance field in the model that you are trying to make the report for.
Please check the link:
https://www.odoo.com/documentation/15.0/fr/applications/finance/accounting/reporting/overview/customize.html
Formiles:
[('account_id.user_type_id.type', '=', 'liquidity'), ('balance', '=', 0.0)]
Information principale
Nom de la section
Encaissements
CR1
Code
Calcul
Formules
sum
Domaine
[('account_id.user_type_id.type', "=', "liquidity"), ('balance', '<', 0.0)]
Regrouper par
ccount_id
Changeur de date
Dates butoir pour tous les comptes et les
speciale
types de compte
Sequence
Especes
Parent
balance = fields.Monetary(string='Balance', store=True,
currency_field='company_currency_id',
compute='_compute_balance',
help="Technical field holding the debit - credit in order to open meaningful graph views from reports")