Skip to Content
This question has been flagged
filtersearchapicomputeodoo8.0
2 Replies
4067 Rodiniai
Portretas
Luis Reyes

I need to get the total credit amount on all unreconciled entries and display it on a smart button. 

def _compute_refund_balance(self):
    for partner in self:
        moveline_obj = self.pool.get('account.move.line')
        movelines = moveline_obj.search_read(self._cr, self._uid, [('partner_id', '=', partner.id)], ['id', 'credit', 'debit'])
        partner.compute_refund_balance = sum((line['credit']-line['debit']) for line in movelines)    ​            ​


I need something to add inside the function. I have tried adding ('unreconciled','=', True) but still no luck.

Thank you

 ​         ​     ​     ​     ​         ​     ​         ​     ​         ​     ​     ​     ​         ​     ​

Portretas
Atmesti
Portretas
Luis Reyes
Autorius Best Answer

Is this how the system determine the unreconciled ones to the other? In the xml part it is filtered like this `search_default_unreconciled`. I have tried to do the below code but still gets more entries than expected, I tried to check within the db, I have about 135 move line for a certain partner and the unreconciled move line in the system are just 3 entries.


UPDATE:

I already fixed this by filtering the move lines by its account_account.type, all unreconciled entries are from either 'receivable' or 'payable' type of account


movelines = moveline_obj.search_read(self._cr, self._uid, ['&',('partner_id','=',partner.id),'|',('account_id.type','=','receivable'),('account_id.type','=','payable')],['id','credit','debit','account_id'])


Thanks

Portretas
Atmesti
Portretas
Hilar Andikkadavath
Best Answer

You can check the move line with the reconcile _id field. if it's set then it should be reconciled. so change your search by

movelines = moveline_obj.search_read(self._cr, self._uid, [('partner_id', '=', partner.id), ('reconcile_id', '!=', False)], ['id', 'credit', 'debit'])

This is the correct way system checking the moves are reconciled or not like eg:

SELECT count(*) FROM account_move_line WHERE reconcile_id IS NULL AND id IN (xxx)
and we are comparing the boolean of result to know whether the move is reconciled or not.

If you need to know the partial reconciled entries then check the field reconcile_partial_id. If the field has value means the move is partially reconciled.


Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Filter
filter search group_by odoo odoo8.0
Portretas
0
birž. 16
4008
how can i create a filter that uses the "and" condition
filter search
Portretas
Portretas
Portretas
2
lapkr. 23
3927
How to save a filter with today value from context Solved
filter search
Portretas
Portretas
Portretas
Portretas
Portretas
7
bal. 21
21552
filter with related model field Solved
filter search
Portretas
1
spal. 20
5520
change search filter Solved
filter search
Portretas
Portretas
2
lapkr. 16
4740