unique multiple fields

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

客戶關係
e-Commerce
會計
庫存
PoS
Project
MRP

All apps

所有帖文人獎章

標籤（查看所有）

odoo accounting v14 pos v15

關於此討論區

支援

unique multiple fields

accounting sql invoice.line

1 回覆

14449 瀏覽次數

Fongoh Tayong

I am customizing accounts module.

I want to make sure that an item is not added multiple times on an invoice(account.invoice.line).

From this question, https://www.odoo.com/forum/help-1/question/how-to-make-a-unique-field-in-a-module-16386, i came out with a solutions which does not work and dont know why.

_name = "account.invoice.line"	
_inherit = "account.invoice.line"

#other code

_sql_constraints = [
 ('unique_product', 'unique(id, product_id)', 'Cannot Use one tracker twice!\nPlease, select a different product')
	]

It still allows me to add same product twice.
Please, where am i going wrong?

Thanks for your reply

Hardikgiri Goswami

最佳答案

Hi Fongoh,

I think following code will be helpful to you. Please try with this code.

_name = "account.invoice.line"	_inherit = "account.invoice.line"
#other code
_sql_constraints = [ ('unique_product', 'unique(invoice_id, product_id)', 'Cannot Use one tracker twice!\nPlease, select a different product')	]

Instead of "id", you can try with "invoice_id".

Regards,

Hardik

Fongoh Tayong

作者

I tried that but not change. I even tried using a field(in the unique constraint) that is not in the model but it did not raise any error/exception of field not found. I thought it would have raised an exception that field not found but was supprised it just went pass that and could still have duplicate product selection.

Fongoh Tayong

作者

Oh, thanks hardikgiri, it worked. It was actually failing to add because the constraint had already been violated by an entry in the db so the error was being shown on the command line (was expecting a browser error). So as soon as i removed the record that violdated the constraint, and restarted odoo, it added the constraint and now, no duplicate product can be entered. Thanks man. Marked succesfull.

Christian FOMEKONG

Thanks Hardikgiri, it's working very well for me

喜歡這則討論？不要只閱讀，加入發表意見吧！

今天就建立帳戶，享受獨家功能，與我們精彩的社群互動！

註冊

相關帖文	回覆	瀏覽次數
How to Log SQL Queries Related to Odoo Accounting Transactions? 已解決 accounting log sql queries	1 3月 25	1556
Compute Function to compute invoice_cash_rouding_id try to delete posted entries accounting invoices invoice.line odoo16features	0 8月 23	1467
Codabox connection accounting	0 8月 25	40
How to format a General Ledger import from QBO? accounting	1 8月 25	242
Listing all Invoices with their line items and custom Product fields accounting	0 8月 25	404

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！