Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
accountingerrorpaymentaccount.movev14
1 Odgovori
3378 Prikazi
Avatar
Abdifitah Dahir AK 
class AccountMove(models.Model):
    _inherit = 'account.move'

    def button_cancel(self):
        account_pool = self.env['account.payment']
        move_ids = account_pool.search([('ref', '=', self.name), ('state', '=', 'posted')])
        if move_ids:
            move_ids.sudo().action_draft()
            move_ids.sudo().action_cancel()
        res = super(AccountMove, self).button_cancel()
        return res



--------------------------------------------------------------------------------------------------

Error:
Odoo Server Error

Traceback (most recent call last):
File "C:\Program Files\Odoo \14\.0\.20210910\server\odoo\addons\base\models\ir_http\.py\"\,\\ line\ 237\,\ in\ _dispatch\
\ \ \ \ result\ \=\ request\.dispatch\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\http\.py\"\,\\ line\ 684\,\ in\ dispatch\
\ \ \ \ result\ \=\ self\._call_function\(\*\*self\.params\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\http\.py\"\,\\ line\ 360\,\ in\ _call_function\
\ \ \ \ return\ checked_call\(self\.db\,\ \*args\,\ \*\*kwargs\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\service\model\.py\"\,\\ line\ 94\,\ in\ wrapper\
\ \ \ \ return\ f\(dbname\,\ \*args\,\ \*\*kwargs\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\http\.py\"\,\\ line\ 348\,\ in\ checked_call\
\ \ \ \ result\ \=\ self\.endpoint\(\*a\,\ \*\*kw\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\http\.py\"\,\\ line\ 913\,\ in\ __call__\
\ \ \ \ return\ self\.method\(\*args\,\ \*\*kw\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\http\.py\"\,\\ line\ 532\,\ in\ response_wrap\
\ \ \ \ response\ \=\ f\(\*args\,\ \*\*kw\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\web\controllers\main\.py\"\,\\ line\ 1393\,\ in\ call_button\
\ \ \ \ action\ \=\ self\._call_kw\(model\,\ method\,\ args\,\ kwargs\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\web\controllers\main\.py\"\,\\ line\ 1381\,\ in\ _call_kw\
\ \ \ \ return\ call_kw\(request\.env\[model\]\,\ method\,\ args\,\ kwargs\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\api\.py\"\,\\ line\ 396\,\ in\ call_kw\
\ \ \ \ result\ \=\ _call_kw_multi\(method\,\ model\,\ args\,\ kwargs\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\api\.py\"\,\\ line\ 383\,\ in\ _call_kw_multi\
\ \ \ \ result\ \=\ method\(recs\,\ \*args\,\ \*\*kwargs\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\account\wizard\account_payment_register\.py\"\,\\ line\ 530\,\ in\ action_create_payments\
\ \ \ \ payments\ \=\ self\._create_payments\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\hr_expense\wizard\account_payment_register\.py\"\,\\ line\ 24\,\ in\ _create_payments\
\ \ \ \ payments\ \=\ super\(\)\._create_payments\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\account\wizard\account_payment_register\.py\"\,\\ line\ 511\,\ in\ _create_payments\
\ \ \ \ payments\.action_post\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\payment\models\account_payment\.py\"\,\\ line\ 121\,\ in\ action_post\
\ \ \ \ payments_trans_not_done\.action_cancel\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\account\models\account_payment\.py\"\,\\ line\ 765\,\ in\ action_cancel\
\ \ \ \ self\.move_id\.button_cancel\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\stock_account\models\account_move\.py\"\,\\ line\ 67\,\ in\ button_cancel\
\ \ \ \ res\ \=\ super\(AccountMove\,\ self\)\.button_cancel\(\)\
\ \ File\ \"c\:\users\hp\appdata\local\openerp\ s\.a\odoo\addons\14\.0\om_account_asset\models\account\.py\"\,\ line\ 17\,\ in\ button_cancel\
\ \ \ \ return\ super\(AccountMove\,\ self\)\.button_cancel\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\account_edi\models\account_move\.py\"\,\\ line\ 167\,\ in\ button_cancel\
\ \ \ \ res\ \=\ super\(\)\.button_cancel\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\account\models\account_move\.py\"\,\\ line\ 2581\,\ in\ button_cancel\
\ \ \ \ move_ids\.sudo\(\)\.action_cancel\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\account\models\account_payment\.py\"\,\\ line\ 765\,\ in\ action_cancel\
\ \ \ \ self\.move_id\.button_cancel\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\stock_account\models\account_move\.py\"\,\\ line\ 67\,\ in\ button_cancel\
\ \ \ \ res\ \=\ super\(AccountMove\,\ self\)\.button_cancel\(\)\
\ \ File\ \"c\:\users\hp\appdata\local\openerp\ s\.a\odoo\addons\14\.0\om_account_asset\models\account\.py\"\,\ line\ 17\,\ in\ button_cancel\
\ \ \ \ return\ super\(AccountMove\,\ self\)\.button_cancel\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\account_edi\models\account_move\.py\"\,\\ line\ 167\,\ in\ button_cancel\
\ \ \ \ res\ \=\ super\(\)\.button_cancel\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\addons\account\models\account_move\.py\"\,\\ line\ 2578\,\ in\ button_cancel\
\ \ \ \ move_ids\ \=\ account_pool\.search\(\[\(\'ref\'\,\ \'\=\'\,\ self\.name\)\,\ \(\'state\'\,\ \'\=\'\,\ \'posted\'\)\]\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\fields\.py\"\,\\ line\ 963\,\ in\ __get__\
\ \ \ \ record\.ensure_one\(\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\models\.py\"\,\\ line\ 4993\,\ in\ ensure_one\
\ \ \ \ raise\ ValueError\(\"Expected\ singleton\:\ \%s\"\ \%\ self\)\
Exception\
\
The\ above\ exception\ was\ the\ direct\ cause\ of\ the\ following\ exception\:\
\
Traceback\ \(most\ recent\ call\ last\)\:\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14\.0\.20210910\server\odoo\http\.py\"\,\\ line\ 640\,\ in\ _handle_exception\
\ \ \ \ return\ super\(JsonRequest\,\ self\)\._handle_exception\(exception\)\
\ \ File\ \"C\:\Program\ Files\Odoo\ \14.0.20210910\server\odoo\http.py", line 316, in _handle_exception
raise exception.with_traceback(None) from new_cause
ValueError: Expected singleton: account.move(15476, 15475, 15457, 15233, 15232, 14976, 14975, 14154, 14153, 14152, 13956, 13955, 13609, 13608, 13294, 13293, 13292, 12977, 12976, 12975, 12523, 12522, 11793, 11792, 11116, 11077, 10821, 10820, 10405, 10292, 10062, 9893, 9825, 9707, 9706, 9520, 9439, 9399, 9398, 9169, 9087, 9086, 8679, 8678, 8677, 8184, 7367, 7138, 7137, 6835, 6834, 6833, 6832, 5900, 5899, 5888, 5015, 4457, 4456, 4455, 3697, 3696, 3695, 3196, 3195, 3194, 2831, 2827)

Avatar
Opusti
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

This is a singleton error.It can be solved by adding a for loop.Try below code:

class AccountMove(models.Model):
    _inherit = 'account.move'
    
    def button_cancel(self):
        account_pool = self.env['account.payment']
        move_ids = account_pool.search([('ref', '=', self.name), ('state', '=', 'posted')])
        if move_ids:
           for rec in move_ids:
         rec.sudo().action_draft()
         rec.sudo().action_cancel()
        res = super(AccountMove, self).button_cancel()
        return res

Regards

Avatar
Opusti
Abdifitah Dahir AK
Avtor

Thank you

Related Posts Odgovori Prikazi Aktivnost
ValueError: Invalid field 'due_amount' on model 'account.move' Error While Creating Journal Entry, Non Technical answer needed.
accounting error account.move journal_entry
Avatar
0
avg. 22
4531
How to get all related account moves to the payment in Odoo 14? Solved
accounting python payment v14
Avatar
Avatar
1
jan. 21
6315
Odoo 13 enterprise: Error on customer/ vendor payment post
accounting error payment Odoo13.0
Avatar
0
avg. 20
3356
Javascript error on one users pc, all browsers, not reproducable
javascript accounting error synchronization v14
Avatar
0
maj 23
2686
Odoo v14: Name Prefix of Journal Entry created through Payment is always BNK1 Solved
accounting payment odoo journal_entry v14
Avatar
Avatar
1
sep. 21
5836