openerp-india team mailing list archive

[MCL <leal.mcarmo@xxxxxxxxx>]

Hi,

You have to have a property like this:

Name: property_account_receivable
Field: Account Receivable
Type: Many2One
Value: your receivable account
Resource: Null

And if the pending orders red message persists after you add this
property, make sure you leave openerp, clear your browser's cookies and
log back in.

Why does it happen? Probably because you created your own chart of
accounts and deleted the default one. The property will then have no
receivable account because it's gone. You have to give it the one you
created.

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/959137

Title:
  [6.1] POS synchronisation problem

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  Environment:
  Windows XP, Postgres 8.3, OpenERP 6.1

  I install a new database with demo data.
  I only install the POS module.
  All goes well:
  I can use the POS module, I pay thew via the Cash Journal. I see new POS orders appearing in the backend. No errors in te server log.

  Now I stop the server (OpenERP 6.1 service) and start it again.

  For the sake of doing things clean: I logout and login again

  I reconnect to the POS.
  All goes well, and I can create new POS orders
  However
  These new orders do not get synchronised with the backend. On the top right of my browser the red box stating '1 pending orders' stays there.

  The server log shows following order:

  2012-03-19 10:55:02,108 500 ERROR ? openerp.sql_db: bad query: update "account_bank_statement_line" set "journal_id"=E'Cash Journal - (test)' where id = 8
  Traceback (most recent call last):
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\sql_db.py", line 212, in execute
  DataError: invalid input syntax for integer: "Cash Journal - (test)"

  2012-03-19 10:55:02,108 500 ERROR ? openerp.osv.osv: Uncaught exception
  Traceback (most recent call last):
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\osv.py", line 121, in wrapper
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\osv.py", line 176, in execute
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\osv.py", line 164, in execute_cr
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\openerp\addons\point_of_sale\point_of_sale.py", line 73, in create_from_ui
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\openerp\addons\point_of_sale\point_of_sale.py", line 315, in add_payment
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\orm.py", line 4223, in create
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\orm.py", line 4385, in _store_set_values
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\sql_db.py", line 152, in wrapper
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\sql_db.py", line 212, in execute
  DataError: invalid input syntax for integer: "Cash Journal - (test)"

  2012-03-19 10:55:02,108 500 ERROR ? openerp.netsvc: invalid input
  syntax for integer: "Cash Journal - (test)"

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/959137/+subscriptions