Skip to Content
This question has been flagged
purchaseorders
1 Reply
7745 Views
Avatar
Farook

Hi Friends, I'm getting the below error when I try to click on "Confirm Order" after saving and printing a Purchase Order. Can anybody please help me with this error

Unknown Error! null value in column "account_id" violates not-null constraint

Avatar
Discard
Avatar
Quentin De Paoli (qdp)
Best Answer

it says that one of the required parameter to create the invoice is missing. One of the accounts, to be more specific.

I think you should have a look at your supplier; in the accounting tab you'll probably find that you have the payable account left empty. Fill it manually (if you know how to) or install a Chart of Account that will do it for you.

That should solve your point.

Avatar
Discard
Farook
Author

Thanks a lot for your valuable inputs Quentin. I'll try it and let you know the result

Farook
Author

WOW..that was exactly the problem. I edited the supplier and set the Accounts Receivable and Accounts Payable correctly under the Accounting tab and it worked well...Thanks lot Quentin you made my day!!!

Quentin De Paoli (qdp)

hehehe.. don't forget to thick my answer as correct then and do not hesitate to help back the community if you have the opportunity ;-)

Related Posts Replies Views Activity
Does OpenERP 7.0 Purchase orders allow you to specify a separate shipping address? Solved
purchase orders
Avatar
Avatar
Avatar
Avatar
4
Mar 15
12906
import purchase lines from internal reference
purchase import orders
Avatar
0
Mar 15
4047
How do I create a purchase order instead of an RFQ?
purchase orders rfq
Avatar
Avatar
1
Mar 15
11323
eCommerce: How to remove the Address from Checkout
purchase
Avatar
Avatar
Avatar
Avatar
3
Aug 25
472
How to prevent receipt creation after confirming a Purchase Order in Odoo 18? Solved
purchase
Avatar
Avatar
1
Jul 25
346