Community mailing list archives

community@mail.odoo.com

Re: Error while creating invoice from sales order

by
Eric Caudal
- 07/02/2015 11:30:14
Are they created for the right company?


On Thu, Jul 2, 2015 at 10:34 PM Rudi Grosberg <rudi.grosberg@gmail.com> 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 <amitparikit1987@gmail.com> wrote:
@ 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.

Go to Setting>Technical> Company Properties.

And see the property_account_payable, property_account_receivable,
property_account_income_categ, property_account_expense_categ
 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.
---------
Thanks & regards,
Amit Parik
Contact : +91-8238234631
       (wp) +91-9662885631
amit@browseinfo.in
skype: amit.parik


On Thu, Jul 2, 2015 at 7:58 AM, Mayur Maheshwari (OpenERP) <mayurmaheshwari07@gmail.com> wrote:
Boxbe This message is eligible for Automatic Cleanup! (mayurmaheshwari07@gmail.com) 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 <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,

_______________________________________________
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