Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Error confirming Purchase RFQ

Subscribe

Get notified when there's activity on this post

This question has been flagged
v8errorpurchase_order
4174 Views
Avatar
Jeff Beidler

I'm getting this when trying to convert an RFQ to a real Purchase Order:

Odoo Server Error

Traceback (most recent call last): File "/home/openerp/odoo-8.0-20150115/openerp/http.py", line 525, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/home/openerp/odoo-8.0-20150115/openerp/http.py", line 562, in dispatch result = self._call_function(**self.params) File "/home/openerp/odoo-8.0-20150115/openerp/http.py", line 302, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/service/model.py", line 113, in wrapper return f(dbname, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/http.py", line 299, in checked_call return self.endpoint(*a, **kw) File "/home/openerp/odoo-8.0-20150115/openerp/http.py", line 791, in __call__ return self.method(*args, **kw) File "/home/openerp/odoo-8.0-20150115/openerp/http.py", line 395, in response_wrap response = f(*args, **kw) File "/home/openerp/odoo-8.0-20150115/openerp/addons/web/controllers/main.py", line 960, in exec_workflow return request.session.exec_workflow(model, id, signal) File "/home/openerp/odoo-8.0-20150115/openerp/http.py", line 1096, in exec_workflow r = self.proxy('object').exec_workflow(self.db, self.uid, self.password, model, signal, id) File "/home/openerp/odoo-8.0-20150115/openerp/http.py", line 867, in proxy_method result = dispatch_rpc(self.service_name, method, args) File "/home/openerp/odoo-8.0-20150115/openerp/http.py", line 114, in dispatch_rpc result = dispatch(method, params) File "/home/openerp/odoo-8.0-20150115/openerp/service/model.py", line 37, in dispatch res = fn(db, uid, *params) File "/home/openerp/odoo-8.0-20150115/openerp/service/model.py", line 113, in wrapper return f(dbname, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/service/model.py", line 183, in exec_workflow return exec_workflow_cr(cr, uid, obj, signal, *args) File "/home/openerp/odoo-8.0-20150115/openerp/service/model.py", line 177, in exec_workflow_cr return execute_cr(cr, uid, obj, 'signal_workflow', [res_id], signal)[res_id] File "/home/openerp/odoo-8.0-20150115/openerp/service/model.py", line 159, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/home/openerp/odoo-8.0-20150115/openerp/api.py", line 237, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/models.py", line 3491, in signal_workflow result[res_id] = workflow.trg_validate(uid, self._name, res_id, signal, cr) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/__init__.py", line 85, in trg_validate return WorkflowService.new(cr, uid, res_type, res_id).validate(signal) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/service.py", line 91, in validate res2 = wi.validate(signal) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/instance.py", line 75, in validate wi.process(signal=signal, force_running=force_running, stack=stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 120, in process ok = self._split_test(activity['split_mode'], signal, stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 248, in _split_test self._join_test(t[0], t[1], stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 257, in _join_test WorkflowItem.create(self.session, self.record, activity, inst_id, stack=stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 95, in create workflow_item.process(stack=stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 120, in process ok = self._split_test(activity['split_mode'], signal, stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 248, in _split_test self._join_test(t[0], t[1], stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 272, in _join_test WorkflowItem.create(self.session, self.record, activity, inst_id, stack=stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 95, in create workflow_item.process(stack=stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 120, in process ok = self._split_test(activity['split_mode'], signal, stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 248, in _split_test self._join_test(t[0], t[1], stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 257, in _join_test WorkflowItem.create(self.session, self.record, activity, inst_id, stack=stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 95, in create workflow_item.process(stack=stack) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 116, in process if not self._execute(activity, stack): File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 187, in _execute id_new = self.wkf_expr_execute(activity) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 313, in wkf_expr_execute return self.wkf_expr_eval_expr(activity['action']) File "/home/openerp/odoo-8.0-20150115/openerp/workflow/workitem.py", line 291, in wkf_expr_eval_expr result = eval(line, env, nocopy=True) File "/home/openerp/odoo-8.0-20150115/openerp/tools/safe_eval.py", line 313, in safe_eval return eval(c, globals_dict, locals_dict) File "", line 1, in <module> File "/home/openerp/odoo-8.0-20150115/openerp/api.py", line 235, in wrapper return new_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/api.py", line 552, in new_api result = method(self._model, cr, uid, self.ids, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/addons/purchase/purchase.py", line 664, in action_invoice_create inv_id = inv_obj.create(cr, uid, inv_data, context=context) File "/home/openerp/odoo-8.0-20150115/openerp/api.py", line 237, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/addons/mail/mail_thread.py", line 377, in create thread_id = super(mail_thread, self).create(cr, uid, values, context=context) File "/home/openerp/odoo-8.0-20150115/openerp/api.py", line 237, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/api.py", line 332, in old_api result = method(recs, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/models.py", line 4007, in create record = self.browse(self._create(old_vals)) File "/home/openerp/odoo-8.0-20150115/openerp/api.py", line 235, in wrapper return new_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/api.py", line 464, in new_api result = method(self._model, cr, uid, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/openerp/models.py", line 4145, in _create tuple([u[2] for u in updates if len(u) > 2]) File "/home/openerp/odoo-8.0-20150115/openerp/sql_db.py", line 158, in wrapper return f(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150115/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 (4, null, PO00003, 0.00, null, null, null, 1, 1, 1, null, null, 5, null, in_invoice, f, null, null, null, null, null, PO00003, null, null, 2015-01-20 23:32:11.708138, PO00003, 3, 6, null, null, none, 11, draft, f, null, null, 2015-01-20 23:32:11.708138, null, null). " while evaluating u'action_invoice_create()'

I'm guessing this is something accounting related, but what do I need to change/configure?

0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Error creating a Purchase order
error purchase_order
Avatar
Avatar
2
Aug 19
3921
[8] error while try to duplicate purchase request
error purchase_order
Avatar
2
Jun 17
3962
Using product configurator in purchase order
error purchase_order attributes
Avatar
Avatar
1
Aug 24
3333
Error in the creation of RFQ Solved
error purchase_order v14
Avatar
Avatar
2
May 22
4536
[V13] Odoo Server Error in Purchase app
error purchase_order v13
Avatar
Avatar
1
Feb 21
3146
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now