Problem closing POS session when exists a refund

[Francisco Martinez]

Hello all,
this bug is related to OpenERP v7
When you try to close a session that includes a refund, the system reports the following message error:

##################
Constraint Error

Wrong credit or debit value in accounting entry !
##################

and the session can't be closed. The log shows the following:

2013-03-01 22:24:18,996 21492 ERROR None openerp.sql_db: bad query: insert into "account_move_line" (id,"account_id","company_id","currency_id","period_id","date_created","date","partner_id","move_id","blocked","tax_amount","product_id","centralisation","journal_id","name","tax_code_id","credit","state","debit","amount_currency","ref","quantity",create_uid,create_date,write_uid,write_date) values (28252,1158,'1',NULL,'4','2013-03-01','2013-03-01',NULL,10969,'False','43.65',407,'normal','1','PACK ARBOL NAVIDAD',8,'29.10','draft','14.55','0.00','POS/2013/03/07222','1.00',14,(now() at time zone 'UTC'),14,(now() at time zone 'UTC'))
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
IntegrityError: el nuevo registro para la relación «account_move_line» viola la restricción check «account_move_line_credit_debit1»

2013-03-01 22:24:18,996 21492 ERROR None openerp.tools.safe_eval: Cannot eval u'wkf_action_close()'
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/tools/safe_eval.py", line 241, in safe_eval
    return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 374, in function_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)
  File "/usr/share/pyshared/openerp/addons/point_of_sale/point_of_sale.py", line 433, in wkf_action_close
    self._confirm_orders(cr, uid, ids, context=context)
  File "/usr/share/pyshared/openerp/addons/point_of_sale/point_of_sale.py", line 452, in _confirm_orders
    self.pool.get('pos.order')._create_account_move_line(cr, uid, order_ids, session, move_id, context=context)
  File "/usr/share/pyshared/openerp/addons/point_of_sale/point_of_sale.py", line 1101, in _create_account_move_line
    account_move_line_obj.create(cr, uid, value, context=context)
  File "/usr/share/pyshared/openerp/addons/account/account_move_line.py", line 1229, in create
    result = super(account_move_line, self).create(cr, uid, vals, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 4436, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 162, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
IntegrityError: el nuevo registro para la relación «account_move_line» viola la restricción check «account_move_line_credit_debit1»

2013-03-01 22:24:18,996 21492 ERROR None openerp.netsvc: Constraint Error
Wrong credit or debit value in accounting entry !
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 289, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 614, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 133, in wrapper
    tr(osv_pool._sql_error[key], 'sql_constraint') or inst[0])
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 72, in abort_response
    raise openerp.osv.osv.except_osv(description, details)
except_osv: ('Constraint Error', 'Wrong credit or debit value in accounting entry !')

If you deletes in pos_order the refund line, the session closes successfully.

Regards
Fran

[Twinkle Christian(OpenERP) (tch-openerp)]

Hello Francisco Martinez,

I have checked your issue with latest trunk as well as with 7.0, But I am not able to reproduce this issue. So, Would you please check it again with latest code and also provide me more information with video or image.

I hope you understand.

Thanks & Waiting for your Answer.. :)

[Francisco Martinez (pxntium)]

Hello,
the problem is when the option "Group Journal entries" in POS configuration
is enabled. If the option is disabled then works fine.

Regards
Fran

2013/3/6 Twinkle Christian(OpenERP) <email address hidden>

> Hello Francisco Martinez,
>
> I have checked your issue with latest trunk as well as with 7.0, But I
> am not able to reproduce this issue. So, Would you please check it again
> with latest code and also provide me more information with video or
> image.
>
> I hope you understand.
>
> Thanks & Waiting for your Answer.. :)
>
> ** Changed in: openobject-addons
> Status: New => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1138698
>
> Title:
> Problem closing POS session when exists a refund
>
> Status in OpenERP Addons (modules):
> Incomplete
>
> Bug description:
> Hello all,
> this bug is related to OpenERP v7
> When you try to close a session that includes a refund, the system
> reports the following message error:
>
> ##################
> Constraint Error
>
> Wrong credit or debit value in accounting entry !
> ##################
>
> and the session can't be closed. The log shows the following:
>
> 2013-03-01 22:24:18,996 21492 ERROR None openerp.sql_db: bad query:
> insert into "account_move_line"
> (id,"account_id","company_id","currency_id","period_id","date_created","date","partner_id","move_id","blocked","tax_amount","product_id","centralisation","journal_id","name","tax_code_id","credit","state","debit","amount_currency","ref","quantity",create_uid,create_date,write_uid,write_date)
> values
> (28252,1158,'1',NULL,'4','2013-03-01','2013-03-01',NULL,10969,'False','43.65',407,'normal','1','PACK
> ARBOL
> NAVIDAD',8,'29.10','draft','14.55','0.00','POS/2013/03/07222','1.00',14,(now()
> at time zone 'UTC'),14,(now() at time zone 'UTC'))
> Traceback (most recent call last):
> File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 227, in
> execute
> res = self._obj.execute(query, params)
> IntegrityError: el nuevo registro para la relación «account_move_line»
> viola la restricción check «account_move_line_credit_debit1»
>
> 2013-03-01 22:24:18,996 21492 ERROR None openerp.tools.safe_eval: Cannot
> eval u'wkf_action_close()'
> Traceback (most recent call last):
> File "/usr/lib/pymodules/python2.7/openerp/tools/safe_eval.py", line
> 241, in safe_eval
> return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict,
> locals_dict)
> File "", line 1, in <module>
> File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 374, in
> function_proxy
> return attr(self._cr, self._uid, [self._id], *args, **kwargs)
> File
> "/usr/share/pyshared/openerp/addons/point_of_sale/point_of_sale.py", line
> 433, in wkf_action_close
> self._confirm_orders(cr, uid, ids, context=context)
> File
> "/usr/share/pyshared/openerp/addons/point_of_sale/point_of_sale.py", line
> 452, in _confirm_orders
> self.pool.get('pos.order')._create_account_move_line(cr, uid,
> order_ids, session, move_id, context=context)
> File
> "/usr/share/pyshared/openerp/addons/point_of_sal...

[ryadbel (ryadbel)]

can you help me about an issues in POS openerp7
when I go to put money in or take money out Ihave message : Error, Ther is no cash register for this session
Would you please help me