[5.0.14] Impossible to create supplier invoice with packing list

[Laurent G.]

Hi,

When I try de make supplier invoice with entrance packing list, I have this error :

Environment Information :
System : Linux-2.6.26-2-686-i686-with-debian-5.0.3
OS Name : posix
Distributor ID: Debian
Description: Debian GNU/Linux 5.0.3 (lenny)
Release: 5.0.3
Codename: lenny
Operating System Release : 2.6.26-2-686
Operating System Version : #1 SMP Wed Nov 4 20:45:37 UTC 2009
Operating System Architecture : 32bit
Operating System Locale : fr_FR.UTF8
Python Version : 2.5.2
OpenERP-Client Version : 5.0.10
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 256, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 633, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 613, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File "/usr/lib/python2.5/site-packages/openerp-server/wizard/__init__.py", line 178, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File "/usr/lib/python2.5/site-packages/openerp-server/wizard/__init__.py", line 82, in execute_cr
    res['action'] = result_def['action'](self, cr, uid, data, context)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/stock/wizard/wizard_invoice_onshipping.py", line 101, in _create_invoice
    type=type, context=context)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/delivery/stock.py", line 86, in action_invoice_create
    context=context)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/sale/stock.py", line 122, in action_invoice_create
    context=context)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/stock/stock.py", line 834, in action_invoice_create
    }, context=context)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2869, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
IntegrityError: ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « state »

I can't create supplier invoice.
Thank's for your help.

Laurent

[JMA(Open ERP) (jma-openerp)]

Hello Laurent G. ,

Would you please provide in detail the steps you follow to meet up to the error?

Thanks.

[Laurent G. (lguilloteau)]

Hello JMA,

I have ugrade my version of OpenErp from 5.0.12 to 5.0.14.

I have execute : openerp-server -u all

In menu, "Stock Management" - "Incoming Product" - "Generate Draft invoice on receptions", all pakings lists are state = "DONE" and invoice state = "To be invoiced".

I open one paking list and clic on button "Create Invoice". I choose the purchase jounal and clic on button "Create Invoice".
And I have this error.

All packing lists are existing in version 5.0.12.

Laurent

[Laurent G. (lguilloteau)]

Hi,

Is the same thing if I create a new purchase order.
Good luck

Laurent

[Laurent G. (lguilloteau)]

Hi,

I'm sorry, but after rebbot server, I can create purchase invoise.
Best regards

Laurent

[JMA(Open ERP) (jma-openerp)]

Hello Laurent Guilloteau,

I followed the steps stated by you , fortunately the behaviour is normal.
The error does not come up at our end.

May be some modifications on your part would have made it to crash.
However, you should upgrade your code.

Let us know if you have any further queries.

Thanks.

[Laurent G. (lguilloteau)]

Hi,

Can you tell me how to close this question ????
Thank's

[Richard (John) Nopkins@Servosoft (richard-nopkins)]

Laurent, its simple:)