Skip to Content
This question has been flagged
pricelist
3 Replies
2076 Views
Avatar
ODBWilson

Hi,

Odoo community version 14.

I got the following errors when deleting newly created pricelist

"Validation Error
The operation cannot be completed: another model requires the record being deleted. If possible, archive it instead.
Model: Sales Order (sale.order), Constraint: sale_order_pricelist_id_fkey"

Thanks

Avatar
Discard
Avatar
Husain Rangwala
Best Answer

Hello ODBWilson

you are trying to delete pricelist which is already used in sale order.so you are not allowed to delete that pricelist.

Try to delete pricelist by archiving sale order which is having this pricelist set.

Hope this will help.

Thanks 

Avatar
Discard
Ermin Trevisan

Archiving the sale order does not help, because it will still refer to the pricelist.

Avatar
Ermin Trevisan
Best Answer

There are objects in the database - in this case sale orders - which are refering to this pricelist. Therefore it can not be deleted. You should change or delete the refering objects first.

Avatar
Discard
Avatar
ODBWilson
Author Best Answer

Thanks for your help. Archiving price list would do.  I will try to delete related sale orders later to see.

Thanks!

Avatar
Discard
Related Posts Replies Views Activity
Update the default pricing list for a company in Sales Solved
pricelist
Avatar
Avatar
1
Dec 24
822
how to add product category field into product pricelist report in odoo
pricelist
Avatar
0
Apr 24
247
Pricelist not applied to all products
pricelist
Avatar
1
May 23
1197
Import pricelist !!! Solved
pricelist
Avatar
Avatar
1
Nov 22
4776
Price matrix for different products for the same customer
pricelist
Avatar
0
Aug 22
741