openerp-india team mailing list archive

[coolmanlg <912377@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

The expense module allows to generate automatically a purchase invoice
after the approval of the expense sheet, in order to create accounting
entries for paying the employee (purchase).

After creating the expense, confirmed and approved, on clicking the
invoice button to generate the invoice, I get the following error:

ERROR:db.cursor:bad query: insert into "account_invoice" (id,"origin","internal_number","fiscal_position","user_id","account_id","reference","payment_term","address_contact_id","reconciled","reference_type","company_id","journal_id","currency_id","state","type","check_total","address_invoice_id","partner_id","name",create_uid,create_date) values (10,E'Test',NULL,NULL,1,NULL,E'EXP/001',NULL,149,E'False',E'none',1,35,43,E'draft',E'in_invoice',E'0.00',149,144,E'Test',1,now())
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "account_id" violates not-null constraint

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
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/912377

Title:
  HR Expense module does not create invoice

Status in OpenERP Addons (modules):
  New

Bug description:
  The expense module allows to generate automatically a purchase invoice
  after the approval of the expense sheet, in order to create accounting
  entries for paying the employee (purchase).

  After creating the expense, confirmed and approved, on clicking the
  invoice button to generate the invoice, I get the following error:

  ERROR:db.cursor:bad query: insert into "account_invoice" (id,"origin","internal_number","fiscal_position","user_id","account_id","reference","payment_term","address_contact_id","reconciled","reference_type","company_id","journal_id","currency_id","state","type","check_total","address_invoice_id","partner_id","name",create_uid,create_date) values (10,E'Test',NULL,NULL,1,NULL,E'EXP/001',NULL,149,E'False',E'none',1,35,43,E'draft',E'in_invoice',E'0.00',149,144,E'Test',1,now())
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "account_id" violates not-null constraint

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