Sign in
  1. Mailing Lists
  2. Community
  3. Re: Error while creating invoice from sales order

Community mailing list archives

community@mail.odoo.com

Browse archives

Re: Error while creating invoice from sales order

Re: Error while creating invoice from sales order

by
Serpent Consulting Services Pvt. Ltd., Jay Vora
- 07/02/2015 11:43:47
Some possibilities:
- The accounts belong to diff company
- The user has not enough access of the accounts.
- Fiscal position might be playing the trick if specified.

The accounts here to see are: The accounts linked to partner(REC, PAY), The accounts of product, the accounts of the category of the product.

Hope this helps.
Thanks.

On Thu, Jul 2, 2015 at 9:03 PM, Caudal Eric <caudaleric@gmail.com> wrote:
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

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




--
The Splendid journey of 2 years in Numbers
---
Regards,
Jay Vora,
Managing Director,
<img src="cid:part1.09000700.05080805@serpentcs.com" style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
Serpent Consulting Services Pvt. Ltd.
Web : http://www.serpentcs.com
Mobile : 91 - 9879354457
Twitter: jaynvora
Skype: jaynvora
Blog : http://jayvora.blogspot.com

Reference