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 | etc.
I'm trying to get the id's of the invoices that don't have payments.
I've try like this:
invoice_ids = invoice_obj.search(self.cr, self.uid, [('payment_ids','!=',)])
And I get this WARNING/ERROR:
2014-05-20 08:17:54,280 10010 WARNING db openerp.osv.expression: The domain term '('payment_ids', '!=', )' should use the 'in' or 'not in' operator.
2014-05-20 08:17:54,280 10010 ERROR db openerp.osv.expression: The field 'Payments' (payment_ids) can not be searched: non-stored function field without fnct_search
And it returns all of the invoices.
If I try like this: invoice_ids = invoice_obj.search(self.cr, self.uid, [('payment_ids','!=',False)]) the warning disapears but the error is the same and it returns all of the invoices.
So, how do I get the invoices that have been paid and partially paid ?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 5/20/14, 4:59 AM|
|Seen: 1446 times|
|Last updated: 3/16/15, 8:10 AM|