Community mailing list archives

community@mail.odoo.com

Re: Error while creating invoice from sales order

by
Mayur Maheshwari
- 07/01/2015 22:24:22
@ Rudi - In customer and supplier form check IN Accounting Tab, And stop passing Null Values when you are creating a invoice.

On Thu, Jul 2, 2015 at 5:12 AM, Rudi Grosberg <rudi.grosberg@gmail.com> wrote:
Hi,

I am creating a normal sales order and confirm it and after trying to create invoice its throwing me error and same in while creating the purchase order, is it something I have to update the git code 


Sent from Outlook

_____________________________
From: OpenERP Master <openerpmaster@gmail.com>
Sent: Thursday, July 2, 2015 3:52 am
Subject: Re: Error while creating invoice from sales order
To: Community <community@mail.odoo.com>


It says very clearly the error that there is no account specified. There are a lot of nulls which tells me your trying to do something strange. Typically accounts can be set at the product or category level. >From your data though, it looks like possibly you have other problems then just missing an account. I think this problem would only happen if your doing something weird.

On Wed, Jul 1, 2015 at 3:37 PM, Rudi Grosberg <rudi.grosberg@gmail.com> wrote:
Hi community

Any idea how to solve the below error I am facing while creating invoice from sales order

  File "/opt/odoo/odoo/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
ValueError: "null value in column "account_id" violates not-null constraint
DETAIL: Failing row contains (10, null, null, 0.00, PO00001, 3, null, null, 1, 3, 2015-06-24 18:24:02.754977, 1, null, null, null, 36190, null, none, 2, null, draft, null, in_invoice, null, null, f, null, null, null, null, 2015-06-24 18:24:02.754977, 1, 1, PO00001, null, PO00001, f, null, null).
" while evaluating
u'action_invoice_create()'
Sent from Outlook

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


Cheers
Mayur Maheshwari,