Helllo,

In my product list, i've got the same product up to 5 or 6 times. I'd like to delete them, but i'm unable to do so because of this message :
"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: Stock Move - stock.move]"

The only stock move is an inventory, which appears into the Tracability / Stock moves (a line which begins with INV).
This lines is also impossible to delete.

Except attacking the database, which can corrupt the whole things, does anyone have an idea to help us ?

Thanks

The old fashioned way was to change the description to "zzz do not use", change status to inactive and uncheck the can be sold, can be purchased check boxes. If you still want the descriptions to be meaningful, just do the last two.

That's too bad that even the administrator cannot remove that..

ANyone tried to remove these points by PostgreSQL (kind of alter table or something else) ?

Thank you

No, although I've hacked similar this one is quite tricky.

You will need to delete the stock moves first, although the stock move will have created account moves so you will need to delete those before the stock moves. Also probably the inventory stocktake. Just depends you need to check the openerp objects and see what their delete setting is for related objects, whether it is set null, cascade or the other one.

You should try and delete those in the client first, and definitely the products. The module which allows cancelling journal entries might be handing.

Never ever do a physical delete of a record in OpenERP. You will leave the database in an inconsistent state. Just mark the record as inactive, that will do the trick

First delete that product from stock moves and then try deleting it from product list...


Regards,
Arsalan Ali
OpenERP Developer,
Karachi, Pakistan

Morillo what are you on about? I delete products that users have created in error just about every day. The whole point of the ondelete flag is to manage database referential integrity. Otherwise what is the point of the delete button?