Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


what is this error? null value in column "account_id" violates not-null constraint

on 4/10/14, 2:07 AM 3,681 views

null value in column "account_id" violates not-null constraint



| 5 2 8
Ahmadabad, India
On 4/10/14, 2:41 AM


Check property fields of product form view > accounting tab. Have you defined income account and expense account for the product? if not defined in product then check on product's category. Income account and expense account must defined in either product or category.

I have already defined an income and expenses accounts for this product category.

on 4/10/14, 3:53 AM

When you are getting this error? Provide some more details.

on 4/10/14, 3:57 AM

I created a quotation from sales tab,saved and confirmed the sale. This error occurring when I am going to create the invoice for this quotation.

on 4/10/14, 4:02 AM

Have you provided Account Payable and Account Receivable for the Customer used for the Sales?

on 4/10/14, 4:24 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


Asked: 4/10/14, 2:07 AM
Seen: 3681 times
Last updated: 3/16/15, 8:10 AM