Bỏ qua để đến Nội dung
Câu hỏi này đã bị gắn cờ
accountingsqlinvoice.line
1 Trả lời
15242 Lượt xem
Ảnh đại diện
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

Ảnh đại diện
Huỷ bỏ
Ảnh đại diện
Hardikgiri Goswami
Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ
Fongoh Tayong
Tác giả

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
Tác giả

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

Bài viết liên quan Trả lời Lượt xem Hoạt động
How to Log SQL Queries Related to Odoo Accounting Transactions? Đã xử lý
accounting log sql queries
Ảnh đại diện
Ảnh đại diện
1
thg 3 25
2626
Compute Function to compute invoice_cash_rouding_id try to delete posted entries
accounting invoices invoice.line odoo16features
Ảnh đại diện
0
thg 8 23
2021
I found a small typo in the Odoo 19 Chart of Accounts — and it made my day 😆 Đã xử lý
accounting
Ảnh đại diện
Ảnh đại diện
Ảnh đại diện
2
thg 11 25
290
Invoice-Digitize-Individual Line Items
accounting
Ảnh đại diện
Ảnh đại diện
1
thg 11 25
464
How can I manipulate the email template when sending an email in Accounting so that my PDF with the XML is inserted instead of the standard view with XML?
accounting
Ảnh đại diện
Ảnh đại diện
1
thg 11 25
339