Community mailing list archives
Re: Error while creating invoice from sales orderby
Eric Caudal (Odoo Community Association)
Are they created for the right company?
On Thu, Jul 2, 2015 at 10:34 PM Rudi Grosberg <firstname.lastname@example.org> wrote:
Hello Amit,Thanks for your answer, but unfortunately it didn't worked as this accounts are already assigned.On Thu, Jul 2, 2015 at 12:17 PM, Amit Parik <email@example.com> wrote: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,
property_account_income_categ, property_account_expense_categand 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.@ Rudi - In customer and supplier form check IN Accounting Tab, And stop passing Null Values when you are creating a invoice.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.
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()'