unique multiple fields

1 Odpovědět

15523 Zobrazení

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

Nejlepší odpověď

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

Autor

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

Autor

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

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

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

Přihlásit se

Related Posts	Odpovědi	Zobrazení
How to Log SQL Queries Related to Odoo Accounting Transactions? Vyřešeno accounting log sql queries	1 bře 25	3214
Compute Function to compute invoice_cash_rouding_id try to delete posted entries accounting invoices invoice.line odoo16features	0 srp 23	2238
Why did my Partial Payment mark the Invoice as "Fully Paid"? accounting	0 úno 26	5
𝘾𝘼𝗡𝗖𝗘𝗟𝗔𝗥 𝗥𝗘𝗦𝗘𝗥𝗩𝗔 𝗘𝙓𝙋𝙀𝘿𝗜𝗔 𝗕𝗥𝗔𝗦𝗜𝗟~Como cancelar uma reserva no Expedia?-[\|\| शिव सदा सहायते👣] accounting	0 úno 26	47
Odoo 19.0 - import records from previous years accounting	1 úno 26	131

This question has been flagged

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