Skip ke Konten
Odoo Menu
  • Login
  • Uji coba gratis
  • Aplikasi
    Keuangan
    • Akuntansi
    • Faktur
    • Pengeluaran
    • Spreadsheet (BI)
    • Dokumen
    • Tanda Tangan
    Sales
    • CRM
    • Sales
    • POS Toko
    • POS Restoran
    • Langganan
    • Rental
    Website
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Rantai Pasokan
    • Inventaris
    • Manufaktur
    • PLM
    • Purchase
    • Maintenance
    • Kualitas
    Sumber Daya Manusia
    • Karyawan
    • Rekrutmen
    • Cuti
    • Appraisal
    • Referensi
    • Armada
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Acara
    • Otomatisasi Marketing
    • Survei
    Layanan
    • Project
    • Timesheet
    • Layanan Lapangan
    • Meja Bantuan
    • Planning
    • Appointment
    Produktivitas
    • Diskusi
    • Approval
    • IoT
    • VoIP
    • Pengetahuan
    • WhatsApp
    Aplikasi pihak ketiga Odoo Studio Platform Odoo Cloud
  • Industri-Industri
    Retail
    • Toko Buku
    • Toko Baju
    • Toko Furnitur
    • Toko Kelontong
    • Toko Hardware
    • Toko Mainan
    Makanan & Hospitality
    • Bar dan Pub
    • Restoran
    • Fast Food
    • Rumah Tamu
    • Distributor Minuman
    • Hotel
    Real Estate
    • Agensi Real Estate
    • Firma Arsitektur
    • Konstruksi
    • Estate Management
    • Perkebunan
    • Asosiasi Pemilik Properti
    Konsultansi
    • Firma Akuntansi
    • Mitra Odoo
    • Agensi Marketing
    • Firma huku
    • Talent Acquisition
    • Audit & Sertifikasi
    Manufaktur
    • Tekstil
    • Logam
    • Perabotan
    • Makanan
    • Brewery
    • Corporate Gift
    Kesehatan & Fitness
    • Sports Club
    • Toko Kacamata
    • Fitness Center
    • Wellness Practitioners
    • Farmasi
    • Salon Rambut
    Perdagangan
    • Handyman
    • IT Hardware & Support
    • Sistem-Sistem Energi Surya
    • Pembuat Sepatu
    • Cleaning Service
    • Layanan HVAC
    Lainnya
    • Organisasi Nirlaba
    • Agen Lingkungan
    • Rental Billboard
    • Fotografi
    • Penyewaan Sepeda
    • Reseller Software
    Browse semua Industri
  • Komunitas
    Belajar
    • Tutorial-tutorial
    • Dokumentasi
    • Sertifikasi
    • Pelatihan
    • Blog
    • Podcast
    Empower Education
    • Program Edukasi
    • Game Bisnis 'Scale Up!'
    • Kunjungi Odoo
    Dapatkan Softwarenya
    • Download
    • Bandingkan Edisi
    • Daftar Rilis
    Kolaborasi
    • Github
    • Forum
    • Acara
    • Terjemahan
    • Menjadi Partner
    • Layanan untuk Partner
    • Daftarkan perusahaan Akuntansi Anda.
    Dapatkan Layanan
    • Temukan Mitra
    • Temukan Akuntan
    • Temui penasihat
    • Layanan Implementasi
    • Referensi Pelanggan
    • Bantuan
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dapatkan demo
  • Harga
  • Bantuan

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

  • CRM
  • e-Commerce
  • Akuntansi
  • Inventaris
  • PoS
  • Project
  • MRP
All apps
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Help

Integrity error confirming RFQ: creation/update: a mandatory field is not correctly set

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
confirmationpurchase_orderwarning
3 Replies
25389 Tampilan
Avatar
Marcelo Ruiz

Hi, I am following the tutorial for OpenERP 7 and after creating a Request for Quotation, I am supposed to click on Confirm Order, but I get the following warning that I am unable to understand:


Integrity Error

The operation cannot be completed, probably due to the following: - deletion: you may be trying to delete a record while other records still reference it - creation/update: a mandatory field is not correctly set

[object with reference: location_id - location.id]

Is this a bug I need to report on launchpad? Thanks!

0
Avatar
Buang
Avatar
Vehbi Sinan Tunalioglu
Jawaban Terbai

Did you try to check your supplier's location: Supplier > Sales & Purchases > Supplier Location

If it is empty, set to "Partner Locations / Suppliers".

1
Avatar
Buang
Avatar
Ray Carnes
Jawaban Terbai

Since you are trying to UPDATE a record, the error is telling you there is a field of type location_id that is mandatory and is not set. The field is shop_id.

There is no Shop defined for you to sell products from, or it isn't getting set when you create an RFQ.

To set one:

1) Make sure Manage multiple shops is checked under Settings --> Configuration --> Sales in the Quotations and Sales Orders section.

2) Refresh the User Interface in the web client by refreshing the page in your browse, or clicking in the bottom half of the company logo in the top left corner of the page.

3) Make sure there is a shop set for your company under Sales --> Configuration --> Shop

The shop dropdown is now added to the RFQ and Sales Order forms, so you can make sure one is selected before confirming,

By the way, this problem indicates an incorrect configuration somewhere during the setup of your database.

Ray.

0
Avatar
Buang
Marcelo Ruiz
Penulis

Hi Ray. Thanks for your answer. Settings -> Configuration -> Sales -> Quotations and Sales Orders -> Manage multiple shops was already set. Sales --> Configuration --> Shop already has a shop defined with its warehouse. Now, in the RFQ there is no shop dropdown. There is a warehouse one, which points to the one shown in the shop configuration. I also tried to create a purchase order directly from Purchases -> Purchase Orders -> Create but I cannot do it: it forces me to create a RFQ. Am I doing something wrong? Thanks again!

Ray Carnes

I posted assuming you mean a Sales Quotation. For a Purchase Quotation, do you have a value in the DESTINATION field on the INCOMING SHIPMENTS AND INVOICES tab?

Marcelo Ruiz
Penulis

Sorry, I thought RFQ were only for purchases. Yes, in the Incomming shipments and invoices tab of the RQF the destination is: Physical Locations / Ambitious Plumbing Enterprises / Stock I am trying to follow the tutorial (a nightmare so far, mainly due to multiple omissions), so I assume there might be a configuration problem somewhere, but I can't find it...

Ray Carnes

The error indicates that "Destination" does not have a value. If you have a value there I'm not sure what is going on.

Marcelo Ruiz
Penulis

Thanks for your time. I am totally clueless about what's going on. Unfortunately OpenERP is not giving me a good first impression...

Ray Carnes

Try one of the builds on runbot.openerp.com - you can test out a database that is configured correctly.

Avatar
Marcelo Ruiz
Penulis Jawaban Terbai

Well, I am stuck with the tutorial until I solve this problem. Just in case, this is the stacktrace:

2013-09-01 20:34:39,706 2840 ERROR testing openerp.sql_db: bad query: insert into "stock_move" (id,"product_uos_qty","date_expected","product_uom","price_unit","product_uos","move_dest_id","product_qty","date","partner_id","product_id","name","auto_validate","location_id","company_id","priority","state","location_dest_id","purchase_line_id","picking_id",create_uid,create_date,write_uid,write_date) values (10,'10.000','2013-08-31 16:00:00',1,'56.00',1,NULL,'10.000','2013-08-31 16:00:00',6,2,'Titanium Alloy Radiator','False',NULL,1,'1','draft',12,1,10,1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'))
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "location_id" violates not-null constraint

2013-09-01 20:34:39,733 2840 ERROR testing openerp.tools.safe_eval: Cannot eval u'action_picking_create()'
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/tools/safe_eval.py", line 241, in safe_eval
    return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 374, in function_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/addons/purchase/purchase.py", line 699, in action_picking_create
    picking_ids.extend(self._create_pickings(cr, uid, order, order.order_line, None, context=context))
  File "/usr/lib/pymodules/python2.7/openerp/addons/purchase/purchase.py", line 687, in _create_pickings
    move = stock_move.create(cr, uid, self._prepare_order_line_move(cr, uid, order, order_line, picking_id, context=context))
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 4436, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "location_id" violates not-null constraint

2013-09-01 20:34:39,774 2840 ERROR testing openerp.netsvc: Integrity Error
The operation cannot be completed, probably due to the following:
- deletion: you may be trying to delete a record while other records still reference it
- creation/update: a mandatory field is not correctly set

[object with reference: location_id - location.id]
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 172, in wrapper
    netsvc.abort_response(1, _('Integrity Error'), 'warning', msg)
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 71, in abort_response
    raise openerp.osv.osv.except_osv(description, details)
except_osv: ('Integrity Error', 'The operation cannot be completed, probably due to the following:\n- deletion: you may be trying to delete a record while other records still reference it\n- creation/update: a mandatory field is not correctly set\n\n[object with reference: location_id - location.id]')
2013-09-01 20:34:39,826 2840 INFO testing werkzeug: 127.0.0.1 - - [01/Sep/2013 20:34:39] "POST /web/dataset/exec_workflow HTTP/1.1" 200 -

Any help will be appreciated. Thanks!

0
Avatar
Buang
Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar
Post Terkait Replies Tampilan Aktivitas
Confirmed POs shall not be editable by Users?
confirmation purchase_order
Avatar
1
Mar 15
4868
Button to "Confirm Order" Purchase Order not appearing
confirmation purchase_order
Avatar
Avatar
1
Mar 15
9424
how to control workflow functions in openerp
workflow confirmation purchase_order
Avatar
0
Mar 15
4774
importing Purchase Order shown as a RFQ Diselesaikan
purchase_order
Avatar
Avatar
Avatar
2
Mei 25
2803
Create a PO without adding products to stock
purchase_order
Avatar
Avatar
Avatar
Avatar
3
Des 24
8369
Komunitas
  • Tutorial-tutorial
  • Dokumentasi
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Terjemahan
Layanan
  • Odoo.sh Hosting
  • Bantuan
  • Peningkatan
  • Custom Development
  • Pendidikan
  • Temukan Akuntan
  • Temukan Mitra
  • Menjadi Partner
Tentang Kami
  • Perusahaan kami
  • Aset Merek
  • Hubungi kami
  • Tugas
  • Acara
  • Podcast
  • Blog
  • Pelanggan
  • Hukum • Privasi
  • Keamanan
الْعَرَبيّة 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 adalah rangkaian aplikasi bisnis open source yang mencakup semua kebutuhan perusahaan Anda: CRM, eCommerce, akuntansi, inventaris, point of sale, manajemen project, dan seterusnya.

Mudah digunakan dan terintegrasi penuh pada saat yang sama adalah value proposition unik Odoo.

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