Contributors mailing list archives

Browse archives


Re: stock: Retroactively removing lots from incompatible products in stock move history

Sunflower IT, Tom Blauwendraat
- 07/01/2022 11:05:22

On 1/7/22 10:47 AM, Carmen Bianca Bakker wrote:
I have also verified that the quantities in
the inventory have correctly added up (the quantities of bottles that
previously had lots are added to the lot-less bottles).

I think at least for the stock_quant table, this is all you had to verify, and you have, so that's fine.

As for the modification that you did in "stock_move_line", I'm less sure - you're changing history there. I'm also not sure if doing that was really necessary to achieve your goal to make the inventory work again.

If you want to be sure, I would revert the stock move line table to a recent backup, and then do some more testing in a test database if that modification is really necessary.