Community mailing list archives
Re: Error while creating invoice from sales orderby
@ 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 <email@example.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_____________________________
From: OpenERP Master <firstname.lastname@example.org>
Sent: Thursday, July 2, 2015 3:52 am
Subject: Re: Error while creating invoice from sales order
To: Community <email@example.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 <firstname.lastname@example.org> wrote:
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 executeres = self._obj.execute(query, params)ValueError: "null value in column "account_id" violates not-null constraintDETAIL: 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 evaluatingu'action_invoice_create()'