Community mailing list archives
Re: Error while creating invoice from sales orderby
Go to Setting>Technical>
@ Rudi: Please check your configuration parameter that's the best way to resolve this issues.This errors seems that you didn't install any COA localization module and you have created your own chart of account.So please follow the following step.
And see the property_account_payable, property_account_receivable,
and assign the default payable, receivable, income and expense respectively then it will takes this defaults accounts on invoices.
Hope this can help, let me know if you need more info.
On Thu, Jul 2, 2015 at 7:58 AM, Mayur Maheshwari (OpenERP) <email@example.com> wrote:
This message is eligible for Automatic Cleanup! (firstname.lastname@example.org) Add cleanup rule | More info
@ 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()'